protected void btnSave_Click(object sender, EventArgs e) { BusinessLayer.Common.MembershipCategoryFeesConfig objFeesConfig = new BusinessLayer.Common.MembershipCategoryFeesConfig(); Entity.Common.MembershipCategoryFeesConfig FeesConfig = new Entity.Common.MembershipCategoryFeesConfig(); FeesConfig.MembershipCategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue); string strFeesXml = "<NewDataSet>"; foreach (GridViewRow gvr in dgvFeesHead.Rows) { if (gvr.RowType == DataControlRowType.DataRow) { TextBox txtAmount = (TextBox)gvr.FindControl("txtAmount"); strFeesXml += "<Row"; strFeesXml += " FeesHeadId = \"" + dgvFeesHead.DataKeys[gvr.RowIndex].Value.ToString() + "\""; strFeesXml += " Amount = \"" + (string.IsNullOrEmpty(txtAmount.Text.Trim()) ? "0" : txtAmount.Text.Trim()) + "\""; strFeesXml += " />"; } } strFeesXml += "</NewDataSet>"; FeesConfig.FeesXml = strFeesXml; objFeesConfig.Save(FeesConfig); LoadFeesDetails(); Message.IsSuccess = true; Message.Text = "Fees Saved Successfully"; Message.Show = true; }
public static void Save(Entity.Common.MembershipCategoryFeesConfig config) { using (DataManager oDm = new DataManager()) { oDm.Add("@pMembershipCategoryId", SqlDbType.Int, config.MembershipCategoryId); oDm.Add("@pFeesXml", SqlDbType.Xml, config.FeesXml); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_MembershipCategoryFeesConfig_Save"); } }
public void Save(Entity.Common.MembershipCategoryFeesConfig config) { DataAccess.Common.MembershipCategoryFeesConfig.Save(config); }