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