public IEnumerable <Complaint> GetComplaintDetailsByEmployee(int employeeID)
{
List <Complaint> _complaintItems = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "employeeID", value: employeeID) };
DataSet dsComplaintDetails = dbCon.ExecuteReader("BE_Get_ComplaintDetailsByEmployee", sqlParams);
if (dsComplaintDetails != null && dsComplaintDetails.Tables.Count > 0 && dsComplaintDetails.Tables[0].Rows.Count > 0)
{
_complaintItems = new List <Complaint>();
Complaint _complaint = null;
foreach (DataRow drComplaint in dsComplaintDetails.Tables[0].Rows)
{
_complaint = new Complaint();
_complaint.ComplaintID = Convert.ToInt32(drComplaint["ComplaintID"]);
_complaint.TenantID = Convert.ToInt32(drComplaint["TenantID"]);
_complaint.TenantDetails = new Tenant();
_complaint.TenantDetails.TenantID = Convert.ToInt32(drComplaint["TenantID"]);
_complaint.TenantDetails.TenantName = Convert.ToString(drComplaint["TenantName"]);
_complaint.TenantDetails.RoomNumber = Convert.ToString(drComplaint["RoomNo"]);
_complaint.BranchDetails.BranchID = Convert.ToInt32(drComplaint["BranchID"]);
_complaint.BranchDetails.BranchName = Convert.ToString(drComplaint["BranchName"]);
_complaint.ComplaintDescription = Convert.ToString(drComplaint["ComplaintDescription"]);
_complaint.ComplaintRaisedDate = Convert.ToDateTime(drComplaint["ComplaintRaisedDate"]);
_complaint.ComplaintStatus = Convert.ToString(drComplaint["ComplaintStatus"]);
_complaint.ComplaintLastModifiedDate = Convert.ToDateTime(drComplaint["ComplaintLastModifiedDate"]);
_complaintItems.Add(_complaint);
}
}
}
return(_complaintItems);
}
public IEnumerable <Branch> GetBranchDetailsByEmployee(int EmployeeID)
{
List <Branch> _branchDetails = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "EmployeeID", value: EmployeeID) };
DataSet dsBranchDetails = dbCon.ExecuteReader("BE_Get_BranchDetailsbyEmployee", sqlParams);
if (dsBranchDetails != null && dsBranchDetails.Tables.Count > 0 && dsBranchDetails.Tables[0].Rows.Count > 0)
{
_branchDetails = new List <Branch>();
Branch _branch = null;
foreach (DataRow drBranch in dsBranchDetails.Tables[0].Rows)
{
_branch = new Branch();
_branch.BranchID = Convert.ToInt32(drBranch["BranchID"]);
_branch.BranchName = Convert.ToString(drBranch["BranchName"]);
_branch.City = Convert.ToString(drBranch["City"]);
_branch.BranchAddress = Convert.ToString(drBranch["BranchAddress"]);
_branch.EmailAddress = Convert.ToString(drBranch["EmailAddress"]);
_branch.Gender = Convert.ToString(drBranch["Gender"]);
_branch.PhoneNumber = Convert.ToString(drBranch["PhoneNumber"]);
_branch.BranchStatus = Convert.ToString(drBranch["BranchStatus"]);
_branchDetails.Add(_branch);
}
}
}
return(_branchDetails);
}
public Employee GetEmployeeDetails(int EmployeeID)
{
Employee _employeeDetails = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "EmployeeID", value: EmployeeID) };
DataSet dsUserDetails = dbCon.ExecuteReader("BE_Get_EmployeeDetailsbyID", sqlParams);
if (dsUserDetails != null && dsUserDetails.Tables.Count > 0 && dsUserDetails.Tables[0].Rows.Count > 0)
{
_employeeDetails = new Employee();
_employeeDetails.EmployeeID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["EmployeeID"]);
_employeeDetails.EmployeeName = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["EmployeeName"]);
_employeeDetails.EmployeeEmail = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["EmployeeEmail"]);
_employeeDetails.EmployeePhoneNumber = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["EmployeePhoneNumber"]);
if (dsUserDetails.Tables[0].Rows[0]["EmployeeDOB"] != DBNull.Value)
{
_employeeDetails.EmployeeDOB = Convert.ToDateTime(dsUserDetails.Tables[0].Rows[0]["EmployeeDOB"]);
}
_employeeDetails.EmployeeSalary = Convert.ToDouble(dsUserDetails.Tables[0].Rows[0]["EmployeeSalary"]);
_employeeDetails.EmployeeStatus = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["EmployeeStatus"]);
_employeeDetails.LoginPassword = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["LoginPassword"]);
_employeeDetails.BranchDetails.BranchID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["BranchID"]);
_employeeDetails.BranchDetails.City = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["City"]);
_employeeDetails.BranchDetails.BranchName = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["BranchName"]);
_employeeDetails.BranchDetails.BranchAddress = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["BranchAddress"]);
_employeeDetails.BranchDetails.PhoneNumber = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["PhoneNumber"]);
_employeeDetails.BranchDetails.EmailAddress = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["EmailAddress"]);
_employeeDetails.BranchDetails.Gender = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["Gender"]);
_employeeDetails.BranchDetails.BranchStatus = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["BranchStatus"]);
}
}
return(_employeeDetails);
}
public IEnumerable <Receipt> GetReceiptDetails(int tenantID)
{
List <Receipt> _receiptItems = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "TenantID", value: tenantID) };
DataSet dsReceiptDetails = dbCon.ExecuteReader("BE_Get_RentReceiptDetails", sqlParams);
if (dsReceiptDetails != null && dsReceiptDetails.Tables.Count > 0 && dsReceiptDetails.Tables[0].Rows.Count > 0)
{
_receiptItems = new List <Receipt>();
Receipt _receipt = null;
foreach (DataRow drReceipt in dsReceiptDetails.Tables[0].Rows)
{
_receipt = new Receipt();
_receipt.PaymentID = Convert.ToInt32(drReceipt["PaymentID"]);
_receipt.Month = Convert.ToString(drReceipt["MonthofPayment"]);
_receipt.ReceiptType = Convert.ToString(drReceipt["PaymentPurpose"]);
_receipt.DownloadLink = Convert.ToString(drReceipt["ReceiptName"]);
_receiptItems.Add(_receipt);
}
}
}
return(_receiptItems);
}
public void UpdateTenantExitDate(Tenant _tenant)
{
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "TenantID", value: _tenant.TenantID)
, new SqlParameter(parameterName: "DateofExit", value: _tenant.DOE) };
dbCon.ExecuteReader("BE_Update_TenantExitDatebyID", sqlParams);
}
}
public void UpdateEmployeeDetails(Employee _employee)
{
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "EmployeeID", value: _employee.EmployeeID)
, new SqlParameter(parameterName: "EmployeeName", value: _employee.EmployeeName)
, new SqlParameter(parameterName: "EmployeeEmail", value: _employee.EmployeeEmail)
, new SqlParameter(parameterName: "EmployeePhoneNumber", value: _employee.EmployeePhoneNumber)
, new SqlParameter(parameterName: "LoginPassword", value: _employee.LoginPassword) };
dbCon.ExecuteReader("BE_Update_EmployeeDetailsbyID", sqlParams);
}
}
public void UpdateTenantDetails(Tenant _tenant)
{
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "TenantID", value: _tenant.TenantID)
, new SqlParameter(parameterName: "TenantName", value: _tenant.Name)
, new SqlParameter(parameterName: "TenantEmail", value: _tenant.Email)
, new SqlParameter(parameterName: "TenantPhoneNumber", value: _tenant.PhoneNo)
, new SqlParameter(parameterName: "LoginPassword", value: _tenant.LoginPassword) };
dbCon.ExecuteReader("BE_Update_TenantDetailsbyID", sqlParams);
}
}
public Tenant GetTenantDetails(int TenantID)
{
Tenant _tenantDetails = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "TenantID", value: TenantID) };
DataSet dsTenantDetails = dbCon.ExecuteReader("BE_Get_TenantDetailsbyID", sqlParams);
if (dsTenantDetails != null && dsTenantDetails.Tables.Count > 0 && dsTenantDetails.Tables[0].Rows.Count > 0)
{
_tenantDetails = new Tenant();
_tenantDetails.TenantID = Convert.ToInt32(dsTenantDetails.Tables[0].Rows[0]["TenantID"]);
_tenantDetails.TenantName = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantName"]);
_tenantDetails.BranchDetails.BranchID = Convert.ToInt32(dsTenantDetails.Tables[0].Rows[0]["BranchID"]);
_tenantDetails.BranchDetails.City = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["City"]);
_tenantDetails.BranchDetails.BranchName = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["BranchName"]);
_tenantDetails.BranchDetails.BranchAddress = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["BranchAddress"]);
_tenantDetails.BranchDetails.PhoneNumber = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["PhoneNumber"]);
_tenantDetails.BranchDetails.EmailAddress = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["EmailAddress"]);
_tenantDetails.BranchDetails.Gender = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["Gender"]);
_tenantDetails.BranchDetails.BranchStatus = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["BranchStatus"]);
_tenantDetails.RoomNumber = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["RoomNo"]);
if (dsTenantDetails.Tables[0].Rows[0]["TenantDOB"] != DBNull.Value)
{
_tenantDetails.DOB = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["TenantDOB"]);
}
if (dsTenantDetails.Tables[0].Rows[0]["DateofJoin"] != DBNull.Value)
{
_tenantDetails.DOJ = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["DateofJoin"]);
}
if (dsTenantDetails.Tables[0].Rows[0]["DateofExit"] != DBNull.Value)
{
_tenantDetails.DOE = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["DateofExit"]).ToString("yyyy-MM-dd");
}
_tenantDetails.PaymentDate = Convert.ToDateTime(dsTenantDetails.Tables[0].Rows[0]["PaymentDate"]);
_tenantDetails.MonthofPayment = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["PaymentMonth"]);
_tenantDetails.MonthlyRent = Convert.ToDouble(dsTenantDetails.Tables[0].Rows[0]["Rent"]);
_tenantDetails.Name = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantName"]);
_tenantDetails.LoginPassword = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["LoginPassword"]);
_tenantDetails.Email = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantEmail"]);
_tenantDetails.PhoneNo = Convert.ToString(dsTenantDetails.Tables[0].Rows[0]["TenantPhoneNumber"]);
}
}
return(_tenantDetails);
}
public IEnumerable <MenuItem> GetMenuByDesignation(int designationID)
{
List <MenuItem> _menuItems = null;
using (DBConnection dbcon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "DesignationID"
, value: designationID) };
DataSet dsMenuDetails = dbcon.ExecuteReader("BE_Get_MenuAccessByDesignation", sqlParams);
if (dsMenuDetails != null && dsMenuDetails.Tables.Count > 0 && dsMenuDetails.Tables[0].Rows.Count > 0)
{
_menuItems = (from row in dsMenuDetails.Tables[0].AsEnumerable()
select new MenuItem
{
MenuID = row.Field <int>("MenuID"),
MenuName = row.Field <string>("MenuName"),
MenuImage = row.Field <string>("MenuImage"),
MenuStatus = row.Field <string>("MenuStatus"),
URL = row.Field <string>("URL"),
}).ToList();
}
}
return(_menuItems);
}
public User GetUserDetails(string userName, string password)
{
User _userDetails = null;
using (DBConnection dbCon = new Data.DBConnection())
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter(parameterName: "UserName", value: userName),
//new SqlParameter(parameterName:"Password",value:Encrypt.DecryptString(password)) };
new SqlParameter(parameterName: "Password", value: password) };
DataSet dsUserDetails = dbCon.ExecuteReader("BE_Get_LoginUserDetails", sqlParams);
if (dsUserDetails != null && dsUserDetails.Tables.Count > 0 && dsUserDetails.Tables[0].Rows.Count > 0)
{
_userDetails = new User();
_userDetails.ID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["ID"]);
_userDetails.LoginName = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["LoginName"]);
_userDetails.TenantID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["TenantID"]);
_userDetails.EmployeeID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["EmployeeID"]);
_userDetails.DesignationID = Convert.ToInt32(dsUserDetails.Tables[0].Rows[0]["DesignationID"]);
_userDetails.Designation = Convert.ToString(dsUserDetails.Tables[0].Rows[0]["DesignationName"]);
}
}
return(_userDetails);
}
