protected void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
membermaster.MemberName = txtMemberName.Text.Trim();
membermaster.MobileNo = txtMobile.Text.Trim();
membermaster.BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue.Trim());
//DataTable dt = objMember.GetAll(membermaster);
DataTable dt = objMember.GetAllMemberWithAmount(membermaster);
if (dt != null)
{
DataView dv = new DataView(dt);
dv.RowFilter = "IsApproved Is Not Null";
dgvMemberMaster.DataSource = dv;
dgvMemberMaster.DataBind();
lblTotalMemberCount.Text = Server.HtmlDecode("<b>Total Member Count: " + dv.ToTable().Rows.Count.ToString() + "</b>");
}
}
public static void MemberMaster_BlockChange_Save(Entity.Common.MemberMaster membermaster)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pOldMemberId", SqlDbType.Int, membermaster.OldMemberId);
oDm.Add("@pMemberCode", SqlDbType.VarChar, 100, ParameterDirection.InputOutput, membermaster.MemberCode);
oDm.Add("@pVillageOrStreet", SqlDbType.VarChar, 200, membermaster.VillageOrStreet);
oDm.Add("@pPlotNo", SqlDbType.VarChar, 100, membermaster.PlotNo);
oDm.Add("@pKhaitanNo", SqlDbType.VarChar, 100, membermaster.KhaitanNo);
oDm.Add("@pMouza", SqlDbType.VarChar, 100, membermaster.Mouza);
oDm.Add("@pJLNo", SqlDbType.VarChar, 100, membermaster.JLNo);
oDm.Add("@pPO", SqlDbType.VarChar, 100, membermaster.PO);
oDm.Add("@pPS", SqlDbType.VarChar, 100, membermaster.PS);
oDm.Add("@pPIN", SqlDbType.VarChar, 10, membermaster.PIN);
oDm.Add("@pBlockId", SqlDbType.Int, membermaster.BlockId);
oDm.Add("@pDistrictId", SqlDbType.Int, membermaster.DistrictId);
oDm.Add("@pStateId", SqlDbType.Int, membermaster.StateId);
oDm.Add("@pEffectiveDate", SqlDbType.DateTime, membermaster.EffectiveDate);
oDm.Add("@pOpBal", SqlDbType.Decimal, membermaster.OpBal);
oDm.Add("@pDrORCr", SqlDbType.VarChar, 2, membermaster.DrORCr);
oDm.Add("@pUserId", SqlDbType.Int, membermaster.UserId);
oDm.Add("@pCompanyId", SqlDbType.Int, membermaster.CompanyId);
oDm.Add("@BranchID_FK", SqlDbType.Int, membermaster.BranchId);
oDm.Add("@FinYearID_FK", SqlDbType.Int, membermaster.FinYearId);
oDm.Add("@DataFlow", SqlDbType.Int, membermaster.DataFlow);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("MemberMaster_BlockChange_Save");
membermaster.MemberCode = (string)oDm["@pMemberCode"].Value;
}
}
private void LoadMemberList(int MemberId)
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.MemberId = MemberId;
membermaster.BlockId = 0;
membermaster.DistrictId = 0;
membermaster.StateId = 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.GetAll(membermaster);
if (dt != null && dt.Rows.Count > 0)
{
dt.AsEnumerable().ToList().ForEach(r => r["Name"] = r["Name"].ToString() + " [" + r["MemberCode"].ToString() + "] [" + r["MobileNo"].ToString() + "]");
}
DataView dv = new DataView(dt);
string strRowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
if (txtMobileNo.Text.Trim().Length > 0)
{
strRowFilter = strRowFilter + " And MobileNo = '" + txtMobileNo.Text.Trim() + "'";
}
dv.RowFilter = strRowFilter;
dv.Sort = "MemberName ASC";
ddlMember.DataSource = dv;
ddlMember.DataBind();
ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
}
private void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = 0;
membermaster.DistrictId = 0;
membermaster.StateId = 0;
//membermaster.BlockId = Session["UserType"].ToString().Equals("Agent") ? Convert.ToInt32(Session["BlockId"]) : 0;
//membermaster.DistrictId = Session["UserType"].ToString().Equals("Agent") ? Convert.ToInt32(Session["DistrictId"]) : 0;
//membermaster.StateId = Session["UserType"].ToString().Equals("Agent") ? Convert.ToInt32(Session["StateId"]) : 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.GetAll(membermaster);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
ddlMember.DataSource = dv;
ddlMember.DataBind();
ddlMember.Items.Insert(0, new ListItem("--Any Member--", "0"));
if (Session["UserType"].ToString().Equals("Member"))
{
ddlMember.SelectedValue = Session["UserId"].ToString();
ddlMember.Enabled = false;
}
else
{
ddlMember.Enabled = true;
}
}
private void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = 0;
membermaster.DistrictId = 0;
membermaster.StateId = 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.GetAll(membermaster);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
ddlMember.DataSource = dv;
ddlMember.DataBind();
ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
if (Session["UserType"].ToString().Equals("Member"))
{
ddlMember.SelectedValue = Session["UserId"].ToString();
ddlMember.Enabled = false;
}
else if (Session["UserType"].ToString().Equals("Admin") && Request.QueryString["MemberId"] != null && Request.QueryString["MemberId"].Trim().Length > 0)
{
ddlMember.SelectedValue = Request.QueryString["MemberId"].ToString();
ddlMember.Enabled = false;
}
else
{
ddlMember.Enabled = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Validate())
{
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
membermaster.LedgerTypeId = ddlLedgerType.SelectedValue;
membermaster.AccountGroupId = Convert.ToInt32(ddlAccountsGroup.SelectedValue);
if (ddlAccountsSubGroup.SelectedIndex == 0)
{
membermaster.AccountSubGroupId = 0;
}
else
{
membermaster.AccountSubGroupId = Convert.ToInt32(ddlAccountsSubGroup.SelectedValue);
}
membermaster.IsCostCenterApplicable = (chkCostCenter.Checked) ? true : false;
objMemberMaster.MemberMasterLedgerDefaultConfiguration_Update(membermaster);
Message.IsSuccess = true;
Message.Text = "Updated Successfully.";
}
}
catch
{
Message.IsSuccess = false;
Message.Text = "Can Not Update!!!";
}
Message.Show = true;
}
protected void LoadMember()
{
ddlMember.Items.Clear();
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
if (ddlBlock.SelectedIndex == 0)
{
membermaster.BlockId = 0;
}
else
{
membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
}
if (ddlDistrict.SelectedIndex == 0)
{
membermaster.DistrictId = 0;
}
else
{
membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
}
if (ddlState.SelectedIndex == 0)
{
membermaster.StateId = 0;
}
else
{
membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
}
if (ddlMembershipCategory.SelectedIndex == 0)
{
membermaster.CategoryId = 0;
}
else
{
membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
}
membermaster.MemberName = string.Empty;
DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster);
if (dt != null)
{
ddlMember.DataSource = dt;
ddlMember.DataTextField = "MemberName";
ddlMember.DataValueField = "MemberId";
ddlMember.DataBind();
}
ddlMember.Items.Insert(0, li);
}
protected void Populate()
{
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster = objMemberMaster.MemberMasterLedgerDefaultConfiguration_Get();
ddlLedgerType.SelectedValue = membermaster.LedgerTypeId;
ddlAccountsGroup.SelectedValue = membermaster.AccountGroupId.ToString();
ddlAccountsSubGroup.SelectedValue = membermaster.AccountSubGroupId.ToString();
chkCostCenter.Checked = Convert.ToBoolean(membermaster.IsCostCenterApplicable);
Message.Show = false;
}
private DataTable getMobileNumbers()
{
BusinessLayer.Common.MemberMaster ObjMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
DataView DV = new DataView(ObjMember.MemberMaster_GetAll_ForSMS(int.Parse(Session["FinYrID"].ToString()), chkIsGovtMember.Checked, (ddlMemberSMSCategory.SelectedIndex == 0) ? 0 : int.Parse(ddlMemberSMSCategory.SelectedValue)));
//if (ChkIncludeGovtMembers.Checked == false)
// DV.RowFilter = "RegistrationType <> 4";
return(DV.ToTable());
}
public static int SMSSubscription_Save(Entity.Common.MemberMaster membermaster)
{
using (DataManager oDm = new DataManager())
{
DataSet ds = new DataSet();
ds.Tables.Add(membermaster.SubscriptionDetails);
oDm.Add("@pSMSSubscriptionDetails", SqlDbType.Xml, ds.GetXml());
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteNonQuery("SMSSubscription_Save"));
}
}
public static DataTable MemberMaster_GetAll_ForReport(Entity.Common.MemberMaster membermaster)
{
using (DataManager oDm = new DataManager())
{
if (membermaster.BlockId == 0)
{
oDm.Add("@BlockId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@BlockId", SqlDbType.Int, membermaster.BlockId);
}
if (membermaster.DistrictId == 0)
{
oDm.Add("@DistrictId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@DistrictId", SqlDbType.Int, membermaster.DistrictId);
}
if (membermaster.StateId == 0)
{
oDm.Add("@StateId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@StateId", SqlDbType.Int, membermaster.StateId);
}
if (membermaster.CategoryId == 0)
{
oDm.Add("@MembershipCategoryId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@MembershipCategoryId", SqlDbType.Int, membermaster.CategoryId);
}
if (membermaster.MemberName == string.Empty)
{
oDm.Add("@MemberName", SqlDbType.VarChar, DBNull.Value);
}
else
{
oDm.Add("@MemberName", SqlDbType.VarChar, membermaster.MemberName);
}
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteDataTable("MemberMaster_GetAll_ForReport"));
}
}
private void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = 0;
membermaster.DistrictId = 0;
membermaster.StateId = 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.GetAll(membermaster);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
}
protected void LoadIDCardDetails()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster = objMember.GetMemberMasterById(MemberId);
if (membermaster != null)
{
ImgID.ImageUrl = "MemberPhoto/" + membermaster.ImageName;
ltrMemberName.Text = "Name : <b><span style='color:#27B3DE;'> " + membermaster.MemberName + "</span></b>";
ltrMemberCode.Text = "Member Code : <span style='color:#3F7FC0;'>" + membermaster.MemberCode + "</span>";
ltrMembershipCategory.Text = "Membership Category : <span style='color:#3F7FC0;'>" + membermaster.CategoryName + "</span>";
ltrCompanyName.Text = "Company Name : <span style='color:#3F976A;'>" + membermaster.CompanyName + "</span>";
ltrValid.Text = "Valid upto : <span style='color:#3F976A;'>" + membermaster.CreateDate.AddYears(1).ToString("MMM yyyy") + "</span>";
//ltrMobile.Text = "Ph.(Member) : <span style='color:#27B3DE;'>" + membermaster.MobileNo + "</span>";
}
}
private void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = 0;
membermaster.DistrictId = 0;
membermaster.StateId = 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.GetAll(membermaster);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1";
dv.Sort = "MemberName ASC";
ddlMember.DataSource = dv;
ddlMember.DataBind();
ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
}
public static void MemberMasterLedgerDefaultConfiguration_Update(Entity.Common.MemberMaster membermaster)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@LedgerTypeId", SqlDbType.VarChar, membermaster.LedgerTypeId);
oDm.Add("@AccountGroupId", SqlDbType.Int, membermaster.AccountGroupId);
if (membermaster.AccountSubGroupId == 0)
{
oDm.Add("@AccountSubGroupId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@AccountSubGroupId", SqlDbType.Int, membermaster.AccountSubGroupId);
}
oDm.Add("@IsCostCenterApplicable", SqlDbType.Bit, membermaster.IsCostCenterApplicable);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("MemberMasterLedgerDefaultConfiguration_Update");
}
}
protected void LoadMember()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = 0;
membermaster.DistrictId = 0;
membermaster.StateId = 0;
membermaster.CategoryId = 0;
membermaster.MemberName = string.Empty;
DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster);
if (dt != null)
{
ddlMember.DataSource = dt;
ddlMember.DataBind();
}
//ddlMember.Items.Insert(0, li);
}
protected void dgvMemberMaster_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Approve"))
{
int MemberId = Convert.ToInt32(e.CommandArgument);
int CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster memberMaster = new Entity.Common.MemberMaster();
objMemberMaster.MemberApprove(MemberId, CreatedBy);
memberMaster = objMemberMaster.GetMemberMasterById(MemberId);
txtApprovedMemberName.Text = memberMaster.MemberName;
txtApprovedMemberCode.Text = memberMaster.MemberCode;
string MobileNo = memberMaster.MobileNo;
StringBuilder sb = new StringBuilder();
sb.Append(@"Dear " + memberMaster.MemberName.ToString() + ", " + "%0a");
sb.Append(@"Your membership subscription has been approved." + "%0a");
sb.Append(@"Code -" + memberMaster.MemberCode.ToString() + "%0a");
sb.Append(@"Date -" + memberMaster.MembershipDate.ToString("dd/MM/yyyy") + "%0a");
sb.Append(@"Category -" + memberMaster.CategoryName.ToString() + "%0a");
sb.Append(@"Thank You" + "%0a");
sb.Append(@"West Bengal Poultry Federation");
string message = sb.ToString();// (sb.ToString().Length > 159) ? sb.ToString().Substring(0, 159) : sb.ToString();
string ApprovalMsg = "Dear" + memberMaster.MemberName.ToString() + ",Your membership subscription has been approved.Code -" + memberMaster.MemberCode.ToString() + ",Date-" + memberMaster.MembershipDate.ToString("dd/MM/yyyy") + ",Category-" + memberMaster.CategoryName.ToString() + ".Thank You.West Bengal Poultry Federation.";
TriggerSMS(MobileNo, ApprovalMsg);
LoadMemberList();
Message.IsSuccess = true;
Message.Text = "Approved";
Message.Show = true;
}
}
protected void LoadMemberList()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
membermaster.MemberName = txtMemberName.Text.Trim();
DataTable dt = objMember.GetAll(membermaster);
if (dt != null)
{
DataView dv = new DataView(dt);
dv.RowFilter = "IsApproved Is Null And IsActive Is Null";
dgvMemberMaster.DataSource = dv;
dgvMemberMaster.DataBind();
}
}
public static Entity.Common.MemberMaster MemberMasterLedgerDefaultConfiguration_Get()
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = oDm.ExecuteReader("MemberMasterLedgerDefaultConfiguration_Get");
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
if (dr.HasRows)
{
if (dr.Read())
{
membermaster.LedgerTypeId = dr[1].ToString();
membermaster.AccountGroupId = int.Parse(dr[2].ToString());
membermaster.AccountSubGroupId = (dr[3].ToString() == "") ? 0 : int.Parse(dr[3].ToString());
membermaster.IsCostCenterApplicable = bool.Parse(dr[4].ToString());
}
}
return(membermaster);
}
}
protected void chkSubscribeAll_CheckedChanged(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("MemberId");
dt.Columns.Add("FinYearID");
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
foreach (GridViewRow gvr in dgvMemberMaster.Rows)
{
CheckBox chkSubscribe = (CheckBox)gvr.FindControl("chkSubscribe");
chkSubscribe.Checked = true;
dt.Rows.Add();
dt.Rows[dt.Rows.Count - 1]["MemberId"] = dgvMemberMaster.DataKeys[gvr.RowIndex].Values[0].ToString();
dt.Rows[dt.Rows.Count - 1]["FinYearID"] = Session["FinYrID"];
dt.AcceptChanges();
}
membermaster.SubscriptionDetails = dt;
int i = objMemberMaster.SMSSubscription_Save(membermaster);
Message.IsSuccess = true;
Message.Text = "Member SMS Subscription Updated.";
LoadMember();
}
catch
{
Message.IsSuccess = false;
Message.Text = "Member SMS Subscription Can Not Update!!!";
}
Message.Show = true;
}
protected void LoadMemberMaster()
{
BusinessLayer.Common.MemberMasterPrint objMemberMaster = new BusinessLayer.Common.MemberMasterPrint();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
membermaster.BlockId = BlockId;
membermaster.DistrictId = DistrictId;
membermaster.StateId = StateId;
membermaster.CategoryId = CategoryId;
membermaster.MemberName = MemberName;
DataTable dt = objMemberMaster.MemberMaster_GetAll_ForPrint(membermaster);
if (dt != null)
{
grdMemberPrint.DataSource = dt;
grdMemberPrint.DataBind();
}
}
protected void chkSubscribe_CheckedChanged(object sender, EventArgs e)
{
try
{
CheckBox chkSubscribe = (CheckBox)sender;
GridViewRow gvr = (GridViewRow)chkSubscribe.NamingContainer;
int MemberId = int.Parse(dgvMemberMaster.DataKeys[gvr.RowIndex].Values[0].ToString());
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
DataTable dt = new DataTable();
dt.Columns.Add("MemberId");
dt.Columns.Add("FinYearID");
dt.Rows.Add();
dt.Rows[0]["MemberId"] = MemberId;
dt.Rows[0]["FinYearID"] = Session["FinYrID"];
dt.AcceptChanges();
membermaster.SubscriptionDetails = dt;
int i = objMemberMaster.SMSSubscription_Save(membermaster);
Message.IsSuccess = true;
Message.Text = "Member SMS Subscription Updated.";
LoadMember();
}
catch
{
Message.IsSuccess = false;
Message.Text = "Member SMS Subscription Can Not Update!!!";
}
Message.Show = true;
}
protected void LoadMembers()
{
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster member = new Entity.Common.MemberMaster();
member.CategoryId = 0;
member.BlockId = 0;
member.DistrictId = 0;
member.StateId = 0;
member.MemberName = string.Empty;
DataTable dt = objMemberMaster.GetAll(member);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0)=1 And IsNull(IsActive,0)=1";
if (dt != null)
{
ddlMember.DataSource = dv.ToTable();
ddlMember.DataTextField = "MemberName";
ddlMember.DataValueField = "MemberId";
ddlMember.DataBind();
}
ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0"));
}
public static DataTable GetAll(Entity.Common.MemberMaster membermaster, int isMember = 2)
{
using (DataManager oDm = new DataManager())
{
if (membermaster.MemberId == 0)
{
oDm.Add("@MemberId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@MemberId", SqlDbType.Int, membermaster.MemberId);
}
if (membermaster.BlockId == 0)
{
oDm.Add("@BlockId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@BlockId", SqlDbType.Int, membermaster.BlockId);
}
if (membermaster.DistrictId == 0)
{
oDm.Add("@DistrictId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@DistrictId", SqlDbType.Int, membermaster.DistrictId);
}
if (membermaster.StateId == 0)
{
oDm.Add("@StateId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@StateId", SqlDbType.Int, membermaster.StateId);
}
if (membermaster.CategoryId == 0)
{
oDm.Add("@MembershipCategoryId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@MembershipCategoryId", SqlDbType.Int, membermaster.CategoryId);
}
if (membermaster.MemberName == string.Empty)
{
oDm.Add("@MemberName", SqlDbType.VarChar, DBNull.Value);
}
else
{
oDm.Add("@MemberName", SqlDbType.VarChar, membermaster.MemberName);
}
if (isMember == 2)
{
oDm.Add("@IsMember", SqlDbType.Bit, DBNull.Value);
}
else if (isMember == 1)
{
oDm.Add("@IsMember", SqlDbType.Bit, true);
}
else if (isMember == 0)
{
oDm.Add("@IsMember", SqlDbType.Bit, false);
}
if (membermaster.MobileNo == string.Empty)
{
oDm.Add("@MobileNo", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@MobileNo", SqlDbType.VarChar, 50, membermaster.MobileNo);
}
if (membermaster.BusinessTypeId == 0)
{
oDm.Add("@BusinessTypeId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@BusinessTypeId", SqlDbType.Int, membermaster.BusinessTypeId);
}
oDm.CommandType = CommandType.StoredProcedure;
if (membermaster.MembershipMonth == 0)
{
oDm.Add("@MembershipMonth", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@MembershipMonth", SqlDbType.Int, membermaster.MembershipMonth);
}
if (membermaster.MembershipYear == 0)
{
oDm.Add("@MembershipYear", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@MembershipYear", SqlDbType.Int, membermaster.MembershipYear);
}
//return oDm.ExecuteDataTable("MemberMaster_GetAll");
return(oDm.ExecuteDataTable("MemberMaster_GetAllNew"));
}
}
public DataTable MemberMaster_GetAll_ForPrint(Entity.Common.MemberMaster membermaster, int isMember = 2)
{
return(DataAccess.Common.MemberMasterPrint.MemberMaster_GetAll_ForPrint(membermaster, isMember));
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateComboBoxes())
{
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster memberMaster = new Entity.Common.MemberMaster();
memberMaster.OldMemberId = OldMemberId;
memberMaster.MemberCode = txtMemberCode.Text.Trim();
memberMaster.VillageOrStreet = txtVillageOrStreet.Text.Trim();
memberMaster.PlotNo = txtPlotNo.Text.Trim();
memberMaster.KhaitanNo = txtKhaitanNo.Text.Trim();
memberMaster.Mouza = txtMouza.Text.Trim();
memberMaster.JLNo = txtJLNo.Text.Trim();
memberMaster.PO = txtPO.Text.Trim();
memberMaster.PS = txtPS.Text.Trim();
memberMaster.PIN = txtPIN.Text.Trim();
memberMaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue);
memberMaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
memberMaster.StateId = Convert.ToInt32(ddlState.SelectedValue);
memberMaster.EffectiveDate = Convert.ToDateTime(txtEffectiveDate.Text.Trim());
memberMaster.OpBal = (txtOpBal.Text.Trim().Length > 0) ? Convert.ToDecimal(txtOpBal.Text.Trim()) : 0;
memberMaster.DrORCr = ddlDRorCR.SelectedValue;
memberMaster.UserId = Convert.ToInt32(Session["UserId"].ToString());
memberMaster.CompanyId = Convert.ToInt32(Session["CompanyId"].ToString());
memberMaster.BranchId = Convert.ToInt32(Session["BranchId"].ToString());
memberMaster.FinYearId = Convert.ToInt32(Session["FinYrID"].ToString());
memberMaster.DataFlow = Convert.ToInt32(Session["DataFlow"].ToString());
objMemberMaster.MemberMaster_BlockChange_Save(memberMaster);
txtMemberCode.Text = memberMaster.MemberCode;
//CreateLedgerForMember(memberMaster.MemberId);
try
{
//Sending Message
StringBuilder sb = new StringBuilder();
sb.Append(@"Block Changed and New Member Saved Successfully. New Portal " + "%0a");
sb.Append(@"Username: "******"%0a Password: "******"%0a");
string message = (sb.ToString().Length > 158) ? sb.ToString().Substring(0, 158) : sb.ToString();
string API = string.Format("http://api.mVaayoo.com/mvaayooapi/[email protected]:solution2012&senderID=BIGBOS&receipientno={0}&msgtxt={1}&state=1", Session["MobileNo"].ToString(), message);
System.Net.WebRequest request = System.Net.HttpWebRequest.Create(API);
System.Net.HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
System.IO.Stream s = (System.IO.Stream)response.GetResponseStream();
System.IO.StreamReader readStream = new System.IO.StreamReader(s);
String dataString = readStream.ReadToEnd();
response.Close();
s.Close();
readStream.Close();
}
catch { Exception ex; }
Clear();
Message.IsSuccess = true;
Message.Text = "Block Changed and New Member Saved Successfully.";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "script", "<script>PageRedirect()</script>", false);
}
}
catch
{
Message.IsSuccess = false;
Message.Text = "Can Not Change Block and Save New Member!!!";
}
Message.Show = true;
}
protected void LoadMember()
{
BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster();
Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster();
if (ddlBlock.SelectedIndex == 0)
{
membermaster.BlockId = 0;
}
else
{
membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim());
}
if (ddlDistrict.SelectedIndex == 0)
{
membermaster.DistrictId = 0;
}
else
{
membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim());
}
if (ddlState.SelectedIndex == 0)
{
membermaster.StateId = 0;
}
else
{
membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim());
}
if (ddlMembershipCategory.SelectedIndex == 0)
{
membermaster.CategoryId = 0;
}
else
{
membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim());
}
if (txtMemberName.Text == string.Empty)
{
membermaster.MemberName = string.Empty;
}
else
{
membermaster.MemberName = txtMemberName.Text.Trim();
}
DataTable dt = objMember.GetAllOutstandingReport(membermaster);
if (dt != null)
{
dgvMemberMaster.DataSource = dt;
dgvMemberMaster.DataBind();
DataView dv = new DataView(dt);
dv.RowFilter = "IsMember='Yes'";
lblTotalMember.Text = Convert.ToString(dv.ToTable().Rows.Count);
}
}
public static Entity.Common.MemberMaster GetMemberMasterById(int memberId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pMemberId", SqlDbType.Int, ParameterDirection.Input, memberId);
SqlDataReader dr = oDm.ExecuteReader("MemberMaster_GetById");
Entity.Common.MemberMaster memberMaster = new Entity.Common.MemberMaster();
if (dr.HasRows)
{
while (dr.Read())
{
memberMaster.MemberId = memberId;
memberMaster.MemberName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
memberMaster.MemberCode = (dr[2] == DBNull.Value) ? "" : dr[2].ToString();
memberMaster.MobileNo = (dr[3] == DBNull.Value) ? "" : dr[3].ToString();
memberMaster.PhoneId = (dr[4] == DBNull.Value) ? "" : dr[4].ToString();
memberMaster.VATNo = (dr[5] == DBNull.Value) ? "" : dr[5].ToString();
memberMaster.PANNo = (dr[6] == DBNull.Value) ? "" : dr[6].ToString();
memberMaster.LICNo = (dr[7] == DBNull.Value) ? "" : dr[7].ToString();
memberMaster.GSTNo = (dr["GSTNo"] == DBNull.Value) ? "" : dr["GSTNo"].ToString();
memberMaster.VillageOrStreet = (dr[8] == DBNull.Value) ? "" : dr[8].ToString();
memberMaster.PlotNo = (dr[9] == DBNull.Value) ? "" : dr[9].ToString();
memberMaster.KhaitanNo = (dr[10] == DBNull.Value) ? "" : dr[10].ToString();
memberMaster.Mouza = (dr[11] == DBNull.Value) ? "" : dr[11].ToString();
memberMaster.JLNo = (dr[12] == DBNull.Value) ? "" : dr[12].ToString();
memberMaster.PO = (dr[13] == DBNull.Value) ? "" : dr[13].ToString();
memberMaster.PS = (dr[14] == DBNull.Value) ? "" : dr[14].ToString();
memberMaster.PIN = (dr[15] == DBNull.Value) ? "" : dr[15].ToString();
memberMaster.BlockId = (dr[16] == DBNull.Value) ? 0 : int.Parse(dr[16].ToString());
memberMaster.DistrictId = (dr[17] == DBNull.Value) ? 0 : int.Parse(dr[17].ToString());
memberMaster.StateId = (dr[18] == DBNull.Value) ? 0 : int.Parse(dr[18].ToString());
memberMaster.CompanyName = (dr[19] == DBNull.Value) ? "" : dr[19].ToString();
memberMaster.CategoryId = (dr[20] == DBNull.Value) ? 0 : int.Parse(dr[20].ToString());
memberMaster.MemberGroupId = (dr[21] == DBNull.Value) ? 0 : int.Parse(dr[21].ToString());
memberMaster.BusinessTypeId = (dr[22] == DBNull.Value) ? 0 : int.Parse(dr[22].ToString());
memberMaster.MembershipDate = (dr[23] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr[23]);
memberMaster.EffectiveDate = (dr[24] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr[24]);
memberMaster.OpBal = (dr[25] == DBNull.Value) ? 0 : decimal.Parse(dr[25].ToString());
memberMaster.DrORCr = (dr[26] == DBNull.Value) ? "" : dr[26].ToString();
memberMaster.LayerCapacityNos = (dr[27] == DBNull.Value) ? "" : dr[27].ToString();
memberMaster.BroilerCapacityNos = (dr[28] == DBNull.Value) ? "" : dr[28].ToString();
memberMaster.BreederCapacityNos = (dr[29] == DBNull.Value) ? "" : dr[29].ToString();
memberMaster.EggSellerDailySalesNos = (dr[30] == DBNull.Value) ? "" : dr[30].ToString();
memberMaster.ChickenSellerDailySalesNos = (dr[31] == DBNull.Value) ? "" : dr[31].ToString();
memberMaster.ChickenSellerDailySalesKgs = (dr[32] == DBNull.Value) ? "" : dr[32].ToString();
memberMaster.FeedProducerDailySalesMT = (dr[33] == DBNull.Value) ? "" : dr[33].ToString();
memberMaster.FeedSellerDailySalesMT = (dr[34] == DBNull.Value) ? "" : dr[34].ToString();
memberMaster.OtherCategory = (dr[35] == DBNull.Value) ? "" : dr[35].ToString();
memberMaster.Remarks = (dr[36] == DBNull.Value) ? "" : dr[36].ToString();
memberMaster.CreateDate = (dr[37] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr[37]);
memberMaster.UserId = (dr[38] == DBNull.Value) ? 0 : int.Parse(dr[38].ToString());
memberMaster.CompanyId = (dr[39] == DBNull.Value) ? 0 : int.Parse(dr[39].ToString());
memberMaster.LedgerId = (dr[40] == DBNull.Value) ? 0 : int.Parse(dr[40].ToString());
memberMaster.Website = (dr[41] == DBNull.Value) ? "" : dr[41].ToString();
memberMaster.ImageName = (dr[42] == DBNull.Value) ? "" : dr[42].ToString();
memberMaster.CategoryName = (dr[43] == DBNull.Value) ? "" : dr[43].ToString();
memberMaster.IsMember = (dr[44] == DBNull.Value) ? false : bool.Parse(dr[44].ToString());
memberMaster.MemberSMSCategoryId = (dr[45] == DBNull.Value) ? 0 : int.Parse(dr[45].ToString());
memberMaster.IsGovtMember = (dr[46] == DBNull.Value) ? false : bool.Parse(dr[46].ToString());
memberMaster.Email = (dr[47] == DBNull.Value) ? "" : dr[47].ToString();
memberMaster.IsApproved = (dr[48] == DBNull.Value) ? false : bool.Parse(dr[48].ToString());
memberMaster.MobileNo2 = (dr["MobileNo2"] == DBNull.Value) ? "" : dr["MobileNo2"].ToString();
memberMaster.Narration = (dr["Narration"] == DBNull.Value) ? "" : dr["Narration"].ToString();
memberMaster.MembershipCategoryEffectiveDate = (dr["MembershipCategoryEffectiveDate"] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["MembershipCategoryEffectiveDate"]);
memberMaster.IsExecutiveMember = (dr["IsExecutiveMember"] == DBNull.Value) ? false : bool.Parse(dr["IsExecutiveMember"].ToString());
}
}
return(memberMaster);
}
}
public static DataTable MemberFeesSummery_GetAll(Entity.Common.MemberMaster membermaster, int isMember = 2)
{
using (DataManager oDm = new DataManager())
{
if (membermaster.BlockId == 0)
{
oDm.Add("@BlockId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@BlockId", SqlDbType.Int, membermaster.BlockId);
}
if (membermaster.DistrictId == 0)
{
oDm.Add("@DistrictId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@DistrictId", SqlDbType.Int, membermaster.DistrictId);
}
if (membermaster.StateId == 0)
{
oDm.Add("@StateId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@StateId", SqlDbType.Int, membermaster.StateId);
}
if (membermaster.CategoryId == 0)
{
oDm.Add("@MembershipCategoryId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@MembershipCategoryId", SqlDbType.Int, membermaster.CategoryId);
}
if (membermaster.MemberName == string.Empty)
{
oDm.Add("@MemberName", SqlDbType.VarChar, DBNull.Value);
}
else
{
oDm.Add("@MemberName", SqlDbType.VarChar, membermaster.MemberName);
}
if (isMember == 2)
{
oDm.Add("@IsMember", SqlDbType.Bit, DBNull.Value);
}
else if (isMember == 1)
{
oDm.Add("@IsMember", SqlDbType.Bit, true);
}
else if (isMember == 0)
{
oDm.Add("@IsMember", SqlDbType.Bit, false);
}
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteDataTable("MemberFeesSummery_GetAll"));
}
}
public static void Save(Entity.Common.MemberMaster membermaster)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pMemberId", SqlDbType.Int, ParameterDirection.InputOutput, membermaster.MemberId);
oDm.Add("@pMemberName", SqlDbType.VarChar, 200, membermaster.MemberName);
oDm.Add("@pMemberCode", SqlDbType.VarChar, 100, ParameterDirection.Input, membermaster.MemberCode);
oDm.Add("@pMobileNo", SqlDbType.VarChar, 100, membermaster.MobileNo);
oDm.Add("@pPhoneId", SqlDbType.VarChar, 100, membermaster.PhoneId);
oDm.Add("@pVATNo", SqlDbType.VarChar, 100, membermaster.VATNo);
oDm.Add("@pPANNo", SqlDbType.VarChar, 100, membermaster.PANNo);
oDm.Add("@pLICNo", SqlDbType.VarChar, 100, membermaster.LICNo);
oDm.Add("@pGSTNo", SqlDbType.VarChar, 100, membermaster.GSTNo);
oDm.Add("@pVillageOrStreet", SqlDbType.VarChar, 200, membermaster.VillageOrStreet);
oDm.Add("@pPlotNo", SqlDbType.VarChar, 100, membermaster.PlotNo);
oDm.Add("@pKhaitanNo", SqlDbType.VarChar, 100, membermaster.KhaitanNo);
oDm.Add("@pMouza", SqlDbType.VarChar, 100, membermaster.Mouza);
oDm.Add("@pJLNo", SqlDbType.VarChar, 100, membermaster.JLNo);
oDm.Add("@pPO", SqlDbType.VarChar, 100, membermaster.PO);
oDm.Add("@pPS", SqlDbType.VarChar, 100, membermaster.PS);
oDm.Add("@pPIN", SqlDbType.VarChar, 10, membermaster.PIN);
oDm.Add("@pBlockId", SqlDbType.Int, membermaster.BlockId);
oDm.Add("@pDistrictId", SqlDbType.Int, membermaster.DistrictId);
oDm.Add("@pStateId", SqlDbType.Int, membermaster.StateId);
oDm.Add("@pCompanyName", SqlDbType.VarChar, 200, membermaster.CompanyName);
oDm.Add("@pMembershipCategoryId", SqlDbType.Int, membermaster.CategoryId);
oDm.Add("@IsMember", SqlDbType.Bit, membermaster.IsMember);
if (membermaster.IsMember)
{
oDm.Add("@pMemberGroupId", SqlDbType.Int, membermaster.MemberGroupId);
oDm.Add("@pBusinessTypeId", SqlDbType.Int, membermaster.BusinessTypeId);
}
else
{
oDm.Add("@pMemberGroupId", SqlDbType.Int, DBNull.Value);
oDm.Add("@pBusinessTypeId", SqlDbType.Int, DBNull.Value);
}
oDm.Add("@pMembershipDate", SqlDbType.Date, membermaster.MembershipDate);
oDm.Add("@pEffectiveDate", SqlDbType.DateTime, membermaster.EffectiveDate);
//oDm.Add("@pOpBal", SqlDbType.Decimal, membermaster.OpBal);
//oDm.Add("@pDrORCr", SqlDbType.VarChar, 2, membermaster.DrORCr);
if (membermaster.LayerCapacityNos == string.Empty)
{
oDm.Add("@pLayerCapacityNos", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pLayerCapacityNos", SqlDbType.VarChar, 50, membermaster.LayerCapacityNos);
}
if (membermaster.BroilerCapacityNos == string.Empty)
{
oDm.Add("@pBroilerCapacityNos", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pBroilerCapacityNos", SqlDbType.VarChar, 50, membermaster.BroilerCapacityNos);
}
if (membermaster.BreederCapacityNos == string.Empty)
{
oDm.Add("@pBreederCapacityNos", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pBreederCapacityNos", SqlDbType.VarChar, 50, membermaster.BreederCapacityNos);
}
if (membermaster.EggSellerDailySalesNos == string.Empty)
{
oDm.Add("@pEggSellerDailySalesNos", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pEggSellerDailySalesNos", SqlDbType.VarChar, 50, membermaster.EggSellerDailySalesNos);
}
if (membermaster.ChickenSellerDailySalesNos == string.Empty)
{
oDm.Add("@pChickenSellerDailySalesNos", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pChickenSellerDailySalesNos", SqlDbType.VarChar, 50, membermaster.ChickenSellerDailySalesNos);
}
if (membermaster.ChickenSellerDailySalesKgs == string.Empty)
{
oDm.Add("@pChickenSellerDailySalesKgs", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pChickenSellerDailySalesKgs", SqlDbType.VarChar, 50, membermaster.ChickenSellerDailySalesKgs);
}
if (membermaster.FeedProducerDailySalesMT == string.Empty)
{
oDm.Add("@pFeedProducerDailySalesMT", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pFeedProducerDailySalesMT", SqlDbType.VarChar, 50, membermaster.FeedProducerDailySalesMT);
}
if (membermaster.FeedSellerDailySalesMT == string.Empty)
{
oDm.Add("@pFeedSellerDailySalesMT", SqlDbType.VarChar, 50, DBNull.Value);
}
else
{
oDm.Add("@pFeedSellerDailySalesMT", SqlDbType.VarChar, 50, membermaster.FeedSellerDailySalesMT);
}
oDm.Add("@pOtherCategory", SqlDbType.VarChar, 100, membermaster.OtherCategory);
oDm.Add("@pRemarks", SqlDbType.VarChar, 200, membermaster.Remarks);
oDm.Add("@pUserId", SqlDbType.Int, membermaster.UserId);
oDm.Add("@pCompanyId", SqlDbType.Int, membermaster.CompanyId);
oDm.Add("@BranchID_FK", SqlDbType.Int, membermaster.BranchId);
oDm.Add("@FinYearID_FK", SqlDbType.Int, membermaster.FinYearId);
oDm.Add("@DataFlow", SqlDbType.Int, membermaster.DataFlow);
oDm.Add("@pWebsite", SqlDbType.VarChar, 100, membermaster.Website);
if (membermaster.ImageExt == string.Empty)
{
oDm.Add("@ImageExt", SqlDbType.VarChar, 100, DBNull.Value);
}
else
{
oDm.Add("@ImageExt", SqlDbType.VarChar, 100, membermaster.ImageExt);
}
if (membermaster.MemberSMSCategoryId == 0)
{
oDm.Add("@MemberSMSCategoryId", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@MemberSMSCategoryId", SqlDbType.Int, membermaster.MemberSMSCategoryId);
}
oDm.Add("@IsGovtMember", SqlDbType.Bit, membermaster.IsGovtMember);
oDm.Add("@pEmail", SqlDbType.VarChar, 50, membermaster.Email);
oDm.Add("@pMobileNo2", SqlDbType.VarChar, 20, membermaster.MobileNo2);
oDm.Add("@pNarration", SqlDbType.VarChar, 255, membermaster.Narration);
oDm.Add("@pMembershipCategoryEffectiveDate", SqlDbType.Date, membermaster.MembershipCategoryEffectiveDate);
oDm.Add("@pIsExecutiveMember", SqlDbType.Bit, membermaster.IsExecutiveMember);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("MemberMaster_Save");
membermaster.MemberId = (int)oDm["@pMemberId"].Value;
}
}
