protected void PopulateMembershipCategory()
{
BusinessLayer.Common.MembershipCategory objMembershipCategory = new BusinessLayer.Common.MembershipCategory();
membershipCategory = objMembershipCategory.GetMembershipCategoryById(MembershipCategoryId);
if (membershipCategory != null)
{
MembershipCategoryId = membershipCategory.MembershipCategoryId;
txtCategoryName.Text = membershipCategory.CategoryName.ToString();
txtRemarks.Text = membershipCategory.CategoryRemarks.ToString();
chkSMSApplicable.Checked = membershipCategory.SMSApplicable;
chkSMSApplicable.Enabled = false;
Message.Show = false;
btnSave.Text = "Update";
}
}
public static void Save(Entity.Common.MembershipCategory membershipcategory)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pMembershipCategoryId", SqlDbType.Int, ParameterDirection.InputOutput, membershipcategory.MembershipCategoryId);
oDm.Add("@pCategoryName", SqlDbType.VarChar, 50, membershipcategory.CategoryName);
if (membershipcategory.CategoryRemarks == string.Empty)
{
oDm.Add("@pCategoryRemarks", SqlDbType.VarChar, 200, DBNull.Value);
}
else
{
oDm.Add("@pCategoryRemarks", SqlDbType.VarChar, 200, membershipcategory.CategoryRemarks);
}
oDm.Add("@pSMSApplicable", SqlDbType.Bit, membershipcategory.SMSApplicable);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("MembershipCategory_Save");
membershipcategory.MembershipCategoryId = (int)oDm["@pMembershipCategoryId"].Value;
}
}
public static Entity.Common.MembershipCategory GetMembershipCategoryById(int membershipCategoryId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pMembershipCategoryId", SqlDbType.Int, ParameterDirection.Input, membershipCategoryId);
SqlDataReader dr = oDm.ExecuteReader("MembershipCategory_GetById");
Entity.Common.MembershipCategory membershipCategory = new Entity.Common.MembershipCategory();
if (dr.HasRows)
{
while (dr.Read())
{
membershipCategory.MembershipCategoryId = membershipCategoryId;
membershipCategory.CategoryName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
membershipCategory.CategoryRemarks = (dr[2] == DBNull.Value) ? "" : dr[2].ToString();
membershipCategory.SMSApplicable = Convert.ToBoolean((dr[3] == DBNull.Value) ? null : dr[3].ToString());
}
}
return(membershipCategory);
}
}
public void Save(Entity.Common.MembershipCategory membershipcategory)
{
DataAccess.Common.MembershipCategory.Save(membershipcategory);
}