public ActionResult GetWitness(Loan data)
{
List <Witness> ret = new List <Witness>();
ret = WitnessControllerSql.GetAll(data.LoanId);
return(Json(new { data = ret }, JsonRequestBehavior.AllowGet));
}
public ActionResult Download()
{
int id = Convert.ToInt32(Session["MemberId"]);
LocalReport localreport = new LocalReport();
localreport.ReportPath = Server.MapPath("~/Views/Report/Loan.rdlc");
ReportDataSource rd1 = new ReportDataSource();
ReportDataSource rd2 = new ReportDataSource();
ReportDataSource rd = new ReportDataSource();
List <LoanReport> data = new List <LoanReport>();
data = LoanReportControllerSql.GetAll(id);
rd.Name = "LoanReportt";
rd.Value = data.ToList();
List <Comaker> data1 = new List <Comaker>();
data1 = ComakerControllerSql.GetCo(data[0].Id.ToString());
localreport.DataSources.Add(rd);
rd1.Name = "ComakerReportt";
rd1.Value = data1.ToList();
List <Witness> data2 = new List <Witness>();
data2 = WitnessControllerSql.GetAll(data[0].Id.ToString());
localreport.DataSources.Add(rd1);
rd2.Name = "WitnessReportt";
rd2.Value = data2.ToList();
localreport.DataSources.Add(rd2);
string reportType = "PDF";
string mimetype;
string encoding;
string filenameExtension = "pdf";
string[] streams;
Warning[] warnings;
byte[] renderbyte;
string deviceInfo = "<DeviceInfo><OutputFormat>PDF</OutputFormat><PageWidth>8.5in</PageWidth><PageHeight>11in</PageHeight><MarginTop>0.5in</MarginTop><MarginLeft>11in</MarginLeft><MarginRight>11in</MarginRight><MarginBottom>0.5in</MarginBottom></DeviceInfo>";
renderbyte = localreport.Render(reportType, deviceInfo, out mimetype, out encoding, out filenameExtension, out streams, out warnings);
Response.AddHeader("content-disposition", "attachment;filename=LoanInfo." + filenameExtension);
return(File(renderbyte, filenameExtension));
}
public ActionResult Loan(FormCollection fc)
{
bool status = false;
decimal loanamt = Convert.ToDecimal(fc["amt"]);
int terms = Convert.ToInt32(fc["mtp"]);
decimal totalwinterest = Convert.ToDecimal(fc["totalwinterest"]);
int mid = Convert.ToInt32(Session["MemberId"]);
string w1 = Convert.ToString(fc["witness1"]);
string w2 = Convert.ToString(fc["witness2"]);
string w3 = Convert.ToString(fc["witness3"]);
int no = Convert.ToInt32(fc["no"]);
List <Loan> listloan = new List <Loan>();
listloan = LoanControllerSql.GetAll();
int cid = listloan.Count + 1;
string lid = "L" + cid.ToString();
DateTime d = DateTime.Now;
Loan loan = new Loan
{
LoanId = lid,
MemberId = mid,
Status = "Pending",
CreatedDate = d,
ApprovalDate = d,
LoanAmt = loanamt,
Terms = terms,
InterestRate = 1,
TotalPaymentwInterest = totalwinterest,
ApprovedBy = "none"
};
status = LoanControllerSql.Insert(loan);
if (status == true)
{
Witness w = new Witness
{
LoanId = lid,
WitnessName = w1,
};
status = WitnessControllerSql.Insert(w);
Witness wm1 = new Witness
{
LoanId = lid,
WitnessName = w2,
};
status = WitnessControllerSql.Insert(wm1);
Witness wm2 = new Witness
{
LoanId = lid,
WitnessName = w3,
};
status = WitnessControllerSql.Insert(wm2);
Response.Write("<script>alert('Success');</script>");
for (int i = 0; i <= no - 1; i++)
{
string name = Convert.ToString(fc["co" + i]);
string contact = Convert.ToString(fc["cno" + i]);
string MID = Convert.ToString(fc["CMID" + i]);
if (MID == "")
{
MID = "0";
}
List <Member> m = new List <Member>();
m = MemberControllerSql.Get(MID);
if (m.Count > 0)
{
Comaker co = new Comaker
{
LoanId = lid,
Name = name,
ContactNo = contact,
MemberId = MID
};
status = ComakerControllerSql.Insert(co);
}
else
{
Response.Write("<script type='text/javascript'>alert(Member Id: " + MID + "' doesn't exist');</script>");
return(View());
}
}
if (status == true)
{
Session["Success"] = "1";
return(RedirectToAction("Home", "Member"));
}
}
return(View());
}
