Mohammad Nazmul Huda Rubol Chowdhury (https://rubol32.wixsite.com/nazmul/about): March 2014

Monday, March 31, 2014

SP Function C#.Net

public DataTable GetFeeDiscloseRecurringFees(string planNumber)

{

dtData = new DataTable();

string query;

try

{

query = "pr_GetFeeDiscloseRecurringFees";

this.DataContext.Connect();

this.DataContext.Connection.RefeshParameters();

this.DataContext.Connection.AddParameter("@PlanNumber", _JULY_Library.clsConnection.enmDbType.Integer, planNumber);

dtData = this.DataContext.Connection.GetDataTable(query, CommandType.StoredProcedure, "", true);

return dtData;

}

catch (Exception ex)

{

throw ex;

}

USE[TPAManager_be]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

ALTER PROC [dbo].[pr_GetFeeDiscloseRecurringFees]

@PlanNumber int

SET NOCOUNT ON

Select Payee as provider,ServiceType, PaymentMethod, PaymentInterval,FeeName

, Case when[AmountType]='Percent'then dbo.fnFormatPercentage([FeeAmount],NoOfDecimals)

ELSE dbo.fnFormatCurrency([FeeAmount],NoOfDecimals) END ASAnnualFeeAmount

, DBO.fnFormatWithUnitTypeInputMast(ISNULL([Quantity], 0),[UnitTypeInputMask],0)AS CurrentQuantity

--Case when FeeID in(22,86) then 0 Else NoOfDecimals End) AS CurrentQuantity

, dbo.fnFormatCurrency([AnnualFee],0) AS ProjectedAnnualFee

--Case when FeeID in(22,86) then 0 Else NoOfDecimals End) AS ProjectedAnnualFee

fromvw_FeeDisclosureRecurringFeeDetails

WHEREPlanNumber =@PlanNumber

ORDER BYSequenceNumber

ALTER FUNCTION [dbo].[fnFormatWithUnitTypeInputMast](@value Decimal(24, 7), @UnitTypeInputMask varchar(50),@NumberOfDecimals int)

RETURNS VARCHAR(32)

BEGIN

DECLARE @temp varchar(38)

SET @value = ISNULL(@value, 0)

IF@UnitTypeInputMask = 'Currency'

SET@temp = DBO.fnFormatCurrency(@Value,@NumberOfDecimals)

ELSE

SET@temp = DBO.fnFormatDecimal(@Value, CAST(@UnitTypeInputMask as Int))

RETURN @temp

END

ALTER FUNCTION [dbo].[fnFormatCurrency] (@value Decimal(24, 7),@NumberOfDecimals int)

RETURNS VARCHAR(32)

BEGIN

DECLARE@temp varchar(38),

@NegYN BIT

SET@value = ISNULL(@value, 0.00)

IF@value < 0.00

BEGIN

SET @NegYN = 1

SET @value = ABS(@VALUE)

END

ELSE

BEGIN

SET @NegYN = 0

END

IF@NumberOfDecimals > 0

BEGIN

SET @temp = PARSENAME(Convert(varchar,Convert(money,@value),1),2)

SET @temp = @temp + RIGHT(str(@value, 32,@NumberOfDecimals) ,@NumberOfDecimals + 1)

END

ELSE

BEGIN

SET @temp = PARSENAME(Convert(varchar,Convert(money,cast(round(@Value, 0) as bigint)),1),2)

END

if@NegYN = 1

SET @temp = '($' + @temp + ')'

ELSE

SET @temp = '$' + @temp

RETURN@temp

END

Thursday, March 27, 2014

<asp:DropDownList ID="ddlSearch" DataTextField="COLUMN_NAME" runat="server"></asp:DropDownList>

namespace Redhawk.Signal.Newsletter.Web.Pages.Modal
{
public partial class Search : System.Web.UI.Page
{
string tableName;
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
tableName = Request.QueryString["tableName"];
if(!string.IsNullOrEmpty(tableName))
{
this.LoadSearchDropdownList(tableName);
}
}
}

private void LoadSearchDropdownList(string tableName)
{
List<Column> lst = new List<Column>();
var _dbCon = new RedhawkSignalNewsletterEntities();
var ds = from t1 in _dbCon.Database.SqlQuery<Column>("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME ='" + tableName.ToString() + "'" )
select t1;
if (tableName == "Templates")
foreach (var m in ds)
{
if (m.COLUMN_NAME == "TemplateName" || m.COLUMN_NAME == "TemplateBody" || m.COLUMN_NAME == "TemplateDescription")
lst.Add(m);
}
else if (tableName == "fund")
{
foreach (var m in ds)
{
if (m.COLUMN_NAME == "FundName" || m.COLUMN_NAME == "Ticker")
lst.Add(m);
}
}
ddlSearch.DataSource = lst.ToList();
ddlSearch.DataBind();
}

protected void btnSearch_Click(object sender, EventArgs e)
{
string columnName = ddlSearch.SelectedValue;
string columnValue = txtSearchValue.Text.Trim();
string tbl = Request.QueryString["tableName"];
//string logoutRedirectURL = ("~/Pages/Home.aspx");
//string logoutRedirectURL = ("~/Pages/Home.aspx?tbl=" + tbl);
string logoutRedirectURL = ("~/Pages/Home.aspx?colName=" + columnName + "&colValue=" + columnValue);
Response.Redirect(logoutRedirectURL,true);
// Response.Redirect("~/Home.aspx");
}
}

public class Column
{
public string COLUMN_NAME { get; set; }
}
}

*********************************************************************************

public class ProductUser
    {
        public int ProductId { set; get; }
        public string ProductName { set; get; }
    }

 public ProductUser FiduciaryKProductByUser(int userId)
        {
            using (dbcntx = new FiduciaryKEntities())
            {
 var SQL = " SELECT vw_FiduciaryKProduct.Id AS ProductId, vw_FiduciaryKProduct.ProductName   FROM FiduciaryK_User INNER JOIN   FiduciaryK_ReferralChannel ON FiduciaryK_User.ReferralId = FiduciaryK_ReferralChannel.ReferralId INNER JOIN  FiduciaryK_ChannelProduct CROSS JOIN  vw_FiduciaryKProduct ON FiduciaryK_ChannelProduct.ProductId = vw_FiduciaryKProduct.Id  where FiduciaryK_User.Id=" + userId;
                ProductUser productUser = dbcntx.Database.SqlQuery<ProductUser>(SQL).First();
                return productUser;
            }
        }

***********************************************************************************************************

Formatting

asp:GridView

<asp:BoundField DataField="DueDate" HeaderText="Date Requested" SortExpression="DueDate" DataFormatString="{0:M/d/yyyy}" >

<asp:BoundField DataField="PlanAsset" HeaderText="Assets" SortExpression="PlanAsset" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:C2}"> <HeaderStyle />

***************************************************
<asp:TemplateField HeaderText="End Date">
<ItemTemplate>

<asp:Label ID="lblEndDate" runat="server" Text='<%# Eval("EndDate","{0:MM/d/yyyy}") %>'> </asp:Label>

</ItemTemplate>

<HeaderTemplate>

<asp:LinkButton ID="lnEndDate" runat="server" Text="End Date" OnClick="lnEndDate_Click">

</asp:LinkButton>

</HeaderTemplate>

<HeaderStyle Width="12%" />

<ItemStyle Width="12%" />

</asp:TemplateField>
***********************************************************************

 string CensusFileUrl = null;

Session["DataItemName"].ToString();

Session["AllocationNumber"] != null
 Session["PrevccStatusID"] = null,""; 
((Label)Master.FindControl("lblMstrHead")).Text = "Retirement Solutions"; 
Session["InvestmentGroupID"] = Request.QueryString["InvestmentGroupID"];
int.Parse(Session["ProductId"].ToString())
int refId = Convert.ToInt32(Session["UserRefflId"].ToString()); 

Session["SelectedMenuName"] = "investmentPaging";

protected string SelectedMenuName         {             get             { return Session["SelectedMenuName"] != null ? Session["SelectedMenuName"].ToString() : "";            }         }

        if (resultSet.Count() != 0)
            {   grdInvestment.DataSource = resultSet;                 grdInvestment.DataBind();             }           else             {   this.lblMsg.Attributes.CssStyle.Add("font-size", "30px")                 lblMsg.Text = "Information not found";             }

        string tableName;
        if(!Page.IsPostBack)
            {            
                tableName = Request.QueryString["tableName"];
                if(!string.IsNullOrEmpty(tableName))
                {
                    this.LoadSearchDropdownList(tableName);
                }
            }

if (Request.QueryString["ProductId"] !=null )                 {                     Session["ProductId"] = Request.QueryString["ProductId"];                     Session["InvestmentGroupID"] = null;                 } 
Conditional (Ternary) Operator (?:)

condition ? first_expression : second_expression;

int input = Convert.ToInt32(Console.ReadLine());
string classify;

// if-else construction.
if (input > 0)
    classify = "positive";
else
    classify = "negative";

// ?: conditional operator.
classify = (input > 0) ? "positive" : "negative";

?? operator is called the null-coalescing operator.
The null-coalescing operator (??) is used to define a default value for a nullable type. It returns the left-hand operand if it is not null; otherwise it returns the right operand. When we work with databases, we often deal with absent values. These values come as nulls to the program. This operator is a convenient way to deal with such situations.
http://weblogs.asp.net/scottgu/archive/2007/09/20/the-new-c-null-coalescing-operator-and-using-it-with-linq.aspx







MVC

<td >
                @string.Format("{0:MM/dd/yyyy}", item.DOB)
  </td>

<td>
               @item.TypeName
     </td>



DateTime dtTransEffectiveDate = Convert.ToDateTime(((DataRow)drData)["TransEffectiveDate"].ToString());
string TransEffectiveDate = String.Format("{0:MM/dd/yyyy}", dtTransEffectiveDate); //dtTransEffectiveDate.ToString("MM/dd/yyyy");






form1099R.EndDate = dataRow["EndDate"] == DBNull.Value ? null : (DateTime?)dataRow["EndDate"];
form1099R.DateUpload = dataRow["DateUpload"] == DBNull.Value ? DateTime.Now.AddDays(-31) : (DateTime?)dataRow["DateUpload"];
txtPlanTax.Text = planTaxID.Substring(0, 2) + "-" + planTaxID.Substring(2, planTaxID.Length - 2);




 @if(imagePath != ""){
            <img src="@imagePath" alt="Sample Image" width="300px" />
        }

Sunday, March 16, 2014

window.July = {};

July.Common = {};

July.Client = {};

Company

Index.cshtml(Queue)

<a class="action action-add" id="add-Queue" href="javascript:"><i class="add-icon-for-con"></i></a>
<a class="action action-edit" id="edit-Queue" href="javascript:"><i class="edit-icon-for-con"></i></a>

<div id="divQueue"></div>
<script src="~/Scripts/application/project/QueueData.js"></script>

<script>
var queuelist = new July.Project.QueueList();
queuelist.init();
</script>

Queue

/*==== Created By : Rubol
* Date Created : August 05,2013
========================================*/
(function (Project) {
function QueueList() {
/*Private*/
function addQueue() {
util.ShowIDPDialog(util.FullURLByAction('Queue/Create'), 600, 'Queue', 'Queue', null, 300);
}
function editQueue(id) {
if (id) {
util.ShowIDPDialog(util.FullURLByAction('Queue/Edit/' + id), 600, 'Queue', 'NULL', id, 180);
}
else {
$.messager.alert('Information', 'Please select a row to edit.');
}
}
//public
return {
init: function () {

$("#add-Queue").click(function () {
addQueue();
});
$("#edit-Queue").click(function () {
var grid = $("#grid-Queue").data("kendoGrid");
var row = grid.select();
var dataItem = grid.dataItem(row);
if (!dataItem) $.messager.confirm('Warning', 'Please select a row first.');
var id = dataItem.Id;
editQueue(id);
});
$("#grid-Queue").dblclick(function (e) {
var grid = $("#grid-Queue").data("kendoGrid");
var row = grid.select();
var dataItem = grid.dataItem(row);
var id = dataItem.Id;
editQueue(id);
});

}
}
}
July.Project.QueueList = QueueList;
function QueueForm() {
/*Private*/
function SaveQueue(action) {
action = util.FullURLByAction(action);
$.ajax({
url: action,
type: 'POST',
data: $('#QueueForm').serialize(),
dataType: 'json',
async: false,
success: function (result) {
// $("#divQueue").dialog("close");
if (result) {
util.CallParentFunction('ReloadGrid');
util.CloseIFrame(this);
}
else {
return false;
}
}
});

}
function deletequeuebyid(id) {

$.messager.confirm('confirm', 'are you sure, you want to delete this record?', function (r) {

if (r) {
$.ajax({
url: util.FullURLByAction('Queue/deletequeuebyid/' + id),
type: 'post',
async: false,
success: function (result) {
util.CallParentFunction('ReloadGrid');
util.CloseIFrame(this);
}
});
}
else {
alert("failed to delete item.");
}
});

}
//public
return {
init: function () {

//var data = [
// { name: "Name1", value: 1 },
// { name: "Name2", value: 2 },
// { name: "Name3", value: 3 }
//];
//var dataSource = new kendo.data.DataSource({
// transport: {
// read: {
// url: "http://demos.telerik.com/kendo-ui/service/products",
// dataType: "jsonp"
// }
// }
//});

//$("#BusinessCodeId").kendoDropDownList({
// dataTextField: "name",
// dataValueField: "value",
// optionLabel: "Select Name",
// dataSource: {
// data: data
// }
//});
var validator = $("#QueueForm").kendoValidator().data("kendoValidator");

$("span.k-dropdown").focusout(function () {
validator.validate();
});
$("#lnkQueueSave").click(function () {

var action = 'Queue/SaveQueue';
if ($("input[id='Id']").val() == '00000000-0000-0000-0000-000000000000') {

if (validator.validate()) {
SaveQueue(action);
$("#divQueue").window("close");
}
}
else {
if (validator.validate()) {
$.messager.confirm('Confirm', 'Are you sure you want to save record?', function (r) {
if (r) {
action = 'Queue/SaveQueue';
SaveQueue(action);
}
else {
return false;
}
});
}
}
});
$("a[id=lnkQueueDelete]").click(function () {
// alert("object");
var queueId = $(":input[name='Id']").val();
deletequeuebyid(queueId);
});
}
}
}
July.Project.QueueForm = QueueForm;
}(July.Project));

Monday, March 31, 2014

SP Function C#.Net

Thursday, March 27, 2014

EDMX

Formatting

Conditional (Ternary) Operator (?:)

condition ? first_expression : second_expression;

Sunday, March 16, 2014

July.Common = {};

July.Client = {};

Company

Index.cshtml(Queue)

Queue