public ActionResult Transfer(int id)
{
try
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Transfer Fund To Landlord";
OperationRecord model = OperationRecordManager.GetExpenseByRentID(id);
model = OperationRecordManager.GetExpenseByID(model.ID);
model.AllBankAccount = GetSelectListItems((short)Helpers.Helpers.ListType.bankaccount);
model.AllTenant = GetSelectListItems((short)Helpers.Helpers.ListType.allTenantWithUnit);
model.AllCategory = GetSelectListItems((short)Helpers.Helpers.ListType.allExpenseCategory);
model.AllStatus = GetSelectListItems((short)Helpers.Helpers.ListType.allStatus);
return(View(model));
}
catch (Exception ex)
{
LogException(ex.Message);
return(View());
}
}
public ActionResult IncomeDetailReport(string categoryName)
{
DateTime startDate = DateTime.Parse((string)Session["startDate"]);
DateTime endDate = DateTime.Parse((string)Session["endDate"]);
string[] companyIDs = (Session["selectedCompanyIDs"] != null)? (string[])Session["selectedCompanyIDs"]:null;
string[] propertyIDs = (Session["selectedPropertyIDs"] != null) ? (string[])Session["selectedPropertyIDs"] : null;
string[] unitIDs = (Session["selectedUnitIDs"] != null) ? (string[])Session["selectedUnitIDs"] : null;
string[] bankAccountIDs = (Session["selectedAccountIDs"] != null) ? (string[])Session["selectedAccountIDs"] : null;
string[] statusIDs = (Session["selectedStatusIDs"] != null) ? (string[])Session["selectedStatusIDs"] : null;
string[] contractorIDs = (Session["selectedContractorIDs"] != null) ? (string[])Session["selectedContractorIDs"] : null;
string[] categoryIDs = (Session["selectedCategoryIDs"] != null) ? (string[])Session["selectedCategoryIDs"] : null;
List <OperationRecord> result = OperationRecordManager.GetExpense(startDate.ToString(), endDate.ToString(), companyIDs, propertyIDs, unitIDs, bankAccountIDs, statusIDs, contractorIDs, categoryIDs, "", (int)Session["UserID"]);
result = (from r in result
where r.CategoryName == categoryName
select r).ToList();
bool isStartNull = startDate.Equals(DateTime.MinValue);
bool isEndNull = endDate.Equals(DateTime.MinValue);
ViewBag.TableCaption = reporttitle + " Expense: ";
if (!startDate.Equals(DateTime.MinValue))
{
ViewBag.TableCaption += " fromt " + startDate.ToString("g");
}
if (!endDate.Equals(DateTime.MinValue))
{
ViewBag.TableCaption += " thru " + endDate.ToString("g");
}
return(View("IncomeDetailReport", result));
}
public ActionResult Transfer(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
if (String.IsNullOrEmpty(model.TransferedFinancialBankAccountID))
{
return(ExecutionError("Please select either Tenant or Unit"));
}
model.UploadBy = Int32.Parse(Session["UserID"].ToString());
Tenant tenant = TenantManager.GetByID(model.TenantID);
model.ContractorID = tenant.UserID;
model.UnitID = tenant.UnitId;
OperationRecordManager.Reimburse(model);
//send email to end user
if (model.IsEmailReceipt)
{
Email.EmailPayment(model.ID, model.ContractorID, model.UnitID, model.CompleteDate, model.FinancialBankAccountID, model.DueAmount, model.Payment, (int)Helpers.Helpers.EmailType.Invoice);
}
return(RedirectToAction("Index"));
}
public PartialViewResult ReportView(string startDate, string endDate, string[] companyIDs, string[] propertyIDs, string[] unitIDs, string[] bankAccountIDs, string[] statusIDs, string[] contractorIDs, string[] categoryIDs, string expense)
{
Session["startDate"] = startDate;
Session["endDate"] = endDate;
Session["selectedCompanyIDs"] = companyIDs;
Session["selectedPropertyIDs"] = propertyIDs;
Session["selectedUnitIDs"] = unitIDs;
Session["selectedAccountIDs"] = bankAccountIDs;
Session["selectedStatusIDs"] = statusIDs;
Session["selectedContractorIDs"] = contractorIDs;
Session["selectedCategoryIDs"] = categoryIDs;
Session["expenseValue"] = expense;
DateTime start = DateTime.Parse(startDate);
DateTime end = DateTime.Parse(endDate);
List <OperationRecord> result = OperationRecordManager.GetExpense(startDate, endDate, companyIDs, propertyIDs, unitIDs, bankAccountIDs, statusIDs, contractorIDs, categoryIDs, expense, (int)Session["UserID"]);
bool isStartNull = start.Equals(DateTime.MinValue);
bool isEndNull = end.Equals(DateTime.MinValue);
ViewBag.TableCaption = reporttitle + " Expense: ";
if (!start.Equals(DateTime.MinValue))
{
ViewBag.TableCaption += " fromt " + start.ToString("g");
}
if (!end.Equals(DateTime.MinValue))
{
ViewBag.TableCaption += " thru " + end.ToString("g");
}
ViewBag.TotalPayment = 0;
ViewBag.TotalDeposit = 0;
ViewBag.TotalBalace = 0;
return(PartialView("ReportView", result));
}
public ActionResult Delete(int id)
{
// Enable security to redirect to login page if user is not logged in or we are not running in the VS IDE
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
OperationRecordManager.Delete(id);
return(RedirectToAction("Index"));
}
public ActionResult Remind(int id)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
var record = OperationRecordManager.GetExpenseByID(id);
Email.EmailInvoice(record.ID);
return(RedirectToAction("Index"));
}
public ActionResult AddAndTransferFund(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Transfer Fund To Other Bank";
OperationRecordManager.AddAndTransferFund(model);
return(RedirectToAction("Index"));
}
public ActionResult Edit(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Edit Bank Record";
OperationRecordManager.Edit(model);
return(RedirectToAction("Index"));
}
public ActionResult Remind(int id)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
var record = OperationRecordManager.GetExpenseByRentID(id);
Email.EmailReminder(record.ID, record.ContractorID, record.UnitID, record.DueDate, record.DueAmount, (int)Helpers.Helpers.EmailType.RentReminder);
return(RedirectToAction("Index"));
}
public ActionResult Add(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Add new bank record";
int invoiceID = OperationRecordManager.CreateOperationRecord(model);
return(RedirectToAction("Index"));
}
public PartialViewResult DetailTableView(string tableid, string startdate, string enddate, string userID, string companyID)
{
string[] userIds = new string[1];
userIds[0] = userID;
string[] companyIDs = new string[1];
companyIDs[0] = companyID;
List <OperationRecord> result = OperationRecordManager.GetExpense(startdate, enddate, companyIDs, null, null, null, null, userIds, null, "", (int)Session ["UserID"]);
ViewBag.tableid = tableid;
return(PartialView("DetailTableView", result));
}
public ActionResult ReceiveRent(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
model.IsCredit = true;
model.UploadBy = Int32.Parse(Session["UserID"].ToString());
OperationRecordManager.ReceiveRent(model);
//redirect
return(RedirectToAction("Index"));
}
public ActionResult Edit(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Edit Expense";
if (String.IsNullOrEmpty(model.FinancialBankAccountID))
{
model.FinancialBankAccountID = "0";
}
OperationRecordManager.Edit(model);
//send email to end user
return(RedirectToAction("Index"));
}
public ActionResult Reimburse(int id)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Reimburse Expense";
OperationRecord model = OperationRecordManager.GetExpenseByID(id);
model.AllUnits = GetSelectListItems((short)Helpers.Helpers.ListType.unit);
model.AllBankAccount = GetSelectListItems((short)Helpers.Helpers.ListType.bankaccount);
model.AllTenant = GetSelectListItems((short)Helpers.Helpers.ListType.allUser);
model.AllStatus = GetSelectListItems((short)Helpers.Helpers.ListType.allStatus);
model.AllCategory = GetSelectListItems((short)Helpers.Helpers.ListType.allExpenseCategory);
return(View(model));
}
public ActionResult Add(OperationRecord model, string actionName)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Add new supply request";
model.StatusID = 3;
model.UploadBy = (int)Session["UserID"];
model.CategoryID = 18;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["SunriseConnectionString"].ConnectionString);
SqlCommand cmd = sqlConn.CreateCommand();
DataTable dtSearchResult = new DataTable();
SqlDataAdapter daSearchResult = new SqlDataAdapter();
try
{
sqlConn.Open();
if (model.CompleteDate == null)
{
model.CompleteDate = model.DueDate;
}
int invoiceID = 0;
foreach (int unitID in model.SelectedUnitIDs)
{
model.UnitID = unitID;
invoiceID = OperationRecordManager.CreateOperationRecord(model);
}
if (model.IsEmailReceipt)
{
Email.EmailInvoice(invoiceID);
}
}
catch (Exception ex)
{
LogException(ex.Message);
}
finally
{
sqlConn.Close();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
OperationRecord oldOp = OperationRecordManager.GetExpenseByRentID(Int32.Parse(model.LinkedRentID));
ViewBag.ReportTitle = "Edit Rent Record";
model.UploadBy = Int32.Parse(Session["UserID"].ToString());
model.ID = oldOp.ID;
//the tenantid is stored in the contractorid
Tenant tenant = TenantManager.GetByID(model.TenantID);
model.ContractorID = tenant.UserID;
model.UnitID = tenant.UnitId;
OperationRecordManager.EditRent(model);
return(RedirectToAction("Index"));
}
public ActionResult ReceiveRent(int id)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Receive Rent";
OperationRecord model = OperationRecordManager.GetExpenseByRentID(id);
model.CompleteDate = DateTime.Now;
model.UploadBy = Int32.Parse(Session["UserID"].ToString());
model.StatusID = (int)Helpers.Helpers.StatusType.Close;
model.AllUnits = GetSelectListItems((short)Helpers.Helpers.ListType.unit);
model.AllBankAccount = GetSelectListItems((short)Helpers.Helpers.ListType.bankaccount);
model.AllTenant = GetSelectListItems((short)Helpers.Helpers.ListType.allUser);
model.AllStatus = GetSelectListItems((short)Helpers.Helpers.ListType.allStatus);
return(View(model));
}
public ActionResult Edit(int id)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Edit Rent";
var model = OperationRecordManager.GetExpenseByRentID(id);
if (model.CategoryID == (int)Helpers.Helpers.EmailType.SecurityDeposit)
{
model.IsSecurityDeposit = true;
}
//stored the tenant id in the contractorid
model.AllBankAccount = GetSelectListItems((short)Helpers.Helpers.ListType.bankaccount);
model.AllTenant = GetSelectListItems((short)Helpers.Helpers.ListType.allTenantWithUnit);
model.AllStatus = GetSelectListItems((short)Helpers.Helpers.ListType.allStatus);
return(View(model));
}
public ActionResult Add(Tenant model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Add Tenant Record";
SqlConnection sqlConn = new SqlConnection(Helpers.Helpers.GetAppConnectionString());
SqlCommand cmd = sqlConn.CreateCommand();
DataTable dtSearchResult = new DataTable();
SqlDataAdapter daSearchResult = new SqlDataAdapter();
model.StatusID = (int)Helpers.Helpers.StatusType.Open;
try
{
sqlConn.Open();
int DepositStatusID = (int)Helpers.Helpers.StatusType.Open;
if (model.SecurityDeposit == model.PaidSecurityDeposit)
{
DepositStatusID = (int)Helpers.Helpers.StatusType.Close;
}
if (model.SecurityDepositPaidDate == null)
{
model.SecurityDepositPaidDate = DateTime.Now;
}
//add record of the tenant
cmd.CommandText = "INSERT INTO tblTenant (UserID, UnitID, leaseterm,StartDate, monthlypayment,securitydeposit, StatusID, Note) VALUES ( "
+ model.UserID + "," + model.UnitId + "," + model.LeaseTerm + ",'" + model.StartDate.ToShortDateString() + "'," + model.MonthlyPayment + "," + model.SecurityDeposit + "," + model.StatusID + ",'" + model.Note + "'); SELECT SCOPE_IDENTITY();";
int tenantID = int.Parse(cmd.ExecuteScalar().ToString());
//add record of the security deposit payment
cmd.CommandText = "INSERT INTO tblRent (TenantID, RentAmount, PaidAmount, DueDate, IsRent, Note, StatusID, PaymentDate, FinancialAccountID) VALUES ( "
+ tenantID + "," + model.SecurityDeposit + "," + model.PaidSecurityDeposit + ",'" + model.StartDate.ToShortDateString() + "', 0 ,'" + model.Note + "'," + DepositStatusID + ",'" + model.SecurityDepositPaidDate.ToShortDateString() + "'," + model.FinancialBankAccountID + "); SELECT SCOPE_IDENTITY();";
int rentid = int.Parse(cmd.ExecuteScalar().ToString());
OperationRecord operation = new OperationRecord();
operation.StatusID = (short)DepositStatusID;
operation.CategoryID = (int)Helpers.Helpers.ExpenseCategory.SecurityDeposit;
operation.IsCredit = true;
operation.ContractorID = model.UserID;
operation.UnitID = model.UnitId;
operation.DueDate = model.StartDate;
operation.DueAmount = model.SecurityDeposit;
operation.Payment = model.PaidSecurityDeposit;
operation.Memo = model.Note;
operation.LinkedRentID = rentid.ToString();
operation.CompleteDate = model.SecurityDepositPaidDate;
operation.FinancialBankAccountID = model.FinancialBankAccountID;
operation.UploadBy = (int)Session["UserID"];
int opID = OperationRecordManager.CreateOperationRecord(operation);
Email.EmailLease(tenantID, (int)Helpers.Helpers.EmailType.LeaseConfirmation);
sqlConn.Close();
}
catch (SqlException ex)
{
ViewBag.MyExeption = ex.Message;
ViewBag.MyExeptionCSS = "errorMessage";
}
finally
{
sqlConn.Close();
}
return(RedirectToAction("Index"));
}
public ActionResult Add(OperationRecord model, string actionName)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Add Rent";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["SunriseConnectionString"].ConnectionString);
SqlCommand cmd = sqlConn.CreateCommand();
DataTable dtSearchResult = new DataTable();
SqlDataAdapter daSearchResult = new SqlDataAdapter();
try
{
sqlConn.Open();
if (string.IsNullOrEmpty(model.RentMonth))
{
if (model.TenantID <= 0)
{
return(ExecutionError("Please select Tenant"));
}
//the tenant id was stored in the contractorid
Tenant tenant = TenantManager.GetByID(model.TenantID);
int isRent = 1;
if (model.IsSecurityDeposit)
{
model.CategoryID = 32;
isRent = 0;
}
else
{
model.CategoryID = 36;
}
if (!model.IsCredit)
{
model.Payment = -model.Payment;
}
model.StatusID = (int)Helpers.Helpers.StatusType.Open;
if (model.DueAmount == model.Payment || model.DueAmount == 0)
{
model.StatusID = (int)Helpers.Helpers.StatusType.Close;
}
if (model.CompleteDate == null)
{
model.CompleteDate = model.DueDate;
}
model.ContractorID = tenant.UserID;
model.UnitID = tenant.UnitId;
model.LinkedRentID = OperationRecordManager.CreateRent(model, tenant.TenantID).ToString();
model.ID = OperationRecordManager.CreateOperationRecord(model);
if (model.IsEmailReceipt)
{
Email.EmailPayment(model.ID, model.ContractorID, model.UnitID, model.CompleteDate, model.FinancialBankAccountID, model.DueAmount, model.Payment, model.CategoryID);
}
}
sqlConn.Close();
}
catch (SqlException ex)
{
ViewBag.MyExeption = ex.Message;
ViewBag.MyExeptionCSS = "errorMessage";
}
finally
{
sqlConn.Close();
}
return(RedirectToAction("Index"));
}
public ActionResult AddMonthlyRent(OperationRecord model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Account"));
}
ViewBag.ReportTitle = "Add Rent";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["SunriseConnectionString"].ConnectionString);
SqlCommand cmd = sqlConn.CreateCommand();
DataTable dtSearchResult = new DataTable();
SqlDataAdapter daSearchResult = new SqlDataAdapter();
try
{
sqlConn.Open();
//create monthly rents
cmd.CommandText = "Select [tblTenant].UserID, [tblTenant].MonthlyPayment, tblPropertyUnit.UnitID, [tblTenant].TenantID from [tblTenant], tblPropertyUnit, mCompanyProperty WHERE tblTenant.StartDate <'" + DateTime.Now + "' and tblTenant.TerminateDate is null and statusid=1 "
+ " and tblTenant.UnitID = tblPropertyUnit.UnitID and tblPropertyUnit.PropertyID = mCompanyProperty.PropertyID AND tblTenant.StatusID= 1 and mCompanyProperty.CompanyID in " + GetUserManagedCompanyString();
daSearchResult.SelectCommand = cmd;
daSearchResult.Fill(dtSearchResult);
Int16 tenantID = 0;
Int16 userid = 0;
Int16 unitID = 0;
Decimal rentAmount = 0;
//loop through all tenant to create rent record for this month
foreach (DataRow row in dtSearchResult.Rows)
{
if (row[0] != DBNull.Value)
{
userid = Int16.Parse(row[0].ToString());
model.ContractorID = userid;
}
if (row[1] != DBNull.Value)
{
model.DueAmount = Double.Parse(row[1].ToString());
}
if (row[2] != DBNull.Value)
{
model.UnitID = Int16.Parse(row[2].ToString());
}
if (row[3] != DBNull.Value)
{
tenantID = Int16.Parse(row[3].ToString());
}
model.CategoryID = (int)Helpers.Helpers.ExpenseCategory.Rent;
model.Memo = "auto generated rent for " + model.DueDate.ToShortDateString();
model.FinancialBankAccountID = "11";
model.StatusID = (int)Helpers.Helpers.StatusType.Open;
model.LinkedRentID = OperationRecordManager.CreateRent(model, tenantID).ToString();
OperationRecordManager.CreateOperationRecord(model);
}
sqlConn.Close();
}
catch (SqlException ex)
{
ViewBag.MyExeption = ex.Message;
ViewBag.MyExeptionCSS = "errorMessage";
}
finally
{
sqlConn.Close();
}
return(RedirectToAction("Index"));
}
