public void uploadAndCreate(string cid) { ClientC c = new ClientC(); Client client = c.FindClient(cid); client.MiddleProcess = "2"; c.UpdateClient(client); SendEmailC send = new SendEmailC(); Client c1 = c.FindClient(cid); UserC u = new UserC(); string message = "Client: " + c1.Mail + " " + c1.MobileNum + " " + c1.Fname + " " + c1.Lname + "Send he reports"; send.SendEmailF(u.FindNeedEmail("Manager", cid), "Report Of " + c1.Fname + " " + c1.Lname, message); }
public void approveLoan2(Loans2 l) { ClientC inter = new ClientC(); Client c = inter.FindClient(l.ClientId); c.MiddleProcess = "2app"; inter.UpdateClient(c); }
public void SendLoans2(Loans2 l)//send to approve { Loans2C inter = new Loans2C(); inter.UpdateLoan2(l); ClientC inter1 = new ClientC(); Client c = inter1.FindClient(l.ClientId); c.MiddleProcess = "2"; inter1.UpdateClient(c); }
public void CreateLoan2(Loans2 l)//create second step when click save { ClientC inter1 = new ClientC(); if (inter1.FindClient(l.ClientId).MiddleProcess == "1") { throw new Exception("The Loan Didn't Approved Yet"); } Loans2C inter = new Loans2C(); inter.CreateLoan2(l); }
public void addNewReqDoc(ReqDocs r) { ReqDocsC inter = new ReqDocsC(); inter.insertDB(r); ClientC inter1 = new ClientC(); Client c = inter1.FindClient(r.clientId); if (!c.Request) { c.Request = true; inter1.UpdateClient(c); } inter.insertDB(r); }
public void CreateLoan1(Loans1 l) { l.Id = getId(); while (con.State == ConnectionState.Open) { System.Threading.Thread.Sleep(500); } con.Open(); string query = "INSERT INTO Loans1 (Id,BusinessName,DBAName,Pcontact,TaxID,SS,Tel,Mail,Street,Own,City,State,Zip,Mstreet,Mcity,Mstate,Mzip,Chose1,DateBE,StateoOI,EmployeesNum,Explains,Chose2,Acompanies,Approved,ClientId,Close) VALUES (@Id,@BusinessName,@DBAName,@Pcontact,@TaxID,@SS,@Tel,@Mail,@Street,@Own,@City,@State,@Zip,@Mstreet,@Mcity,@Mstate,@Mzip,@Chose1,@DateBE,@StateoOI,@EmployeesNum,@Explain,@Chose2,@Acompanies,@Approved,@ClientId,@Close)"; MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("@Id", l.Id); cmd.Parameters.AddWithValue("@BusinessName", l.BusinessName); cmd.Parameters.AddWithValue("@DBAName", l.DBAName); cmd.Parameters.AddWithValue("@Pcontact", l.Pcontact); cmd.Parameters.AddWithValue("@TaxID", l.TaxID); cmd.Parameters.AddWithValue("@SS", l.SS); cmd.Parameters.AddWithValue("@Tel", l.Tel); cmd.Parameters.AddWithValue("@Mail", l.Mail); cmd.Parameters.AddWithValue("@Street", l.Street); cmd.Parameters.AddWithValue("@Own", l.Own); cmd.Parameters.AddWithValue("@City", l.City); cmd.Parameters.AddWithValue("@State", l.State); cmd.Parameters.AddWithValue("@Zip", l.Zip); cmd.Parameters.AddWithValue("@Mstreet", l.Mstreet); cmd.Parameters.AddWithValue("@Mcity", l.Mcity); cmd.Parameters.AddWithValue("@Mstate", l.Mstate); cmd.Parameters.AddWithValue("@Mzip", l.Mzip); cmd.Parameters.AddWithValue("@Chose1", l.Chose1); cmd.Parameters.AddWithValue("@DateBE", l.DateBE); cmd.Parameters.AddWithValue("@StateoOI", l.StateoOI); cmd.Parameters.AddWithValue("@EmployeesNum", l.EmployeesNum); cmd.Parameters.AddWithValue("@Explain", l.Explains); cmd.Parameters.AddWithValue("@Chose2", l.Chose2); cmd.Parameters.AddWithValue("@Acompanies", l.Acompanies); cmd.Parameters.AddWithValue("@Approved", l.Approved); cmd.Parameters.AddWithValue("@ClientId", l.ClientId); cmd.Parameters.AddWithValue("@Close", Convert.ToInt32(l.Close)); cmd.ExecuteNonQuery(); con.Close(); ClientC inter = new ClientC(); Client c = inter.FindClient(l.ClientId); c.MiddleProcess = "1"; inter.UpdateClient(c); }
void CreatLoans1(Loans1 l)//create a loan { Loan1Checks(l); Loans1C inter = new Loans1C(); inter.CreateLoan1(l); ClientC client = new ClientC(); Client c = client.FindClient(l.ClientId); c.MiddleProcess = "1"; client.UpdateClient(c); //send mail to the manager #region send mail to employee //need to change string managerMail = "*****@*****.**"; var fromAddress = new MailAddress("*****@*****.**", "Cavalry Associates"); var toAddress = new MailAddress(managerMail, c.Fname + " " + c.Lname + " Ask For Loan"); const string fromPassword = "******"; string subject = c.Fname + " " + c.Lname + " Ask For Loan"; string body = "<h1> The Client: " + c.Fname + " " + c.Lname + " " + c.Mail + " Ask For A Loan</h1>" + "<img src=\"https://app.synccos.com/assets/images/cavalry-signin.png\" alt=\"Trulli\" width=\"500\" height=\"333\"></p>"; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(fromAddress.Address, fromPassword) }; using (var message = new MailMessage(fromAddress, toAddress) { Subject = subject, Body = body }) { message.IsBodyHtml = true; smtp.Send(message); } #endregion }
public void Submit(Loans1 l, string status, string uid) { if (status == "Client") { ClientC interc = new ClientC(); if (interc.FindIfClientHasLoan(l.ClientId)) { //ClientGlobal global = new ClientGlobal(); UpdateLoan1(FindLoan1ByClient(l.ClientId)); throw new Exception("The First Stage Has Been Successfully Updated"); } else { Loans1 l1 = new Loans1(FindLoan1ByClient(l.ClientId)); l.Id = l1.Id; CreatLoans1(l); UserC u = new UserC(); SendEmailC send = new SendEmailC(); ClientC c = new ClientC(); Client c1 = c.FindClient(uid); string message = "Client: " + c1.Mail + " " + c1.MobileNum + " " + c1.Fname + " " + c1.Lname + "Want a loan"; send.SendEmailF(u.FindNeedEmail("Manager", uid), "Ask For Loan" + c1.Fname + " " + c1.Lname, message); } } else { //status will be the employee id UpdateLoan1(FindLoan1ByClient(l.ClientId)); ClientGlobal global = new ClientGlobal(); Client c = global.FindClient(l.ClientId); if (c.MiddleProcess == "1") { c.MiddleProcess = "1app"; global.UpdateClient(c); } SendEmailC send = new SendEmailC(); ClientC clientC = new ClientC(); Client c1 = clientC.FindClient(uid); string message = "Hello " + c1.Fname + " " + c1.Lname + "We wanted to let you know that the application approved"; send.SendEmailF(c1.Mail, "Approved Application", message); } }
public void AddNewRD(string reqDocs, string clientId) { ReqDocsC i = new ReqDocsC(); List <string> l = reqDocs.Split('@').ToList(); foreach (var v in l) { if (v != "") { i.insertDB(new ReqDocs(clientId, v, "")); } } ClientC inter = new ClientC(); Client c = inter.FindClient(clientId); if (!c.Request) { c.Request = true; inter.UpdateClient(c); } }
public Client FindClient(string Id)//find the information for client that you can fill { ClientC inter = new ClientC(); return(inter.FindClient(Id)); }
public void DeleteClient(string id) { ClientC c = new ClientC(); c.RemoveClient(c.FindClient(id)); }
public void Finish(Loans2 l) { try { if (Convert.ToInt32(l.OpenCC) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Credit Cards@1"); } try { if (Convert.ToInt32(l.OpenRC) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Retail Cards@1"); } try { if (Convert.ToInt32(l.OpenRELoans) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Real Estate Loans@1"); } try { if (Convert.ToInt32(l.OpenILoans) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Installment Loans@1"); } try { if (Convert.ToInt32(l.TotalOpenAcc) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Total Open Account@1"); } try { if (Convert.ToInt32(l.AcceverLate) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Account Ever Late@1"); } try { if (Convert.ToInt32(l.CollectionAcc) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Collection Account@1"); } try { if (Convert.ToInt32(l.AvgAccAge.Split('/')[0]) < 1 || Convert.ToInt32(l.AvgAccAge.Split('/')[0]) > 12) { throw new Exception(); } } catch { throw new Exception("Unavailable Month Of Average Account Age @1"); } try { if (Convert.ToInt32(l.AvgAccAge.Split('/')[1]) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Year Of Average Account Age @1"); } try { if (Convert.ToInt32(l.OldestAcc.Split('/')[0]) < 1 || Convert.ToInt32(l.AvgAccAge.Split('/')[0]) > 12) { throw new Exception(); } } catch { throw new Exception("Unavailable Month Of Oldest Account @1"); } try { if (Convert.ToInt32(l.OldestAcc.Split('/')[1]) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Year Of Oldest Account @1"); } try { if (Convert.ToInt32(l.CRDebt) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Credit And Retail Card Debt@1"); } try { if (Convert.ToInt32(l.REDebt) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Real Estate Debt@1"); } try { if (Convert.ToInt32(l.ILDebt) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Installment Loans Debt@1"); } try { if (Convert.ToInt32(l.CollectionDebt) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Collections Debt@1"); } try { if (Convert.ToInt32(l.TDebt) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Total Debt@1"); } foreach (var v in l.CAccList) { AddAccount(v); } foreach (var v in l.InqList) { AddInquiries(v); } try { if (Convert.ToInt32(l.Experian) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Experian @5"); } try { if (Convert.ToInt32(l.Equifax) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Equifax@5"); } try { if (Convert.ToInt32(l.TransUnio) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Trans Unio @5"); } try { if (Convert.ToInt32(l.Fico2) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Fico 2 @5"); } try { if (Convert.ToInt32(l.Fico8) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Fico 8 @5"); } try { if (Convert.ToInt32(l.Fico3) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Fico 3 @5"); } Loans2C loans2C = new Loans2C(); loans2C.UpdateLoan2(l); ClientC c = new ClientC(); Client client = c.FindClient(l.ClientId); client.MiddleProcess = "2app"; c.UpdateClient(client); string message = "We want to let you know that the report was approved"; SendEmailC send = new SendEmailC(); send.SendEmailF(client.Mail, "The Report Was Approved", message); }
public void Send(Loans2 l) { //try //{ // if (Convert.ToInt32(l.OpenCC.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Open Credit Cards@1"); //} //try //{ // if (Convert.ToInt32(l.OpenRC.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Open Retail Cards@1"); //} //try //{ // if (Convert.ToInt32(l.OpenRELoans.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Open Real Estate Loans@1"); //} //try //{ // if (Convert.ToInt32(l.OpenILoans.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Open Installment Loans@1"); //} //try //{ // if (Convert.ToInt32(l.TotalOpenAcc.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Total Open Account@1"); //} //try //{ // if (Convert.ToInt32(l.AcceverLate.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Account Ever Late@1"); //} //try //{ // if (Convert.ToInt32(l.CollectionAcc.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Collection Account@1"); //} //try //{ // if (Convert.ToInt32(l.AvgAccAge.Split('/')[0]) < 1 || Convert.ToInt32(l.AvgAccAge.Split('/')[0]) > 12) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Month Of Average Account Age @1"); //} //try //{ // if (Convert.ToInt32(l.AvgAccAge.Split('/')[1]) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Year Of Average Account Age @1"); //} //try //{ // if (Convert.ToInt32(l.OldestAcc.Split('/')[0]) < 1 || Convert.ToInt32(l.AvgAccAge.Split('/')[0]) > 12) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Month Of Oldest Account @1"); //} //try //{ // if (Convert.ToInt32(l.OldestAcc.Split('/')[1]) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Year Of Oldest Account @1"); //} //try //{ // if (Convert.ToInt32(l.CRDebt.Replace(",","")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Credit And Retail Card Debt@1"); //} //try //{ // if (Convert.ToInt32(l.REDebt.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Real Estate Debt@1"); //} //try //{ // if (Convert.ToInt32(l.ILDebt.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Installment Loans Debt@1"); //} //try //{ // if (Convert.ToInt32(l.CollectionDebt.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Collections Debt@1"); //} //try //{ // if (Convert.ToInt32(l.TDebt.Replace(",", "")) < 0) // throw new Exception(); //} //catch //{ // throw new Exception("Unavailable Total Debt@1"); //} foreach (var v in l.CAccList) { AddAccount(v); } foreach (var v in l.InqList) { AddInquiries(v); } try { if (Convert.ToInt32(l.Experian.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Experian @5"); } try { if (Convert.ToInt32(l.Equifax.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Equifax@5"); } try { if (Convert.ToInt32(l.TransUnio.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Trans Unio @5"); } Loans2C loans2C = new Loans2C(); loans2C.UpdateLoan2(l); ClientC c = new ClientC(); Client client = c.FindClient(l.ClientId); client.MiddleProcess = "2napp"; c.UpdateClient(client); UserC u = new UserC(); SendEmailC send = new SendEmailC(); string message = "We want to let you know that there are several problrm in your report. Please enter to our system(to the report) and change them. (you will have a comments in the system about the changes)"; send.SendEmailF(client.Mail, "The Report Of" + client.Fname + " " + client.Lname, message); }
public void Submit(Loans2 l)//save (update) and change the status and let the employee knows { try { if (Convert.ToInt32(l.OpenCC) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Credit Cards@1"); } try { if (Convert.ToInt32(l.OpenRC) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Retail Cards@1"); } try { if (Convert.ToInt32(l.OpenRELoans) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Real Estate Loans@1"); } try { if (Convert.ToInt32(l.OpenILoans) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Open Installment Loans@1"); } try { if (Convert.ToInt32(l.TotalOpenAcc) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Total Open Account@1"); } try { if (Convert.ToInt32(l.AcceverLate) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Account Ever Late@1"); } try { if (Convert.ToInt32(l.CollectionAcc) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Collection Account@1"); } try { if (Convert.ToInt32(l.AvgAccAge.Split('/')[0]) < 1 || Convert.ToInt32(l.AvgAccAge.Split('/')[0]) > 12) { throw new Exception(); } } catch { throw new Exception("Unavailable Month Of Average Account Age @1"); } try { if (Convert.ToInt32(l.AvgAccAge.Split('/')[1]) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Year Of Average Account Age @1"); } try { if (Convert.ToInt32(l.OldestAcc.Split('/')[0]) < 1 || Convert.ToInt32(l.AvgAccAge.Split('/')[0]) > 12) { throw new Exception(); } } catch { throw new Exception("Unavailable Month Of Oldest Account @1"); } try { if (Convert.ToInt32(l.OldestAcc.Split('/')[1]) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Year Of Oldest Account @1"); } try { if (Convert.ToInt32(l.CRDebt.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Credit And Retail Card Debt@1"); } try { if (Convert.ToInt32(l.REDebt.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Real Estate Debt@1"); } try { if (Convert.ToInt32(l.ILDebt.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Installment Loans Debt@1"); } try { if (Convert.ToInt32(l.CollectionDebt.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Collections Debt@1"); } try { if (Convert.ToInt32(l.TDebt.Replace(",", "")) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Total Debt@1"); } foreach (var v in l.CAccList) { AddAccount(v); } foreach (var v in l.InqList) { AddInquiries(v); } try { if (Convert.ToInt32(l.Experian) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Experian @5"); } try { if (Convert.ToInt32(l.Equifax) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Equifax@5"); } try { if (Convert.ToInt32(l.TransUnio) < 0) { throw new Exception(); } } catch { throw new Exception("Unavailable Trans Unio @5"); } Loans2C loans2C = new Loans2C(); string message = ""; ClientC c = new ClientC(); Client c1 = c.FindClient(l.ClientId); if (loans2C.checkIfExist(l.ClientId)) { loans2C.UpdateLoan2(l); message = c1.Fname + " " + c1.Lname + " " + c1.Mail + " " + c1.MobileNum + " " + "Change the report"; } else { loans2C.CreateLoan2(l); message = c1.Fname + " " + c1.Lname + " " + c1.Mail + " " + c1.MobileNum + " " + "Send report"; } c1.MiddleProcess = "2"; c.UpdateClient(c1); SendEmailC send = new SendEmailC(); UserC u = new UserC(); send.SendEmailF(u.FindNeedEmail("Manager", l.ClientId), "Report Of " + c1.Fname + " " + c1.Lname, message); }