public LeaseManagementModel GetLeaseInformation(int id)
{
ShomaRMEntities db = new ShomaRMEntities();
LeaseManagementModel model = new LeaseManagementModel();
if (id != 0)
{
var getLeaseInfo = db.tbl_Lease.Where(p => p.TenantID == id).FirstOrDefault();
if (getLeaseInfo != null)
{
model.LID = getLeaseInfo.LID;
model.PID = getLeaseInfo.PID.HasValue?getLeaseInfo.PID.Value:0;
model.UID = getLeaseInfo.UID.HasValue ? getLeaseInfo.UID.Value : 0;
model.TID = getLeaseInfo.TenantID;
model.Revision_Num = getLeaseInfo.Revision_Num;
model.Status = getLeaseInfo.Status;
model.Being_Terminated = getLeaseInfo.Being_Terminated;
model.Phase = getLeaseInfo.Phase;
model.Notice_Date = getLeaseInfo.Notice_Date;
model.Termination_Reason = getLeaseInfo.Termination_Reason;
model.Balance = getLeaseInfo.Balance;
model.Previous_Balance = getLeaseInfo.Previous_Balance;
model.Returned_Check_Limit = getLeaseInfo.Returned_Check_Limit;
model.Number_Returned_Checks = getLeaseInfo.Number_Returned_Checks;
model.Last_Return_Ck_Date = getLeaseInfo.Last_Return_Ck_Date;
model.Last_Return_Pmt_ID = getLeaseInfo.Last_Return_Pmt_ID;
model.Last_Return_Ck_Num = getLeaseInfo.Last_Return_Ck_Num;
model.Original_Start = getLeaseInfo.Original_Start;
model.Actual_Start = getLeaseInfo.Actual_Start;
model.Original_Lease_End = getLeaseInfo.Original_Lease_End;
model.Actual_Lease_End = getLeaseInfo.Actual_Lease_End;
model.Intended_MoveIn_Date = getLeaseInfo.Intended_MoveIn_Date;
model.Actual_MoveIn_Date = getLeaseInfo.Actual_MoveIn_Date;
model.Intend_MoveOut_Date = getLeaseInfo.Intend_MoveOut_Date;
model.Actual_MoveOut_Date = getLeaseInfo.Actual_MoveOut_Date;
model.Statement_Type = getLeaseInfo.Statement_Type;
model.Last_Rent_Roll_Date = getLeaseInfo.Last_Rent_Roll_Date;
model.CreatedBy = getLeaseInfo.CreatedBy;
model.CreatedDate = getLeaseInfo.CreatedDate;
model.Reconciled = getLeaseInfo.Reconciled;
model.Term = getLeaseInfo.Term;
}
}
return(model);
}
public string SaveUpdateLease(LeaseManagementModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
string msg = "";
if (model.LID == 0)
{
var saveLease = new tbl_Lease()
{
LID = model.LID,
PID = model.PID,
UID = model.UID,
Revision_Num = model.Revision_Num,
Status = model.Status,
Being_Terminated = model.Being_Terminated,
Phase = model.Phase,
Notice_Date = model.Notice_Date,
Termination_Reason = model.Termination_Reason,
Balance = model.Balance,
Previous_Balance = model.Previous_Balance,
Returned_Check_Limit = model.Returned_Check_Limit,
Number_Returned_Checks = model.Number_Returned_Checks,
Last_Return_Ck_Date = model.Last_Return_Ck_Date,
Last_Return_Pmt_ID = model.Last_Return_Pmt_ID,
Last_Return_Ck_Num = model.Last_Return_Ck_Num,
Original_Start = model.Original_Start,
Actual_Start = model.Actual_Start,
Original_Lease_End = model.Original_Lease_End,
Actual_Lease_End = model.Actual_Lease_End,
Intended_MoveIn_Date = model.Intended_MoveIn_Date,
Actual_MoveIn_Date = model.Actual_MoveIn_Date,
Intend_MoveOut_Date = model.Intend_MoveOut_Date,
Actual_MoveOut_Date = model.Actual_MoveOut_Date,
Statement_Type = model.Statement_Type,
Last_Rent_Roll_Date = model.Last_Rent_Roll_Date,
CreatedBy = model.CreatedBy,
CreatedDate = model.CreatedDate,
Reconciled = model.Reconciled,
Term = model.Term,
};
db.tbl_Lease.Add(saveLease);
db.SaveChanges();
msg = "Lease Information Saved Successfully";
}
else
{
var getLIdata = db.tbl_Lease.Where(p => p.LID == model.LID).FirstOrDefault();
if (getLIdata != null)
{
getLIdata.LID = model.LID;
getLIdata.PID = model.PID;
getLIdata.UID = model.UID;
getLIdata.Revision_Num = model.Revision_Num;
getLIdata.Status = model.Status;
getLIdata.Being_Terminated = model.Being_Terminated;
getLIdata.Phase = model.Phase;
getLIdata.Notice_Date = model.Notice_Date;
getLIdata.Termination_Reason = model.Termination_Reason;
getLIdata.Balance = model.Balance;
getLIdata.Previous_Balance = model.Previous_Balance;
getLIdata.Returned_Check_Limit = model.Returned_Check_Limit;
getLIdata.Number_Returned_Checks = model.Number_Returned_Checks;
getLIdata.Last_Return_Ck_Date = model.Last_Return_Ck_Date;
getLIdata.Last_Return_Pmt_ID = model.Last_Return_Pmt_ID;
getLIdata.Last_Return_Ck_Num = model.Last_Return_Ck_Num;
getLIdata.Original_Start = model.Original_Start;
getLIdata.Actual_Start = model.Actual_Start;
getLIdata.Original_Lease_End = model.Original_Lease_End;
getLIdata.Actual_Lease_End = model.Actual_Lease_End;
getLIdata.Intended_MoveIn_Date = model.Intended_MoveIn_Date;
getLIdata.Actual_MoveIn_Date = model.Actual_MoveIn_Date;
getLIdata.Intend_MoveOut_Date = model.Intend_MoveOut_Date;
getLIdata.Actual_MoveOut_Date = model.Actual_MoveOut_Date;
getLIdata.Statement_Type = model.Statement_Type;
getLIdata.Last_Rent_Roll_Date = model.Last_Rent_Roll_Date;
getLIdata.CreatedBy = model.CreatedBy;
getLIdata.CreatedDate = model.CreatedDate;
getLIdata.Reconciled = model.Reconciled;
getLIdata.Term = model.Term;
}
db.SaveChanges();
msg = "Lease Information Updated Successfully";
}
db.Dispose();
return(msg);
}
