protected void btnSave_Click(object sender, EventArgs e) { BusinessLayer.Common.MemberSMSCategory objMemberSMSCategory = new BusinessLayer.Common.MemberSMSCategory(); Entity.Common.MemberSMSCategory memberSMSCategory = new Entity.Common.MemberSMSCategory(); memberSMSCategory.MemberSMSCategoryId = MemberSMSCategoryId; memberSMSCategory.MemberSMSCategoryName = txtCategoryName.Text.Trim(); int i = objMemberSMSCategory.MemberSMSCategory_Save(memberSMSCategory); if (i > 0) { LoadMemberSMSCategory(); txtCategoryName.Text = ""; Message.IsSuccess = true; Message.Text = "Member SMS Category successfully saved..."; } else { Message.IsSuccess = false; Message.Text = "Member SMS Category can not save!!!"; } Message.Show = true; }
protected void PopulateMemberSMSCategory() { BusinessLayer.Common.MemberSMSCategory objMemberSMSCategory = new BusinessLayer.Common.MemberSMSCategory(); Entity.Common.MemberSMSCategory memberSMSCategory = new Entity.Common.MemberSMSCategory(); memberSMSCategory = objMemberSMSCategory.MemberSMSCategory_GetById(MemberSMSCategoryId); txtCategoryName.Text = memberSMSCategory.MemberSMSCategoryName; }
public static int MemberSMSCategory_Save(Entity.Common.MemberSMSCategory memberSMSCategory) { using (DataManager oDm = new DataManager()) { oDm.Add("@MemberSMSCategoryId", SqlDbType.Int, ParameterDirection.Input, memberSMSCategory.MemberSMSCategoryId); oDm.Add("@MemberSMSCategoryName", SqlDbType.VarChar, 100, memberSMSCategory.MemberSMSCategoryName); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("usp_MemberSMSCategory_Save")); } }
public static Entity.Common.MemberSMSCategory MemberSMSCategory_GetById(int memberSMSCategoryId) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@MemberSMSCategoryId", SqlDbType.Int, ParameterDirection.Input, memberSMSCategoryId); SqlDataReader dr = oDm.ExecuteReader("usp_MemberSMSCategory_GetById"); Entity.Common.MemberSMSCategory memberSMSCategory = new Entity.Common.MemberSMSCategory(); if (dr.HasRows) { while (dr.Read()) { memberSMSCategory.MemberSMSCategoryId = memberSMSCategoryId; memberSMSCategory.MemberSMSCategoryName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString(); } } return(memberSMSCategory); } }
public int MemberSMSCategory_Save(Entity.Common.MemberSMSCategory memberSMSCategory) { return(DataAccess.Common.MemberSMSCategory.MemberSMSCategory_Save(memberSMSCategory)); }