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)); } }