protected void PopulateMemberGroup()
{
BusinessLayer.Common.MemberGroup objMemberGroup = new BusinessLayer.Common.MemberGroup();
memberGroup = objMemberGroup.GetMemberGroupById(MemberGroupId);
if (memberGroup != null)
{
MemberGroupId = memberGroup.MemberGroupId;
txtMemberGroupName.Text = memberGroup.MemberGroupName.ToString();
txtRemarks.Text = memberGroup.Remarks.ToString();
Message.Show = false;
btnSave.Text = "Update";
}
}
public static Entity.Common.MemberGroup GetMemberGroupById(int memberGroupId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pMemberGroupId", SqlDbType.Int, ParameterDirection.Input, memberGroupId);
SqlDataReader dr = oDm.ExecuteReader("MemberGroup_GetById");
Entity.Common.MemberGroup memberGroup = new Entity.Common.MemberGroup();
if (dr.HasRows)
{
while (dr.Read())
{
memberGroup.MemberGroupId = memberGroupId;
memberGroup.MemberGroupName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
memberGroup.Remarks = (dr[2] == DBNull.Value) ? "" : dr[2].ToString();
}
}
return(memberGroup);
}
}
public static void Save(Entity.Common.MemberGroup membergroup)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pMemberGroupId", SqlDbType.Int, ParameterDirection.InputOutput, membergroup.MemberGroupId);
oDm.Add("@pMemberGroupName", SqlDbType.VarChar, 50, membergroup.MemberGroupName);
if (membergroup.Remarks == string.Empty)
{
oDm.Add("@pRemarks", SqlDbType.VarChar, 200, string.Empty);
}
else
{
oDm.Add("@pRemarks", SqlDbType.VarChar, 200, membergroup.Remarks);
}
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("MemberGroup_Save");
membergroup.MemberGroupId = (int)oDm["@pMemberGroupId"].Value;
}
}
public void Save(Entity.Common.MemberGroup membergroup)
{
DataAccess.Common.MemberGroup.Save(membergroup);
}