public decimal GetTotalPaymentsOf(string srDsrId, string companyId, DateTime paymentDate)
{
DbCommand comm = null;
decimal totalPayment = 0;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = @"SELECT TotalPayment FROM IM_SR_DSR_PAYMENT_DETAILS WHERE SrId = @SrId AND CompanyId = @CompanyId AND PaymentDate = @PaymentDate";
CreateParameter.AddParam(comm, "@SrId", srDsrId, DbType.String);
CreateParameter.AddParam(comm, "@CompanyId", companyId, DbType.String);
CreateParameter.AddParam(comm, "@PaymentDate", paymentDate.Date, DbType.DateTime);
DbDataReader dr = GenericDataAccess.ExecuteQuery(comm);
if (dr.Read())
{
totalPayment = NullHandler.GetDecimal(dr["TotalPayment"]);
}
}
catch (Exception ex)
{
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(totalPayment);
}
private DetailPaymentInfo MapPayment(DbDataReader dr)
{
DetailPaymentInfo detailPaymentInfo = new DetailPaymentInfo();
detailPaymentInfo.PaymentId = NullHandler.GetString(dr["PaymentId"]);
detailPaymentInfo.Id = NullHandler.GetString(dr["SrId"]);
detailPaymentInfo.CompanyId = NullHandler.GetString(dr["CompanyId"]);
detailPaymentInfo.PaymentDate = NullHandler.GetDateTime(dr["PaymentDate"]);
detailPaymentInfo.ThousendCount = NullHandler.GetInt32(dr["ThousendCount"]);
detailPaymentInfo.FiveHundredCount = NullHandler.GetInt32(dr["FiveHundredCount"]);
detailPaymentInfo.OneHundredCount = NullHandler.GetInt32(dr["OneHundredCount"]);
detailPaymentInfo.FiftyCount = NullHandler.GetInt32(dr["FiftyCount"]);
detailPaymentInfo.TwentyCount = NullHandler.GetInt32(dr["TwentyCount"]);
detailPaymentInfo.TenCount = NullHandler.GetInt32(dr["TenCount"]);
detailPaymentInfo.FiveCount = NullHandler.GetInt32(dr["FiveCount"]);
detailPaymentInfo.TwoCount = NullHandler.GetInt32(dr["TwoCount"]);
detailPaymentInfo.OneCount = NullHandler.GetInt32(dr["OneCount"]);
detailPaymentInfo.TotalPayment = NullHandler.GetDecimal(dr["TotalPayment"]);
return(detailPaymentInfo);
}
/// <summary>
/// Binds a Dropdownlist Controls to a Collection
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="ddl"></param>
/// <param name="entities"></param>
/// <param name="displayField"></param>
/// <param name="valueField"></param>
//public static void BindDropDownList<T>(DropDownList ddl, IList<T> entities, String displayField, String valueField)
// where T : BaseEntity
//{
// if (entities == null || entities.Count == 0)
// {
// if (ddl.Items.Count > 0)
// ddl.Items.Clear();
// ddl.DataSource = null;
// ddl.DataBind();
// }
// else
// {
// ddl.DataSource = entities;
// ddl.DataTextField = displayField;
// ddl.DataValueField = valueField;
// ddl.DataBind();
// }
// ddl.Items.Insert(0, new ListItem(String.Empty, String.Empty));
//}
/// <summary>
/// Binds a Dropdownlist to a DataTable
/// </summary>
/// <param name="ddl"></param>
/// <param name="dt"></param>
/// <param name="displayField"></param>
/// <param name="valueField"></param>
//public static void BindDropDownList(DropDownList ddl, DataTable dt, String displayField, String valueField)
//{
// if (dt == null || dt.Rows.Count <= 0)
// {
// if (ddl.Items.Count > 0)
// ddl.Items.Clear();
// ddl.DataSource = null;
// ddl.DataBind();
// }
// else
// {
// ddl.DataSource = dt.DefaultView;
// ddl.DataTextField = displayField;
// ddl.DataValueField = valueField;
// ddl.DataBind();
// }
// ddl.Items.Insert(0, new ListItem(String.Empty, String.Empty));
//}
/// <summary>
/// Adds Client Side Confirmation Text to a Server Side Button Control according to the Validation Group
/// </summary>
/// <param name="btn"></param>
/// <param name="message"></param>
/// <param name="isSaveButton"></param>
//public static void AddCorfirmation(Button btn, String message, bool isSaveButton)
//{
// if (isSaveButton)
// {
// if (!btn.ValidationGroup.IsNullOrEmpty())
// btn.Attributes.Add("ValidationGroupName", btn.ValidationGroup);
// btn.Attributes.Add(AppConstants.CONFIRMATION_MSG_CUSTOM_ATTR, message);
// btn.Attributes["onclick"] = "return ShowSaveConfirmation(this);";
// }
// else
// btn.Attributes["onclick"] = String.Format("return confirm('{0}');", message);
//}
/// <summary>
/// Creates a Uniques UserID from Organization Code and UserID
/// </summary>
/// <param name="adminSystemUser"></param>
/// <returns></returns>
//public static string GetUserID(App.Models.Admin.AdminSystemUser adminSystemUser)
//{
// return String.Format("{0}{1}", adminSystemUser.OrgCode, adminSystemUser.UserID);
//}
//public static String GetDeleteConfirmation()
//{
// return String.Format("onclick=\"return confirm('Sure to Delete?')\"");
//}
//public static String GetEditPermissionDeniedMessage()
//{
// return String.Format("javascript:alert('{0}');javascript:void(0);", AppConstants.Message.EDIT_PERMISSION_DENIED);
//}
//public static String GetDeletePermissionDeniedMessage()
//{
// return String.Format("javascript:alert('{0}');javascript:void(0);", AppConstants.Message.DELETE_PERMISSION_DENIED);
//}
/// <summary>
/// Returns Formatted Data Returned from a Data Reader or a Data Table Cell
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static String FormatData(object data)
{
if (data.GetType() == typeof(String))
{
return(WebUtil.FormatText(NullHandler.GetString(data)));
}
else if (data.GetType() == typeof(DateTime))
{
return(NullHandler.GetDateTime(data).ToString(AppConstants.ValueOf.DATE_FROMAT_DISPLAY));
}
else if (data.GetType() == typeof(decimal))
{
return(String.Format(AppConstants.ValueOf.DECIMAL_FORMAT, NullHandler.GetDecimal(data)));
}
else if (data.GetType() == typeof(bool))
{
return(NullHandler.GetBoolean(data) ? "Yes" : "No");
}
else
{
return(NullHandler.GetString(data));
}
}
