public bool UpdateEmployees()
{
try
{
TSSWebServiceReference.VFPWebServiceSoapClient srvDBObj = new TSSWebServiceReference.VFPWebServiceSoapClient();
var employeesList = srvDBObj.UpdateUsersData();
var db = new TSS_Sql_Entities();
foreach (var item in employeesList)
{
var empCheck = db.Employees.FirstOrDefault(s => s.First_name == item.Emcfname && s.Last_name == item.Emclname);
if (empCheck == null && Convert.ToInt32(empCheck.User_id) != Convert.ToInt32(item.Emcempid))
{
var employeeObj = new TotalStaffingSolutions.Models.Employee();
employeeObj.User_id = Convert.ToInt32(item.Emcempid);
employeeObj.First_name = item.Emcfname;
employeeObj.Last_name = item.Emclname;
employeeObj.Middle_name = item.Emcmname;
employeeObj.Created_at = DateTime.Now;
employeeObj.Address1 = item.Emcaddr1;
employeeObj.Address2 = item.Emcaddr2;
employeeObj.City = item.Emccity;
employeeObj.State = item.Emcstate;
employeeObj.ZipCode = item.Emczipcode;
employeeObj.Country = item.Emccountry;
employeeObj.Marital_status = item.Emcmarital;
employeeObj.Gender = item.Emcsex;
//employeeObj.DateOfBirth = Convert.ToDateTime(item.Emtbirth);
//employeeObj.Hire = Convert.ToDateTime(item.Emthire);
//employeeObj.ReHire = Convert.ToDateTime(item.Emtrehire);
employeeObj.EmployeeType = item.Emcemptype;
employeeObj.ENTITY_ADDED_AT = DateTime.Now;
employeeObj.Updated_at = DateTime.Now;
db.Employees.Add(employeeObj);
db.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
ExceptionHandlerController.infoMessage(ex.Message);
ExceptionHandlerController.writeErrorLog(ex);
return(false);
}
}
public bool UpdateCustomers()
{
try
{
TSSWebServiceReference.VFPWebServiceSoapClient srvDBObj = new TSSWebServiceReference.VFPWebServiceSoapClient();
var usersList = srvDBObj.UpdateCustomersData();
var db = new TSS_Sql_Entities();
foreach (var item in usersList)
{
var custCheck = db.Customers.FirstOrDefault(s => s.Customer_id == item.Cuccustid && s.Name == item.Cucname);
if (custCheck == null)
{
var userobj = new TotalStaffingSolutions.Models.Customer();
userobj.Name = item.Cucname;
userobj.Customer_id = item.Cuccustid;
userobj.Address1 = item.Cucaddr1;
userobj.Address2 = item.Cucaddr2;
userobj.City = item.Cuccity;
userobj.State = item.Cucstate;
userobj.CustomerAdded = DateTime.Now;
userobj.ZipCode = item.Cuczipcode;
userobj.Country = item.Cuccountry;
userobj.Created_at = DateTime.Now;
//userobj.PhoneNumber = item.Cucpono;
userobj.Status = item.Cucstatus;
userobj.ENTITY_ADDED_AT = DateTime.Now;
db.Customers.Add(userobj);
db.SaveChanges();
var ponoObj = new Po_Numbers();
ponoObj.ClientId = userobj.Id;
ponoObj.Client_Generic_Id = userobj.Customer_id;
ponoObj.PoNumber = item.Cucpono;
db.Po_Numbers.Add(ponoObj);
db.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
ExceptionHandlerController.infoMessage(ex.Message);
ExceptionHandlerController.writeErrorLog(ex);
return(false);
}
}
public bool UpdateCustomerContacts()
{
try
{
TSSWebServiceReference.VFPWebServiceSoapClient srvDBObj = new TSSWebServiceReference.VFPWebServiceSoapClient();
var contactsList = srvDBObj.UpdateCustomerContacts();
var db = new TSS_Sql_Entities();
foreach (var item in contactsList)
{
var contactCheck = db.CustomerContacts.FirstOrDefault(s => s.Customer_key == item.Ccccusmast && s.Contact_key == item.Ccccuscont);
if (contactCheck == null)
{
var contactObj = new TotalStaffingSolutions.Models.CustomerContact();
contactObj.Contact_code = item.Ccccatcde;
contactObj.Contact_description = item.Ccccontcde;
contactObj.Contact_key = item.Ccccuscont;
contactObj.Contact_name = item.Ccccontact;
contactObj.Contact_notes = item.Ccmnotes;
contactObj.Customer_id = item.Customer_id;
contactObj.Customer_key = item.Ccccusmast;
contactObj.Email_id = item.Cccemail;
contactObj.Phone_1 = item.Cccphone1;
contactObj.Phone_2 = item.Cccphone2;
contactObj.Phone_3 = item.Cccphone3;
contactObj.ENTITY_ADDED_AT = DateTime.Now;
db.CustomerContacts.Add(contactObj);
db.SaveChanges();
if (item.Cccemail != null && item.Cccemail != "")
{
var ConfirmationToken = Membership.GeneratePassword(10, 0);
ConfirmationToken = Regex.Replace(ConfirmationToken, @"[^a-zA-Z0-9]", m => "9");
var savedContactObj = db.CustomerContacts.OrderByDescending(s => s.Id).FirstOrDefault(s => s.Customer_id == contactObj.Customer_id);
var contactStatusObj = new ContactConfirmation();
contactStatusObj.ContactId = savedContactObj.Id;
contactStatusObj.LastUpdate = DateTime.Now;
contactStatusObj.TokenCreationTime = contactStatusObj.LastUpdate;
contactStatusObj.TokenExpiryTime = DateTime.Now.AddHours(24);
contactStatusObj.ConfirmationToken = ConfirmationToken;
contactStatusObj.ConfirmationStatusId = 1;
db.ContactConfirmations.Add(contactStatusObj);
db.SaveChanges();
try
{
var fromAddress = new MailAddress(SenderEmailId, "Total Staffing Solution");
var toAddress = new MailAddress(savedContactObj.Email_id, savedContactObj.Contact_name);
string fromPassword = SenderEmailPassword;
string subject = "Total Staffing Solution: Account Confirmation";
string body = "<b>Hi " + savedContactObj.Contact_name + "!</b><br />Please confirm your email by clicking on following link <br /> <a href='" + TSSLiveSiteURL + "/ClientDashboard/ConfirmAccount?token=" + ConfirmationToken + "'>Confirmation Link</a><br /><small style='text-align:center;'>(This Link is active for next 24 hours, Please make sure to Enable your account before " + DateTime.Now.AddHours(24) + ")</small>";
var smtp = new SmtpClient
{
Host = SenderEmailHost,
Port = SenderEmailPort,
EnableSsl = false,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword),
Timeout = 20000
};
using (var message = new MailMessage(fromAddress, toAddress)
{
IsBodyHtml = true,
Subject = subject,
Body = body,
})
{
smtp.Send(message);
}
///
var savedContactConfirmationObj = db.ContactConfirmations.OrderByDescending(s => s.Id).FirstOrDefault(s => s.ContactId == contactStatusObj.ContactId);
savedContactConfirmationObj.ConfirmationStatusId = 2;
savedContactConfirmationObj.LastUpdate = DateTime.Now;
db.SaveChanges();
}
catch (Exception ex)
{
ExceptionHandlerController.infoMessage(ex.Message);
ExceptionHandlerController.writeErrorLog(ex);
var savedContactConfirmationObj = db.ContactConfirmations.OrderByDescending(s => s.Id).FirstOrDefault(s => s.ContactId == contactStatusObj.ContactId);
savedContactConfirmationObj.ConfirmationStatusId = 4;
savedContactConfirmationObj.LastUpdate = DateTime.Now;
db.SaveChanges();
}
}
}
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
ExceptionHandlerController.infoMessage(ex.Message);
ExceptionHandlerController.writeErrorLog(ex);
return(false);
}
}
