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.MemberFeesSummery_GetAll(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);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (IsValidPhoto())
{
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
memberMaster.MemberId = MemberId;
memberMaster.MemberName = txtMemberName.Text.Trim();
memberMaster.MemberCode = txtMemberCode.Text.Trim();
memberMaster.MobileNo = txtMobileNo.Text.Trim();
memberMaster.PhoneId = txtPhoneNo.Text.Trim();
memberMaster.Email = txtEmail.Text.Trim();
memberMaster.VATNo = txtVATNo.Text.Trim();
memberMaster.PANNo = txtPANNo.Text.Trim();
memberMaster.LICNo = txtLICNo.Text.Trim();
memberMaster.GSTNo = txtGSTNo.Text.Trim();//NEW
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.CompanyName = txtCompanyName.Text.Trim();
memberMaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue);
memberMaster.IsMember = chkMember.Checked;
memberMaster.MemberGroupId = Convert.ToInt32(ddlMemberGroup.SelectedValue);
memberMaster.BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue);
memberMaster.MembershipDate = Convert.ToDateTime(txtMembershipDate.Text.Trim().Split('/')[2] + "-" + txtMembershipDate.Text.Trim().Split('/')[1] + "-" + txtMembershipDate.Text.Trim().Split('/')[0]);
memberMaster.EffectiveDate = Convert.ToDateTime(txtEffectiveDate.Text.Trim().Split('/')[2] + "-" + txtEffectiveDate.Text.Trim().Split('/')[1] + "-" + txtEffectiveDate.Text.Trim().Split('/')[0]);
//memberMaster.OpBal = (txtOpBal.Text.Trim().Length > 0) ? Convert.ToDecimal(txtOpBal.Text.Trim()) : 0;
//memberMaster.DrORCr = ddlDRorCR.SelectedValue;
memberMaster.LayerCapacityNos = (txtLayerCapacityNos.Text.Trim().Length > 0) ? txtLayerCapacityNos.Text.Trim() : "";
memberMaster.BroilerCapacityNos = (txtBroilerCapacityNos.Text.Trim().Length > 0) ? txtBroilerCapacityNos.Text.Trim() : "";
memberMaster.BreederCapacityNos = (txtBreederCapacityNos.Text.Trim().Length > 0) ? txtBreederCapacityNos.Text.Trim() : "";
memberMaster.EggSellerDailySalesNos = (txtEggSellerDailySalesNos.Text.Trim().Length > 0) ? txtEggSellerDailySalesNos.Text.Trim() : "";
memberMaster.ChickenSellerDailySalesNos = (txtChickenSellerDailySalesNos.Text.Trim().Length > 0) ? txtChickenSellerDailySalesNos.Text.Trim() : "";
memberMaster.ChickenSellerDailySalesKgs = (txtChickenSellerDailySalesKgs.Text.Trim().Length > 0) ? txtChickenSellerDailySalesKgs.Text.Trim() : "";
memberMaster.FeedProducerDailySalesMT = (txtFeedProducerDailySalesMT.Text.Trim().Length > 0) ? txtFeedProducerDailySalesMT.Text.Trim() : "";
memberMaster.FeedSellerDailySalesMT = (txtFeedSellerDailySalesMT.Text.Trim().Length > 0) ? txtFeedSellerDailySalesMT.Text.Trim() : "";
memberMaster.OtherCategory = txtOtherCategory.Text.Trim();
memberMaster.Remarks = txtRemarks.Text.Trim();
memberMaster.UserId = 0; // Convert.ToInt32(Session["UserId"].ToString());
memberMaster.CompanyId = 0; // Convert.ToInt32(Session["CompanyId"].ToString());
memberMaster.BranchId = 0; // Convert.ToInt32(Session["BranchId"].ToString());
memberMaster.FinYearId = 0; // Convert.ToInt32(Session["FinYrID"].ToString());
memberMaster.DataFlow = 0; // Convert.ToInt32(Session["DataFlow"].ToString());
memberMaster.Website = txtWebsite.Text.Trim();
memberMaster.ImageExt = Photo;
memberMaster.IsGovtMember = chkIsGovtMember.Checked;
memberMaster.MemberSMSCategoryId = (ddlMemberSMSCategory.SelectedIndex == 0) ? 0 : int.Parse(ddlMemberSMSCategory.SelectedValue);
memberMaster.MobileNo2 = txtMobileNo2.Text.Trim();
memberMaster.Narration = txtNarration.Text.Trim();
memberMaster.MembershipCategoryEffectiveDate = Convert.ToDateTime(txtMembershipCategoryEffectiveDate.Text.Trim().Split('/')[2] + "-" + txtMembershipCategoryEffectiveDate.Text.Trim().Split('/')[1] + "-" + txtMembershipCategoryEffectiveDate.Text.Trim().Split('/')[0]);
memberMaster.IsExecutiveMember = chkExecutiveMember.Checked;
objMemberMaster.Save(memberMaster);
//txtMemberCode.Text = memberMaster.MemberCode;
if (Photo.Trim() != "")
{
string ff = (Server.MapPath("") + "\\MemberPhoto\\" + memberMaster.MemberId.ToString().Replace("/", "-") + Photo);
uploadImage.PostedFile.SaveAs(ff);
}
//Document Upload Section Start
if (MemberId.Equals(0))
{
Mode = "ADD";
}
else
{
Mode = "EDIT";
}
SaveDocument(memberMaster.MemberId);
//Document Upload Section End
Message.IsSuccess = true;
Message.Text = (MemberId == 0) ? "Member Registration Successfully Completed." : "Member Details Updated Successfully.";
Message.Show = true;
btnSave.Visible = false;
}
else
{
Message.IsSuccess = false;
Message.Text = "Photo should be in .jpg or .jpeg or .png format";
Message.Show = true;
}
}
catch
{
Message.IsSuccess = false;
Message.Text = "Can Not Save!!!";
}
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.GetAll(membermaster);
if (dt != null)
{
dgvMemberMaster.DataSource = dt;
dgvMemberMaster.DataBind();
}
DataTable dtSMS = objMember.SMSSubscription_GetAll(int.Parse(Session["FinYrID"].ToString()));
if (dtSMS != null)
{
foreach (DataRow dr in dtSMS.Rows)
{
foreach (GridViewRow gvr in dgvMemberMaster.Rows)
{
CheckBox chkSubscribe = (CheckBox)gvr.FindControl("chkSubscribe");
if (dr["MemberId"].ToString() == dgvMemberMaster.DataKeys[gvr.RowIndex].Values[0].ToString())
{
chkSubscribe.Checked = true;
chkSubscribe.Enabled = false;
if (dr["IsBlocked"].ToString() == "True")
{
Button btnBlock = (Button)gvr.FindControl("btnBlock");
btnBlock.Text = "Unblock";
for (int i = 0; i < 10; i++)
{
gvr.Cells[i].Style.Add("background-color", "#E5D254");
}
}
}
}
}
}
}
protected void PopulateMemberMaster()
{
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
memberMaster = objMemberMaster.GetMemberMasterById(MemberId);
if (memberMaster != null)
{
MemberId = memberMaster.MemberId;
txtMemberName.Text = memberMaster.MemberName.ToString();
//txtMemberName.Enabled = false;
txtMemberCode.Text = memberMaster.MemberCode.ToString();
txtMemberCode.Enabled = false;
txtMobileNo.Text = memberMaster.MobileNo.ToString();
txtPhoneNo.Text = memberMaster.PhoneId.ToString();
txtEmail.Text = memberMaster.Email.ToString();
txtVATNo.Text = memberMaster.VATNo.ToString();
txtPANNo.Text = memberMaster.PANNo.ToString();
txtLICNo.Text = memberMaster.LICNo.ToString();
txtGSTNo.Text = memberMaster.GSTNo.ToString();//NEW
txtVillageOrStreet.Text = memberMaster.VillageOrStreet.ToString();
txtPlotNo.Text = memberMaster.PlotNo.ToString();
txtKhaitanNo.Text = memberMaster.KhaitanNo.ToString();
txtMouza.Text = memberMaster.Mouza.ToString();
txtJLNo.Text = memberMaster.JLNo.ToString();
txtPO.Text = memberMaster.PO.ToString();
txtPS.Text = memberMaster.PS.ToString();
txtPIN.Text = memberMaster.PIN.ToString();
ddlState.SelectedValue = memberMaster.StateId.ToString();
if (memberMaster.IsApproved)
{
ddlState.Enabled = false;
}
LoadDistrict();
ddlDistrict.SelectedValue = memberMaster.DistrictId.ToString();
if (memberMaster.IsApproved)
{
ddlDistrict.Enabled = false;
}
LoadBlock();
ddlBlock.SelectedValue = memberMaster.BlockId.ToString();
if (memberMaster.IsApproved)
{
ddlBlock.Enabled = false;
}
txtCompanyName.Text = memberMaster.CompanyName.ToString();
ddlMembershipCategory.SelectedValue = memberMaster.CategoryId.ToString();
//ddlMembershipCategory.Enabled = false;
ddlMemberGroup.SelectedValue = memberMaster.MemberGroupId.ToString();
//ddlMemberGroup.Enabled = false;
ddlBusinessType.SelectedValue = memberMaster.BusinessTypeId.ToString();
//ddlBusinessType.Enabled = false;
txtMembershipDate.Text = memberMaster.MembershipDate.ToString("dd/MM/yyyy");
txtEffectiveDate.Text = memberMaster.EffectiveDate.ToString("dd/MM/yyyy");
if (Session["UserType"].ToString().Equals("Admin"))
{
txtMembershipDate.Enabled = true;
txtEffectiveDate.Enabled = true;
}
else
{
txtMembershipDate.Enabled = false;
txtEffectiveDate.Enabled = false;
}
txtLayerCapacityNos.Text = memberMaster.LayerCapacityNos.ToString();
txtBroilerCapacityNos.Text = memberMaster.BroilerCapacityNos.ToString();
txtBreederCapacityNos.Text = memberMaster.BreederCapacityNos.ToString();
txtEggSellerDailySalesNos.Text = memberMaster.EggSellerDailySalesNos.ToString();
txtChickenSellerDailySalesNos.Text = memberMaster.ChickenSellerDailySalesNos.ToString();
txtChickenSellerDailySalesKgs.Text = memberMaster.ChickenSellerDailySalesKgs.ToString();
txtFeedProducerDailySalesMT.Text = memberMaster.FeedProducerDailySalesMT.ToString();
txtFeedSellerDailySalesMT.Text = memberMaster.FeedSellerDailySalesMT.ToString();
txtOtherCategory.Text = memberMaster.OtherCategory.ToString();
txtRemarks.Text = memberMaster.Remarks.ToString();
txtWebsite.Text = memberMaster.Website.ToString();
ImgPhoto.ImageUrl = (memberMaster.ImageName == string.Empty) ? "MemberPhoto/Male.jpg" : "MemberPhoto/" + memberMaster.ImageName;
chkMember.Checked = memberMaster.IsMember;
chkMember.Enabled = false;
txtLayerCapacityNos.Enabled = chkMember.Checked;
txtBreederCapacityNos.Enabled = chkMember.Checked;
txtChickenSellerDailySalesNos.Enabled = chkMember.Checked;
txtFeedProducerDailySalesMT.Enabled = chkMember.Checked;
txtBroilerCapacityNos.Enabled = chkMember.Checked;
txtEggSellerDailySalesNos.Enabled = chkMember.Checked;
txtChickenSellerDailySalesKgs.Enabled = chkMember.Checked;
txtFeedSellerDailySalesMT.Enabled = chkMember.Checked;
txtOtherCategory.Enabled = chkMember.Checked;
txtRemarks.Enabled = chkMember.Checked;
chkIsGovtMember.Checked = memberMaster.IsGovtMember;
chkIsGovtMember.Enabled = false;
if (memberMaster.MemberSMSCategoryId == 0)
{
ddlMemberSMSCategory.SelectedIndex = 0;
}
else
{
ddlMemberSMSCategory.SelectedValue = Convert.ToString(memberMaster.MemberSMSCategoryId);
}
txtMobileNo2.Text = memberMaster.MobileNo2;
txtNarration.Text = memberMaster.Narration;
txtMembershipCategoryEffectiveDate.Text = memberMaster.MembershipCategoryEffectiveDate.ToString("dd/MM/yyyy");
chkExecutiveMember.Checked = memberMaster.IsExecutiveMember;
Message.Show = false;
btnSave.Text = "Update";
}
}