public string UpdateWorkInfo(MyAccountModel model, long UserID) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.JobTitle = model.JobTitle; tblTenant.JobType = Convert.ToInt32(model.JobType); tblTenant.EmployerName = model.EmployerName; db.SaveChanges(); } var getTenatId = db.tbl_ApplyNow.Where(co => co.UserId == UserID).FirstOrDefault(); var tblTInfo = db.tbl_TenantInfo.Where(p => p.ProspectID == getTenatId.ID).FirstOrDefault(); var tblTenantOnline = db.tbl_TenantOnline.Where(p => p.ProspectID == tblTInfo.ProspectID).FirstOrDefault(); if (tblTenantOnline != null) { tbl_TenantOnline objTable = new tbl_TenantOnline(); tblTenantOnline.JobTitle = model.JobTitle; tblTenantOnline.JobType = Convert.ToInt32(model.JobType); tblTenantOnline.EmployerName = model.EmployerName; db.SaveChanges(); } db.Dispose(); return(msg); }
public string UpdateContactInfo(MyAccountModel model, long UserId) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.FirstName = model.FirstName; tblTenant.LastName = model.LastName; tblTenant.MiddleInitial = model.MiddleInitial; tblTenant.Mobile = model.Mobile; tblTenant.Email = model.Email; db.SaveChanges(); var applyNow = db.tbl_ApplyNow.Where(p => p.UserId == UserId).FirstOrDefault(); if (applyNow != null) { applyNow.FirstName = model.FirstName; applyNow.LastName = model.LastName; applyNow.Phone = model.Mobile; applyNow.Email = model.Email; } db.SaveChanges(); var loginDet = db.tbl_Login.Where(p => p.UserID == UserId).FirstOrDefault(); if (loginDet != null) { loginDet.FirstName = model.FirstName; loginDet.LastName = model.LastName; loginDet.Email = model.Email; loginDet.Username = model.Email; } db.SaveChanges(); var tenantOnline = db.tbl_TenantOnline.Where(p => p.ProspectID == tblTenant.ProspectID).FirstOrDefault(); if (tenantOnline != null) { tenantOnline.FirstName = model.FirstName; tenantOnline.LastName = model.LastName; tenantOnline.MiddleInitial = model.MiddleInitial; tenantOnline.Mobile = model.Mobile; tenantOnline.Email = model.Email; } db.SaveChanges(); } db.Dispose(); return(msg); }
public string UpdateEmContactInfo(MyAccountModel model, long UserId) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.EmergencyFirstName = model.EmFirstNane; tblTenant.EmergencyLastName = model.EmLastName; tblTenant.EmergencyMobile = model.EmMobile; tblTenant.EmergencyWorkPhone = model.EmWorkPhone; tblTenant.EmergencyHomePhone = model.EmHomePhone; tblTenant.EmergencyAddress1 = model.EmAddress1; tblTenant.EmergencyAddress2 = model.EmAddress2; tblTenant.EmergencyEmail = model.EmEmail; tblTenant.Relationship = model.EmRelation; db.SaveChanges(); } var getTenatId = db.tbl_ApplyNow.Where(co => co.UserId == UserId).FirstOrDefault(); var tblTInfo = db.tbl_TenantInfo.Where(p => p.ProspectID == getTenatId.ID).FirstOrDefault(); var tblTenantOnline = db.tbl_TenantOnline.Where(p => p.ProspectID == tblTInfo.ProspectID).FirstOrDefault(); if (tblTenantOnline != null) { tbl_TenantOnline objTable = new tbl_TenantOnline(); tblTenantOnline.EmergencyFirstName = model.EmFirstNane; tblTenantOnline.EmergencyLastName = model.EmLastName; tblTenantOnline.EmergencyMobile = model.EmMobile; tblTenantOnline.EmergencyWorkPhone = model.EmWorkPhone; tblTenantOnline.EmergencyHomePhone = model.EmHomePhone; tblTenantOnline.EmergencyAddress1 = model.EmAddress1; tblTenantOnline.EmergencyAddress2 = model.EmAddress2; tblTenantOnline.EmergencyEmail = model.EmEmail; tblTenantOnline.Relationship = model.EmRelation; db.SaveChanges(); } db.Dispose(); return(msg); }
public string SaveProfilePic(MyAccountModel model) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); var tblTenant = db.tbl_TenantInfo.Where(p => p.TenantID == model.ID).FirstOrDefault(); if (tblTenant != null) { tbl_TenantInfo objTable = new tbl_TenantInfo(); tblTenant.TenantID = model.ID; tblTenant.ProfilePicture = model.TempProfilePic; tblTenant.OrginalProfilePicture = model.OriginalProfileFile; db.SaveChanges(); } db.Dispose(); return(msg); }