public string SaveOtherTenantFob(long ApplicantId, long TenantID, string Fname, string Lname, string Relationship, string FobKey, int Status, long OtherId) { string msg = string.Empty; ShomaRMEntities db = new ShomaRMEntities(); var saveOtherTenantFob = new tbl_TenantFob() { TenantID = TenantID, FobID = FobKey, ApplicantID = ApplicantId, Status = Status, OtherFirstName = Fname, OtherLastName = Lname, OtherRelationship = Relationship, OtherId = OtherId }; db.tbl_TenantFob.Add(saveOtherTenantFob); db.SaveChanges(); msg = "Saved Successfully"; db.Dispose(); return(msg); }
public string SaveTenantFob(long TenantID, long ApplicantId, int Status, string FobKey, int OtherId) { string msg = string.Empty; ShomaRMEntities db = new ShomaRMEntities(); var updateTenantFob = db.tbl_TenantFob.Where(co => co.ApplicantID == ApplicantId && co.FobID == FobKey).FirstOrDefault(); if (updateTenantFob != null) { var updateTenantFobOther = db.tbl_TenantFob.Where(co => co.ApplicantID == 0 && co.OtherId == OtherId && co.FobID == FobKey).FirstOrDefault(); if (updateTenantFobOther != null) { if (Status == 1) { updateTenantFobOther.Status = 1; msg = "FOB Activated successfully"; } else if (Status == 2) { updateTenantFobOther.Status = 2; msg = "FOB Deactivated successfully"; } db.SaveChanges(); db.Dispose(); return(msg); } else { if (Status == 1) { updateTenantFob.Status = 1; msg = "FOB Activated successfully"; } else if (Status == 2) { updateTenantFob.Status = 2; msg = "FOB Deactivated successfully"; } db.SaveChanges(); db.Dispose(); return(msg); } } else { var saveTenantFob = new tbl_TenantFob() { TenantID = TenantID, FobID = FobKey, ApplicantID = ApplicantId, Status = Status, }; db.tbl_TenantFob.Add(saveTenantFob); db.SaveChanges(); msg = "FOB Activated successfully"; db.Dispose(); return(msg); } }