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);
}
}
