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