protected void txtYearSeason_TextChanged(object sender, EventArgs e) { FeeMaster fm = new FeeMaster(); lblExamSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString(); lblNewid.Text = fm.rtnlvl(lblExamSeasonHidden.Text); }
protected void btnSubscribe_Onclick(object sender, EventArgs e) { dtinfo.DateSeparator = "/"; dtinfo.ShortDatePattern = "dd/MM/yyyy"; FeeMaster fm = new FeeMaster(); string sto = fm.rtnlvl(lblSubscriptionFrom.Text); string sub = fm.rtnlvl(lblTo.Text); if (Convert.ToInt32(sub) <= Convert.ToInt32(sto)) { con.Close(); con.Open(); SqlCommand cmd = new SqlCommand(); cmd = new SqlCommand("update Member set RenewDate=@RenewDate,ExpDate=@ExpDate, YearFrom=@YearFrom, YearTo=@YearTo where ID='" + lblID.Text.ToString() + "'", con); DateTime sd = new DateTime(); sd = Convert.ToDateTime(txtSubDate.Text.ToString(), dtinfo); sd = sd.AddMonths(12); cmd.Parameters.AddWithValue("@RenewDate", sd); sd = sd.AddMonths(6); cmd.Parameters.AddWithValue("@ExpDate", sd); cmd.Parameters.AddWithValue("@YearFrom", lblSubscriptionFrom.Text.ToString()); cmd.Parameters.AddWithValue("@YearTo", lblSubscriptionTo.Text.ToString()); cmd.ExecuteNonQuery(); imtrans(txtIMID.Text.ToString(), lblSubFee.Text.ToString(), "Subscription Fees", "Subscription"); amountupdate(txtIMID.Text.ToString(), Convert.ToInt32(lblSubFee.Text)); ClsAccount amount1 = new ClsAccount(); amount1.AmountSubmit(txtIMID.Text.ToString(), "", DateTime.Now, "Debit", lblSubFee.Text, lblSubscriptionFrom.Text.ToString(), "Subscription Fees"); con.Close(); con.Dispose(); } Response.Redirect(System.Web.HttpContext.Current.Request.Url.AbsoluteUri.ToString()); }
protected void Page_Load(object sender, EventArgs e) { try { if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "") { Response.Redirect("../Login.aspx"); } if (!IsPostBack) { maikal dev = new maikal(); int se = dev.chksession(); if (se == 0) { ddlExamSeason.SelectedValue = "Sum"; } else { ddlExamSeason.SelectedValue = "Win"; } txtYearSeason.Text = DateTime.Now.Year.ToString(); lblExamSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString(); FeeMaster fm = new FeeMaster(); lblNewid.Text = fm.rtnlvl(lblExamSeasonHidden.Text); ddlExamSeason.Focus(); } } catch (NullReferenceException ex) { Response.Redirect("../../Login.aspx"); } }
protected void ddldevExamSeason_SelectedIndexChanged(object sender, EventArgs e) { lblSessionHiddend.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString(); FeeMaster fm = new FeeMaster(); lblNewid.Text = fm.rtnlvl(lblSessionHiddend.Text); txtSession.Focus(); }
protected void Page_Load(object sender, EventArgs e) { try { if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "") { Response.Redirect("../Login.aspx"); } else { if (!IsPostBack) { maikal dev = new maikal(); int se = dev.chksession(); if (se == 0) { ddlExamSeason.SelectedValue = "Sum"; } else { ddlExamSeason.SelectedValue = "Win"; } lblStreamHidden.Text = "Tech"; lblStreamName.Text = "Technician Engineering"; txtyear.Text = DateTime.Now.Year.ToString(); lblSeason.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtyear.Text.ToString(); string qry = ""; ddlCourse.SelectedValue = "Civil"; if (ddlCourse.SelectedValue.ToString() == "Civil") { qry = "select Distinct CourseID from CivilSubMaster"; } else if (ddlCourse.SelectedValue.ToString() == "Architecture") { qry = "select Distinct CourseID from ArchiSubMaster"; } SqlDataAdapter ad = new SqlDataAdapter(qry, con); DataSet ds = new DataSet(); ad.Fill(ds); ddlSyllabus.DataSource = ds; ddlSyllabus.DataTextField = "CourseID"; ddlSyllabus.DataValueField = "CourseID"; ddlSyllabus.DataBind(); FeeMaster fm = new FeeMaster(); ddlSyllabus.SelectedValue = fm.currentCourse(ddlCourse.SelectedValue.ToString()); ddlType.Focus(); } } } catch (NullReferenceException ex) { Response.Redirect("../Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "") { Response.Redirect("../Login.aspx"); } else { if (!IsPostBack) { panelHidden.Visible = true; panelView.Visible = false; lblStreamCode.Text = "Tech"; lblStreamCode.Text = "Tech"; lblStreamName.Text = "Technician Engineering"; txtYear.Text = DateTime.Now.Year.ToString(); lblSeason.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYear.Text.ToString(); string qyry = ""; if (ddlCourse.SelectedValue.ToString() == "Civil") { qyry = "select distinct CourseID from CivilSubMaster"; } else if (ddlCourse.SelectedValue.ToString() == "Architecture") { qyry = "select distinct CourseID from ArchiSubMaster"; } SqlDataAdapter ad = new SqlDataAdapter(qyry, con); DataSet ds = new DataSet(); ad.Fill(ds); ddlSyllabus.DataSource = ds; ddlSyllabus.DataTextField = "CourseID"; ddlSyllabus.DataValueField = "CourseID"; ddlSyllabus.DataBind(); FeeMaster fm = new FeeMaster(); ddlSyllabus.SelectedValue = fm.currentCourse(ddlCourse.SelectedValue.ToString()); showcourse(); } // visisble.Visible = true; invisible.Visible = false; } } catch (NullReferenceException ex) { Response.Redirect("../Login.aspx"); } }
public async Task <Guid> SaveStatus(FeesDTO _Dto, Guid Id, int EntityState) { FeeMaster _FeeMaster = new FeeMaster(); _FeeMaster = await db.FeeMasters.Where(o => o.Id == Id).FirstOrDefaultAsync(); if (_FeeMaster.StatusCode == EMPConstants.InActive) { _FeeMaster.StatusCode = EMPConstants.Active; _FeeMaster.DeActivatedDate = null; _FeeMaster.ActivatedDate = DateTime.Now; } else if (_FeeMaster.StatusCode == EMPConstants.Active) { _FeeMaster.StatusCode = EMPConstants.InActive; _FeeMaster.DeActivatedDate = DateTime.Now; } if (EntityState == (int)System.Data.Entity.EntityState.Modified) { _FeeMaster.LastUpdatedDate = DateTime.Now; _FeeMaster.LastUpdatedBy = _Dto.UserId; db.Entry(_FeeMaster).State = System.Data.Entity.EntityState.Modified; } try { await db.SaveChangesAsync(); db.Dispose(); return(_FeeMaster.Id); } catch (DbUpdateConcurrencyException) { if (!IsExists(_FeeMaster.Id)) { return(Guid.Empty); } else { throw; } } }
protected void Page_Load(object sender, EventArgs e) { try { if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "") { Response.Redirect("../../Login.aspx"); } if (Request.QueryString["typ"].ToString() == "create") { panelManage.Visible = false; panelCreate.Visible = true; } else if (Request.QueryString["typ"].ToString() == "manage") { panelCreate.Visible = false; panelManage.Visible = true; } if (Page.IsPostBack == false) { maikal dev = new maikal(); int se = dev.chksession(); if (se == 0) { ddlsession.SelectedValue = "Sum"; } else { ddlsession.SelectedValue = "Win"; } txtSession.Text = DateTime.Now.Year.ToString(); lblSessionHiddend.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString(); lbntSelectAging.Visible = false; PnlSubjectEdit.Visible = false; PanelCheckBox.Visible = false;// panelManage.Visible = true; FeeMaster fm = new FeeMaster(); lblNewid.Text = fm.rtnlvl(lblSessionHiddend.Text); } } catch (NullReferenceException ex) { Response.Redirect("../../Login.aspx"); } }
protected void btnChnageStatsu_OnClick(object sender, EventArgs e) { try { FeeMaster fmcls = new FeeMaster(); dtinfo.DateSeparator = "/"; dtinfo.ShortDatePattern = "dd/MM/yyyy"; con.Close(); con.Open(); SqlCommand cmd = new SqlCommand(); if (lblStatus2.Text == "Disactive") { btnchangeStatus.Text = "Active"; strstatus = "yes"; } else if (lblStatus2.Text == "Active") { btnchangeStatus.Text = "Disactive"; strstatus = "no"; } if (lblStatus2.Text == "New Registration") { cmd = new SqlCommand("select Status from IMInspection where ID='" + lblID.Text.ToString() + "'", con); string insp = Convert.ToString(cmd.ExecuteScalar()); if (insp == "") { lblExceptionActive.Text = "Inspection Report Not Submitted Yet."; } else if (insp == "NotApprove" || insp == "NotApproved") { lblExceptionActive.Text = "Inspection Status is " + insp.ToString(); } if (lblMemberTyep.Text != "IM") { insp = "Approve"; } if (insp == "Approve" || insp == "SubToApprove") { if (chkAC(Convert.ToInt32(lblSubFee.Text) + Convert.ToInt32(lblEnrollFee.Text), Convert.ToInt32(lblBalance.Text), lblBalanceType.Text)) { string gid = genid(); if (lblMemberTyep.Text == "IM") { SqlCommand cmdx = new SqlCommand("update IM set ID=@ID, Active=@Active where ID='" + lblID.Text.ToString() + "'", con); cmdx.Parameters.AddWithValue("@ID", gid.ToString()); cmdx.Parameters.AddWithValue("@Active", "no"); cmdx.ExecuteNonQuery(); cmd = new SqlCommand("update IMAC set IMID=@IMID where IMID='" + lblID.Text.ToString() + "'", con); cmd.Parameters.AddWithValue("@IMID", gid.ToString()); cmd.ExecuteNonQuery(); cmd = new SqlCommand("update IMInspection set ID=@ID where ID='" + lblID.Text.ToString() + "'", con); cmd.Parameters.AddWithValue("@ID", gid.ToString()); cmd.ExecuteNonQuery(); cmd = new SqlCommand("update Account set IMID=@ID where IMID='" + lblID.Text.ToString() + "'", con); cmd.Parameters.AddWithValue("@ID", gid.ToString()); cmd.ExecuteNonQuery(); } cmd = new SqlCommand("update FeeAC set IMID=@ID where IMID='" + lblID.Text.ToString() + "'", con); cmd.Parameters.AddWithValue("@ID", gid.ToString()); cmd.ExecuteNonQuery(); cmd = new SqlCommand("update Member set ID=@ID,Active=@Active,YearFrom=@YearFrom, YearTo=@YearTo where ID='" + lblID.Text.ToString() + "'", con); cmd.Parameters.AddWithValue("@Active", "no"); cmd.Parameters.AddWithValue("@ID", gid.ToString()); cmd.Parameters.AddWithValue("@YearFrom", ddlSessionFrom.SelectedValue.ToString() + "" + txtYearFrom.Text.ToString()); cmd.Parameters.AddWithValue("@YearTo", fmcls.nextSession(ddlSessionFrom.SelectedValue.ToString() + "" + txtYearFrom.Text.ToString())); cmd.ExecuteNonQuery(); cmd = new SqlCommand("update MemberFee set ID=@ID where ID='" + lblID.Text.ToString() + "'", con); cmd.Parameters.AddWithValue("@ID", gid.ToString()); cmd.ExecuteNonQuery(); cmd = new SqlCommand("Update IMBooks set IMID='" + gid + "' where IMID='" + lblID.Text.ToString() + "'", con); cmd.ExecuteNonQuery(); cmd = new SqlCommand("update IMStock set IMID='" + gid + "' where IMID='" + lblID.Text.ToString() + "'", con); cmd.ExecuteNonQuery(); cmd = new SqlCommand("update DiaryEntry set IMID='" + gid.ToString() + "', MembershipNo='" + gid.ToString() + "' where IMID='" + lblID.Text.ToString() + "'", con); cmd.ExecuteNonQuery(); cmd = new SqlCommand("update DairyCount set IMID='" + gid.ToString() + "' where IMID='" + lblID.Text.ToString() + "'", con); cmd.ExecuteNonQuery(); btnchangeStatus.Text = "New ID: " + gid.ToString(); lblID.Text = gid.ToString(); lblStatus2.Text = "Disactive"; lblExceptionActive.Text = "Membership ID: " + gid.ToString(); txtIMID.Text = gid.ToString(); imtrans(txtIMID.Text.ToString(), lblEnrollFee.Text.ToString(), "Membership Fees", "Membership"); imtrans(txtIMID.Text.ToString(), lblSubFee.Text.ToString(), "Subscription Fees", "Subscription"); amountupdate(txtIMID.Text.ToString(), Convert.ToInt32(lblEnrollFee.Text)); amountupdate(txtIMID.Text.ToString(), Convert.ToInt32(lblSubFee.Text)); Response.Redirect(System.Web.HttpContext.Current.Request.Url.AbsolutePath.ToString() + "?name=" + Request.QueryString["name"] + "&lnk=" + Request.QueryString["lnk"] + "&typ=" + Request.QueryString["typ"] + "&lvl=" + Request.QueryString["lvl"] + "&id=" + txtIMID.Text.ToString()); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Not Enough Amount Found.')", true); } } } else { cmd = new SqlCommand("update Member set Active='" + strstatus.ToString() + "' where ID='" + txtIMID.Text.ToString() + "'", con); cmd.ExecuteNonQuery(); con.Close(); if (strstatus == "yes") { btnchangeStatus.Text = "Disactive"; lblStatus2.Text = "Active"; lblExceptionActive.Text = "Membership Activeted"; } else { btnchangeStatus.Text = "Active"; lblStatus2.Text = "Disactive"; lblExceptionActive.Text = "Membership Disactiveted"; } } } catch (Exception ex) { lblExceptionActive.Text = "Amount Not Found."; } finally { btnchangeStatus.Focus(); } }
public async Task <int> Save(FeesDTO _Dto, Guid Id, int EntityState) { FeeMaster _FeeMaster = new FeeMaster(); if (_Dto != null) { _FeeMaster.Id = Id; _FeeMaster.Name = _Dto.Name; _FeeMaster.FeeType = _Dto.FeeType; _FeeMaster.FeeCategoryID = _Dto.FeeCategoryID; _FeeMaster.IsIncludedMaxAmtCalculation = _Dto.IsIncludedMaxAmtCalculation; _FeeMaster.SalesforceFeesFieldID = _Dto.SalesforceFeesFieldID; if (_FeeMaster.FeeType == EMPConstants.Fixedamount) { _FeeMaster.FeeTypeId = 1; } if (_FeeMaster.FeeType == EMPConstants.Useramount) { _FeeMaster.FeeTypeId = 2; } if (_FeeMaster.FeeType == EMPConstants.SalesForce) { _FeeMaster.FeeTypeId = 3; } _FeeMaster.Amount = _Dto.Amount; _FeeMaster.FeeNature = _Dto.FeeNature; if (_FeeMaster.FeeNature == EMPConstants.Mandatory) { _FeeMaster.FeeNatureId = 1; } if (_FeeMaster.FeeNature == EMPConstants.Optional) { _FeeMaster.FeeNatureId = 2; } _FeeMaster.ActivatedDate = DateTime.Now; _FeeMaster.DeActivatedDate = null;// _Dto.DeActivatedDate; _FeeMaster.NoteForUser = _Dto.NoteForUser; _FeeMaster.Note = _Dto.Note; _FeeMaster.StatusCode = EMPConstants.Active; int FeesFor = 0; if (int.TryParse(_Dto.FeesFor, out FeesFor)) { _FeeMaster.FeesFor = FeesFor; } else { return(0); } } if (EntityState == (int)System.Data.Entity.EntityState.Modified) { var ExistFee = db.FeeMasters.Where(o => o.Id != Id && o.Name == _Dto.Name).Any(); if (ExistFee) { return(-1); } _FeeMaster.LastUpdatedDate = DateTime.Now; _FeeMaster.LastUpdatedBy = _Dto.UserId; db.Entry(_FeeMaster).State = System.Data.Entity.EntityState.Modified; } else { var ExistFee = db.FeeMasters.Where(o => o.Name == _Dto.Name).Any(); if (ExistFee) { return(-1); } _FeeMaster.CreatedBy = _Dto.UserId; _FeeMaster.CreatedDate = DateTime.Now; _FeeMaster.LastUpdatedDate = DateTime.Now; _FeeMaster.LastUpdatedBy = _Dto.UserId; db.FeeMasters.Add(_FeeMaster); } if (_Dto.Entities.ToList().Count > 0) { if (EntityState == (int)System.Data.Entity.EntityState.Modified) { var MapData = db.FeeEntityMaps.Where(o => o.FeeId == Id).ToList(); if (MapData.Count() > 0) { db.FeeEntityMaps.RemoveRange(MapData); } } List <FeeEntityMap> _FeeEntityMapList = new List <FeeEntityMap>(); foreach (EntityDTO item in _Dto.Entities) { FeeEntityMap _FeeEntityMap = new FeeEntityMap(); _FeeEntityMap.Id = Guid.NewGuid(); _FeeEntityMap.FeeId = _FeeMaster.Id; _FeeEntityMap.EntityId = item.Id; _FeeEntityMapList.Add(_FeeEntityMap); } db.FeeEntityMaps.AddRange(_FeeEntityMapList); } try { await db.SaveChangesAsync(); db.Dispose(); return(1); } catch (DbUpdateConcurrencyException) { return(0); } }
private void PopulateStudentAccountDetails(Account studentAccount, FeeMaster feeMaster, Student student, AcademicYear currentAcademicYear) { if (lblStudentNameSelected != null && lblStudentmName != null && lblStudentfName != null && lblStudentcName != null && lblStudentsName != null && lblStudentMediumName != null && lblStudentFeeDue != null && txtStudentDiscount != null && lblStudentCarryFarwordFee != null && lblStuddentCurrentYearFee != null && lblStudentCurrentYearFeePaid != null && lblCurrentAcademicYear != null && studentAccount != null && feeMaster != null) { var scholarShipToatlAmountSanctioned = 0; var scholarShipDetailsOfCurrentYear = PageDataService.GetScholarShipDetailsByStudentIdAndAcademicYearIdAdoNet(student.StudentId, currentAcademicYear. AcademicYearId); scholarShipToatlAmountSanctioned = scholarShipDetailsOfCurrentYear.Aggregate(0, (current, scholarShipDetail) => current + Convert.ToInt32( scholarShipDetail. AmountSanctioned)); var transactionDetailList = PageDataService. GetAllActiveTransactionDetailsByStudentIdByAccountIdByAcademicYearIdAdoNet (student.StudentId, studentAccount.AccountId, currentAcademicYear.AcademicYearId); lblStudentFeeDue.Text = Convert.ToString(Convert.ToInt32(feeMaster.Fee) + Convert.ToInt32(studentAccount.CarryFarwordFee) - (Convert.ToInt32(studentAccount.Discount) + scholarShipToatlAmountSanctioned)); var dueAmount = Convert.ToInt32(feeMaster.Fee) + Convert.ToInt32(studentAccount.CarryFarwordFee) - (Convert.ToInt32(studentAccount.Discount) + scholarShipToatlAmountSanctioned); if (transactionDetailList != null && transactionDetailList.Count > 0) { var totalAmountPaid = transactionDetailList.Aggregate(0, (current, transactionDetail) => current + Convert.ToInt32(transactionDetail.AmountPaid)); var feeDue = (Convert.ToInt32(feeMaster.Fee) + Convert.ToInt32(studentAccount.CarryFarwordFee) - (totalAmountPaid + Convert.ToInt32(studentAccount.Discount) + Convert.ToInt32(scholarShipToatlAmountSanctioned))); dueAmount = feeDue; btnSubmit.Enabled = txtStudentCurrentFee.Enabled = feeDue > 0; lblStudentMessage.Visible = feeDue <= 0; lblStudentFeeDue.Text = Convert.ToString(feeDue); } hdnStudentId.Value = Convert.ToString(student.StudentId); hdnAccountId.Value = Convert.ToString(studentAccount.AccountId); ViewState["MinimumValue"] = (dueAmount <= 0) ? "0" : "1"; ViewState["MaximumValue"] = dueAmount <= 0 ? Convert.ToString(1) : Convert.ToString(dueAmount); ViewState["ErrorMessage"] = "Enter amount between " + rngFee.MinimumValue + "-" + Convert.ToString(dueAmount); lblStudentNameSelected.Text = student.StudentName; lblStudentfName.Text = student.FatherName; lblStudentmName.Text = student.MotherName; lblStudentcName.Text = student.Class1.ClassName; lblStudentsName.Text = student.Section.SectionName; lblStudentMediumName.Text = student.Medium.MediumName; lblStudentCarryFarwordFee.Text = Convert.ToString(studentAccount.CarryFarwordFee); lblStuddentCurrentYearFee.Text = Convert.ToString(feeMaster.Fee); lblStudentCurrentYearFeePaid.Text = studentAccount.FeePaid != null ? Convert.ToString(studentAccount.FeePaid) : "-"; lblCurrentAcademicYear.Text = currentAcademicYear.AcademicYearStart.ToString("dd/MM/yyyy") + " - " + currentAcademicYear.AcademicYearEnd.ToString("dd/MM/yyyy"); lblTotalScholarShipAmountForStudent.Text = Convert.ToString(scholarShipToatlAmountSanctioned); txtStudentDiscount.Text = studentAccount.Discount == null ? "0" : Convert.ToString(studentAccount.Discount); } }
private void showprofile(string id) { try { dtinfo.ShortDatePattern = "dd/MM/yyyy"; dtinfo.DateSeparator = "/"; con.Close(); con.Open(); cmd = new SqlCommand("select Name from Member where ID='" + id.ToString() + "'", con); string chkexist = Convert.ToString(cmd.ExecuteScalar()); if (chkexist == "") { //lblException.Text = "Invalid Membership No." + txtIMID.Text.ToString(); txtIMID.Text = ""; panelProfile.Visible = false; panelChangeStatus.Visible = false; panelSubscribe.Visible = false; txtIMID.Focus(); } else { SqlDataReader reader; cmd = new SqlCommand("select max(TransID) from MemberFee where ID='" + id.ToString() + "'", con); string tid = Convert.ToString(cmd.ExecuteScalar()); if (tid == "") { tid = "0"; lblBalance.Text = "0"; lblBalanceType.Text = ""; } else { cmd = new SqlCommand("select TransType, Balance from MemberFee where ID='" + id.ToString() + "' and TransID='" + Convert.ToInt32(tid.ToString()) + "'", con); reader = cmd.ExecuteReader(); while (reader.Read()) { lblBalanceType.Text = reader["TransType"].ToString(); lblBalance.Text = reader["Balance"].ToString().TrimEnd('0').TrimEnd('.'); } reader.Close(); } panelProfile.Visible = true; panelChangeStatus.Visible = true; panelSubscribe.Visible = true; cmd = new SqlCommand("select * from Member where ID='" + id.ToString() + "'", con); reader = cmd.ExecuteReader(); while (reader.Read()) { lblName.Text = reader[3].ToString(); lblMemberTyep.Text = reader["Type"].ToString(); lblID.Text = reader[2].ToString(); lblAddress.Text = reader[7].ToString(); lblCity.Text = reader["Address2"].ToString() + ", " + reader[8].ToString(); lblEmail.Text = reader[14].ToString(); lblPhonne.Text = reader[10].ToString(); lblMobile.Text = reader[13].ToString(); string sts = reader[71].ToString(); if (sts.ToString() == "yes" | sts.ToString() == "Active") { lblStatus2.Text = "Active"; btnchangeStatus.Text = "Disactive"; } else if (sts.ToString() == "Register" | sts.ToString() == "Registered") { lblStatus2.Text = "New Registration"; btnchangeStatus.Text = "Generate Membership"; } else { lblStatus2.Text = "Disactive"; btnchangeStatus.Text = "Active"; } lblEnrollDate.Text = Convert.ToDateTime(reader[72].ToString()).ToString("dd/MM/yyyy"); lblRenuwalDate.Text = Convert.ToDateTime(reader[73].ToString()).ToString("dd/MM/yyyy"); lblExpDate.Text = Convert.ToDateTime(reader[74].ToString()).ToString("dd/MM/yyyy"); lblfrom.Text = reader[75].ToString(); lblTo.Text = reader[76].ToString(); } reader.Close(); GridBalance.DataSource = GridBalanceData(id); GridBalance.DataBind(); getFee(); FeeMaster fm = new FeeMaster(); lblSubscriptionFrom.Text = fm.nextSession(lblTo.Text); lblSubscriptionTo.Text = fm.nextSession(lblSubscriptionFrom.Text.ToString()); } } catch (SqlException ex) { panelProfile.Visible = false; panelChangeStatus.Visible = false; panelSubscribe.Visible = false; } finally { con.Close(); } }