public IList <FileUploadDetails> GetLoans()
{
SqlConnection con = new SqlConnection();
DataTable dt = new DataTable();
IList <FileUploadDetails> FileUploadDetailsList = new List <FileUploadDetails>();
try
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["Bankingsysconn"].ConnectionString;
con.Open();
string getDetails = Query.selectGetLoans;
SqlCommand cmd1 = new SqlCommand(getDetails, con);
SqlDataReader dr1 = cmd1.ExecuteReader();
dt.Columns.AddRange(new DataColumn[11] {
new DataColumn("Account number", typeof(string)),
new DataColumn("Loans", typeof(string)),
new DataColumn("Loan Amount", typeof(string)),
new DataColumn("upload Documents", typeof(string)),
new DataColumn("Type Of Employement", typeof(string)),
new DataColumn("Income Per month", typeof(string)),
new DataColumn("Payslips", typeof(string)),
new DataColumn("Image", typeof(string)),
new DataColumn("City", typeof(string)),
new DataColumn("LoanApplyDate", typeof(string)),
new DataColumn("Approved Loans", typeof(string))
});
while (dr1.Read())
{
FileUploadDetails detail = new FileUploadDetails();
detail.AccountNo = Convert.ToString(dr1["account_no"]);
detail.Loans = Convert.ToString(dr1["loans"]);
detail.LoanAmount = Convert.ToString(dr1["loan_amount"]);
detail.UploadDocuments = Convert.ToString(dr1["upload_documents"]);
detail.TypeOfEmployement = Convert.ToString(dr1["type_of_employment"]);
detail.IncomePerMonth = Convert.ToString(dr1["income_per_month"]);
detail.Payslips = Convert.ToString(dr1["payslips"]);
detail.Image = Convert.ToString(dr1["image"]);
detail.City = Convert.ToString(dr1["city"]);
detail.LoanApplyDate = Convert.ToString(dr1["Loan_ApplyDate"]);
detail.ApprovedLoans = Convert.ToString(dr1["approved_loans"]);
FileUploadDetailsList.Add(detail);
}
dr1.Close();
}
finally
{
con.Close();
}
return(FileUploadDetailsList);
}
public ActionResult UpdateFileDetails(BuyerDetailViewModel vm)
{
List <DocumentUploaded> dm = new List <DocumentUploaded>();
var AddressDetailFileCount = db.DocumentUploadeds.Where(x => x.BuyerId == vm.BuyerId && x.FileType == 1).Count();
var ApplicationDetailFileCount = db.DocumentUploadeds.Where(x => x.BuyerId == vm.BuyerId && x.FileType == 2).Count();
var IncomeProofDetailFileCount = db.DocumentUploadeds.Where(x => x.BuyerId == vm.BuyerId && x.FileType == 3).Count();
var BankStatementDetailFileCount = db.DocumentUploadeds.Where(x => x.BuyerId == vm.BuyerId && x.FileType == 4).Count();
var IdentityProofDetailFileCount = db.DocumentUploadeds.Where(x => x.BuyerId == vm.BuyerId && x.FileType == 5).Count();
var ProfileDetailFileCount = db.DocumentUploadeds.Where(x => x.BuyerId == vm.BuyerId && x.FileType == 6).Count();
var CheckAddressDetailCount = AddressDetailFileCount + vm.addressProof.Count();
var CheckApplicationDetailCount = ApplicationDetailFileCount + vm.applicationForm.Count();
var CheckIncomeProofDetailCount = IncomeProofDetailFileCount + vm.incomeProof.Count();
var CheckBankStatementDetailCount = BankStatementDetailFileCount + vm.bankStatement.Count();
var CheckIndentityDetailCount = IdentityProofDetailFileCount + vm.identityProof.Count();
var CheckProfileDetailCount = ProfileDetailFileCount + vm.profileDocumet.Count();
if (vm.addressProof != null && CheckAddressDetailCount <= 5)
{
foreach (var fileitem in vm.addressProof)
{
if (fileitem != null)
{
var fileName = Path.GetFileName(fileitem.FileName);
var docDetail = new DocumentUploaded
{
BuyerId = vm.BuyerId,
FileName = fileName,
FileType = 1
};
dm.Add(docDetail);
var serverPath = Path.Combine(Server.MapPath("~/Content/Files"), fileName);
fileitem.SaveAs(serverPath);
}
}
foreach (var item in dm)
{
db.DocumentUploadeds.Add(item);
}
}
else
{
ViewBag.Message = "The No Of Files You are Uploading and Already Uploaded Should Not Exceed More Than 5";
}
if (vm.applicationForm != null && CheckApplicationDetailCount <= 5)
{
foreach (var fileitem in vm.applicationForm)
{
if (fileitem != null)
{
var fileName = Path.GetFileName(fileitem.FileName);
var docDetail = new DocumentUploaded
{
BuyerId = vm.BuyerId,
FileName = fileName,
FileType = 2
};
dm.Add(docDetail);
var serverPath = Path.Combine(Server.MapPath("~/Content/Files"), fileName);
fileitem.SaveAs(serverPath);
}
}
foreach (var item in dm)
{
db.DocumentUploadeds.Add(item);
}
}
if (vm.incomeProof != null && CheckIncomeProofDetailCount <= 5)
{
foreach (var fileitem in vm.incomeProof)
{
if (fileitem != null)
{
var fileName = Path.GetFileName(fileitem.FileName);
var docDetail = new DocumentUploaded
{
BuyerId = vm.BuyerId,
FileName = fileName,
FileType = 3
};
dm.Add(docDetail);
var serverPath = Path.Combine(Server.MapPath("~/Content/Files"), fileName);
fileitem.SaveAs(serverPath);
}
}
foreach (var item in dm)
{
db.DocumentUploadeds.Add(item);
}
}
if (vm.bankStatement != null && CheckBankStatementDetailCount <= 5)
{
foreach (var fileitem in vm.bankStatement)
{
if (fileitem != null)
{
var fileName = Path.GetFileName(fileitem.FileName);
var docDetail = new DocumentUploaded
{
BuyerId = vm.BuyerId,
FileName = fileName,
FileType = 4
};
dm.Add(docDetail);
var serverPath = Path.Combine(Server.MapPath("~/Content/Files"), fileName);
fileitem.SaveAs(serverPath);
}
}
foreach (var item in dm)
{
db.DocumentUploadeds.Add(item);
}
}
if (vm.identityProof != null && CheckIndentityDetailCount <= 5)
{
foreach (var fileitem in vm.identityProof)
{
if (fileitem != null)
{
var fileName = Path.GetFileName(fileitem.FileName);
var docDetail = new DocumentUploaded
{
BuyerId = vm.BuyerId,
FileName = fileName,
FileType = 5
};
dm.Add(docDetail);
var serverPath = Path.Combine(Server.MapPath("~/Content/Files"), fileName);
fileitem.SaveAs(serverPath);
}
}
foreach (var item in dm)
{
db.DocumentUploadeds.Add(item);
}
}
if (vm.profileDocumet != null && CheckProfileDetailCount <= 5)
{
foreach (var fileitem in vm.profileDocumet)
{
if (fileitem != null)
{
var fileName = Path.GetFileName(fileitem.FileName);
var docDetail = new DocumentUploaded
{
BuyerId = vm.BuyerId,
FileName = fileName,
FileType = 6
};
dm.Add(docDetail);
var serverPath = Path.Combine(Server.MapPath("~/Content/Files"), fileName);
fileitem.SaveAs(serverPath);
}
}
foreach (var item in dm)
{
db.DocumentUploadeds.Add(item);
}
}
var buyerDocuments = db.BuyerDocuments.Where(x => x.BuyerId == vm.BuyerId).FirstOrDefault();
if (buyerDocuments != null)
{
//Address Proof Details
buyerDocuments.PassportCopy = vm.PassportCopy;
buyerDocuments.DrivingLicenceWithDob = vm.DrivingLicenceWithDob;
buyerDocuments.VotersId = vm.VotersId;
buyerDocuments.ElectricityBill = vm.ElectricityBill;
buyerDocuments.TelephoneBill = vm.TelephoneBill;
buyerDocuments.LeaveLicenceAggrCopy = vm.LeaveLicenceAggrCopy;
buyerDocuments.CompanyAccoLetter = vm.CompanyAccoLetter;
buyerDocuments.OtherBankStatmnt = vm.OtherBankStatmnt;
buyerDocuments.TelephoneProof = vm.TelephoneProof;
buyerDocuments.AadharCardCopy = vm.AadharCardCopy;
buyerDocuments.AddressDetailId = vm.AddressProofDetailId;
//Application Form Details
buyerDocuments.ApplicationFormImaging = vm.ApplicationFormImaging;
buyerDocuments.ApplicationFormDetailId = vm.ApplicationFormDetailId;
//Income Proof
buyerDocuments.Form16 = vm.Form16;
buyerDocuments.AppointmentLetter = vm.AppointmentLetter;
buyerDocuments.SalarySlip = vm.SalarySlip;
buyerDocuments.Itr = vm.Itr;
buyerDocuments.GstCertification = vm.GstCertification;
buyerDocuments.IncomeProofDetailId = vm.IncomeProofDetailId;
//Bank Statement
buyerDocuments.BankStatementDetailId = vm.BankStatementDetailId;
buyerDocuments.BankStatementLatestSixMonths = vm.BankStatementLatestSixMonths;
buyerDocuments.BankStatmentThreeMonths = vm.BankStatmentThreeMonths;
buyerDocuments.BankStatementYear = vm.BankStatementYear;
//Identity Proof
buyerDocuments.VotersIdCard = vm.VotersIdCard;
buyerDocuments.IdentityProofDetailId = vm.IdentityProofDetailId;
//Profile Documents
buyerDocuments.PanCardId = vm.PanCardId;
buyerDocuments.ProfilePhoto = vm.ProfilePhoto;
buyerDocuments.ProfileDocumentDetailId = vm.ProfileDocumentDetailId;
}
else
{
var buyerDocChecks = new FileUploadDetails
{
PassportCopy = vm.PassportCopy,
DrivingLicenceWithDob = vm.DrivingLicenceWithDob,
VotersId = vm.VotersId,
ElectricityBill = vm.ElectricityBill,
TelephoneBill = vm.TelephoneBill,
LeaveLicenceAggrCopy = vm.LeaveLicenceAggrCopy,
CompanyAccoLetter = vm.CompanyAccoLetter,
OtherBankStatmnt = vm.OtherBankStatmnt,
TelephoneProof = vm.TelephoneProof,
AadharCardCopy = vm.AadharCardCopy,
BuyerId = vm.BuyerId,
AddressDetailId = 1,
//Application Form Details
ApplicationFormImaging = vm.ApplicationFormImaging,
ApplicationFormDetailId = 2,
//Income Proof
Form16 = vm.Form16,
AppointmentLetter = vm.AppointmentLetter,
SalarySlip = vm.SalarySlip,
Itr = vm.Itr,
GstCertification = vm.GstCertification,
IncomeProofDetailId = 3,
//Bank Statement
BankStatementDetailId = 4,
BankStatementLatestSixMonths = vm.BankStatementLatestSixMonths,
BankStatmentThreeMonths = vm.BankStatmentThreeMonths,
BankStatementYear = vm.BankStatementYear,
//Identity Proof
VotersIdCard = vm.VotersIdCard,
IdentityProofDetailId = 5,
//Profile Documents
PanCardId = vm.PanCardId,
ProfilePhoto = vm.ProfilePhoto,
ProfileDocumentDetailId = 6
};
db.BuyerDocuments.Add(buyerDocChecks);
}
Comments newcomment = new Comments();
newcomment.BuyerId = vm.BuyerId;
newcomment.CommentDetails = vm.PersonalComments;
newcomment.CommentDateTime = DateTime.Now;
db.Comments.Add(newcomment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public GalleryManagementDetails(IHostingEnvironment hostingEnvironment)
{
_db = new LetsPaintContext();
fileUploadDetails = new FileUploadDetails(hostingEnvironment);
}
