public void getCertificateData()
{
try
{
ConvertNumberToWords CNTW = new ConvertNumberToWords();
IncomeCertificate ICdal = new IncomeCertificate();
IncomeCertificateModel ICModel = new IncomeCertificateModel();
ICModel.UID = Convert.ToInt64(Session["UID"]);
ICModel.DateFrom = Convert.ToDateTime(txtdatefrom.Text);
ICModel.DateTo = Convert.ToDateTime(txtdateto.Text);
DataSet ds = ICdal.getICD(ICModel);
if (ds.Tables[0].Rows.Count > 0)
{
Label1.Text = DateTime.Now.ToShortDateString();
DataSet sdDS = (DataSet)(ViewState["StudentDetail"]);
DataRow sddr = sdDS.Tables[0].Rows[0];
DataRow dr = ds.Tables[0].Rows[0];
if (string.IsNullOrEmpty(dr["total"].ToString()))
{
lblError.Visible = true;
// lblMessage.Visible = false;
lblError.Text = "No Fee paid from " + txtdatefrom.Text + " To " + txtdateto.Text;
//lblError.Text = "No Fee paid from " + DateFrom.SelectedDate.ToShortDateString() + " To " + DateTo.SelectedDate.ToShortDateString();
}
else
{
Label3.Text = sddr["StudentName"].ToString(); //students Name
Label2.Text = sddr["FathersName"].ToString(); //Fathers Name
Label4.Text = sddr["PresentAddress"].ToString(); //R/o
Label5.Text = sddr["ClassName"].ToString();; //Class name
Label6.Text = sddr["SectionName"].ToString();; //Class name
// lblFeeHeads.Text = "tution";//fee Head
lbltotalPaid.Text = dr["total"].ToString();
string inwords = CNTW.ConvertNumbertoWords(Convert.ToInt64(dr["total"]));
lblwords.Text = inwords; // Amount in words
lblDateFrom.Text = txtdatefrom.Text; /*DateFrom.SelectedDate.ToShortDateString();*/ //from date
lblDateTo.Text = txtdateto.Text; /*DateTo.SelectedDate.ToShortDateString();*/ //to date
}
}
else
{
lblError.Visible = true;
// lblMessage.Visible = false;
//lblError.Text = "No Fee paid from " + DateFrom.SelectedDate.ToShortDateString() + " To " + DateTo.SelectedDate.ToShortDateString();
lblError.Text = "No Fee paid from " + txtdatefrom.Text + " To " + txtdateto.Text;
}
}
catch (Exception ex)
{
lblError.Visible = true;
//lblMessage.Visible = false;
lblError.Text = ex.ToString();
}
}
public ActionResult Edit([Bind(Include = "IncomeCertificateID,PersonName,RelationName,Address,IncomeAmt,YearOf,OfficeName,PurposeOf,Inquiry,ReportNo,InquiryDate,Place,PrintDate,UserID,RegisterTypeID,WEBstatusID")] IncomeCertificate incomeCertificate)
{
ViewBag.RegisterTypeID = incomeCertificate.RegisterTypeID;
if (ModelState.IsValid)
{
db.Entry(incomeCertificate).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { rt = incomeCertificate.RegisterTypeID }));
}
ViewBag.WEBstatusID = new SelectList(db.WEBstatus, "WebStatusID", "Status", incomeCertificate.WEBstatusID);
return(View(incomeCertificate));
}
public ActionResult Create([Bind(Include = "IncomeCertificateID,PersonName,RelationName,Address,IncomeAmt,YearOf,OfficeName,PurposeOf,Inquiry,ReportNo,InquiryDate,Place,PrintDate,UserID,RegisterTypeID,WEBstatusID")] IncomeCertificate incomeCertificate)
{
if (ModelState.IsValid)
{
incomeCertificate.UserID = User.Identity.GetUserId();
incomeCertificate.WEBstatusID = 1;
db.IncomeCertificates.Add(incomeCertificate);
db.SaveChanges();
return(RedirectToAction("Index", new { rt = incomeCertificate.RegisterTypeID }));
}
ViewBag.RegisterTypeID = new SelectList(db.RegisterTypes, "RegisterTypeID", "RegisterType1", incomeCertificate.RegisterTypeID);
ViewBag.WEBstatusID = new SelectList(db.WEBstatus, "WebStatusID", "Status", incomeCertificate.WEBstatusID);
return(View(incomeCertificate));
}
// GET: IncomeCertificates/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IncomeCertificate incomeCertificate = db.IncomeCertificates.Find(id);
ViewBag.vp = db.Configs.Select(a => a.VP).FirstOrDefault();
if (incomeCertificate == null)
{
return(HttpNotFound());
}
return(View(incomeCertificate));
}
// GET: IncomeCertificates/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IncomeCertificate incomeCertificate = db.IncomeCertificates.Find(id);
ViewBag.RegisterTypeID = incomeCertificate.RegisterTypeID;
if (incomeCertificate == null)
{
return(HttpNotFound());
}
ViewBag.WEBstatusID = new SelectList(db.WEBstatus, "WebStatusID", "Status", incomeCertificate.WEBstatusID);
return(View(incomeCertificate));
}