public void EditClient(Client newC)
{
if (newC.Mail == "" || !newC.Mail.Contains("@"))
{
throw new Exception("Unavailable Email");
}
if (newC.Address == "" || newC.City == "")
{
throw new Exception("Unavailable Address");
}
if (newC.WorkNum == "")
{
throw new Exception("Unavailable Work Phone");
}
if (newC.HomeNum == "")
{
throw new Exception("Unavailable Home Phone");
}
if (newC.MobileNum == "")
{
throw new Exception("Unavailable Mobile Phone");
}
if (newC.Lname == "" || newC.Fname == "")
{
throw new Exception("The Name File Is Missing");
}
ClientC c = new ClientC();
c.UpdateClient(newC);
}
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 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 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 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 void UpdateClient(Client c)
{
ClientC inter = new ClientC();
inter.UpdateClient(c);
}
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);
}