/// <summary>
/// Get Module Status
/// </summary>
/// <returns></returns>
public IEnumerable <ModuleMaster> getModuleStatus()
{
RepositoryService <ModuleMaster> objModuleMaster = new RepositoryService <ModuleMaster>(_vContext);
//obj.SelectAll();
return(objModuleMaster.SelectAll());
}
/// <summary>
/// Checking if super admin exist by email
/// and password
/// </summary>
/// <param name="email"></param>
/// <param name="isDelete"></param>
/// <returns></returns>
public FinocartMaster CheckSuperAdmin(string email, string password)
{
RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext);
FinocartMaster finocartMaster = objFinocartMaster.SelectAll().Where(x => x.EmailId == email && x.Password == password).FirstOrDefault();
return(finocartMaster);
}
/// <summary>
/// Getting user list
/// </summary>
/// <returns></returns>
public IEnumerable <User> GetUserList()
{
RepositoryService <User> objUser = new RepositoryService <User>(_vContext);
//obj.SelectAll();
return(objUser.SelectAll());
}
/// <summary>
/// Check Super Admin Old Password
/// </summary>
/// <returns></returns>
public IEnumerable <FinocartMaster> CheckSuperAdminPassword()
{
RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext);
//obj.SelectAll();
return(objFinocartMaster.SelectAll());
}
/// <summary>
/// Checking if user exist by email
/// </summary>
/// <param name="email"></param>
/// <param name="isDelete"></param>
/// <returns></returns>
public User CheckUserByEmail(string email, bool isDelete)
{
RepositoryService <User> objUser = new RepositoryService <User>(_vContext);
User user = objUser.SelectAll().Where(x => x.Email == email && x.IsDelete == isDelete).FirstOrDefault();
return(user);
}
/// <summary>
/// Checking if Admin exist by email
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public Company CheckAdminByEmailExists(string email)
{
RepositoryService <Company> objCompany = new RepositoryService <Company>(_vContext);
Company company = objCompany.SelectAll().Where(x => x.Contact_email == email).FirstOrDefault();
return(company);
}
/// <summary>
/// Checking if Admin exist by email
/// and password
/// </summary>
/// <param name="email"></param>
/// <param name="isDelete"></param>
/// <returns></returns>
public Company CheckAdmin(string email, string password)
{
RepositoryService <Company> objCompany = new RepositoryService <Company>(_vContext);
Company company = objCompany.SelectAll().Where(x => x.Pan_number == email && x.Password == password).FirstOrDefault();
return(company);
}
/// <summary>
/// Checking if Admin exist by email
/// </summary>
/// <param name="email"></param>
/// <param name="isDelete"></param>
/// <returns></returns>
public Company CheckAdminByEmail(string email, bool isDelete)
{
RepositoryService <Company> objCompany = new RepositoryService <Company>(_vContext);
Company company = objCompany.SelectAll().Where(x => x.Contact_email == email && x.IsDelete == isDelete).FirstOrDefault();
return(company);
}
/// <summary>
/// Check Admin Old Password
/// </summary>
/// <returns></returns>
public IEnumerable <Company> CheckAdminPassword()
{
RepositoryService <Company> objCompany = new RepositoryService <Company>(_vContext);
//obj.SelectAll();
return(objCompany.SelectAll());
}
/// <summary>
/// checking if user exist by email
/// and password
/// </summary>
/// <param name="email"></param>
/// <param name="password"></param>
/// <returns></returns>
public User CheckUser(string email, string password)
{
RepositoryService <User> objUser = new RepositoryService <User>(_vContext);
User user = objUser.SelectAll().Where(x => x.Email == email && x.Password == password).FirstOrDefault();
return(user);
}
/// <summary>
/// Get user list for dropdown
/// </summary>
/// <returns></returns>
public IEnumerable <User> GetUserList()
{
RepositoryService <User> objUser = new RepositoryService <User>(_vContext);
IEnumerable <User> lstUsers = objUser.SelectAll();
return(lstUsers);
}
/// <summary>
/// Checking if super admin exist by email
/// </summary>
/// <param name="email"></param>
/// <param name="isDelete"></param>
/// <returns></returns>
public FinocartMaster CheckSuperAdminByEmail(string email, bool isDelete)
{
RepositoryService <FinocartMaster> objFinocartMaster = new RepositoryService <FinocartMaster>(_vContext);
FinocartMaster finocartMaster = objFinocartMaster.SelectAll().Where(x => x.EmailId == email && x.IsDelete == isDelete).FirstOrDefault();
return(finocartMaster);
}
/// <summary>
/// Get record of last searched keys
/// </summary>
/// <returns></returns>
public IEnumerable <SearchHistory> GetSearchHistories()
{
try
{
RepositoryService <SearchHistory> objSearchHistory = new RepositoryService <SearchHistory>(_vContext);
var data = objSearchHistory.SelectAll();
IEnumerable <SearchHistory> lstsearchHistories = data.ToList();
return(lstsearchHistories);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get role access list
/// </summary>
/// <returns></returns>
public IEnumerable <RolesAccessMaster> GetRoleAccessList()
{
RepositoryService <RolesAccessMaster> objRolesAccessMaster = new RepositoryService <RolesAccessMaster>(_vContext);
var Data = objRolesAccessMaster.SelectAll();
List <RolesAccessMaster> RolesAccessDropDownList = (from a in Data.AsEnumerable()
select new RolesAccessMaster
{
RoleAccessID = a.RoleAccessID,
Permission = a.Permission
}).ToList();
IEnumerable <RolesAccessMaster> lstRoleAccess = Data.ToList();
return(lstRoleAccess);
}
//public bool uploadFiletoServer(IConfiguration _configuration) //string strFiles, IFormFile fromFile)
//{
// try
// {
// // First way
// //string conectionString = _configuration.GetSection("ConnectionStrings").GetSection("EmployeeDatabase").Value;
// string aalowExtension = _configuration.GetSection("Extension").GetSection("AllowFileExtension").Value;
// string preventExtension = _configuration.GetSection("Extension").GetSection("PreventFileExtension").Value;
// // Second way
// //string value2 = _configuration.GetValue<string>("Data:ConnectionString");
// string VendorDocumentsFolder = _configuration["VendorDocumentsFolder"];
// string AnchorDocumentsFolder = _configuration["AnchorDocumentsFolder"];
// }
// catch (Exception)
// {
// //throw
// }
// return false;
//}
#endregion
/// <summary>
/// Check User Old Password
/// </summary>
/// <returns></returns>
public IEnumerable <User> CheckUserPassword()
{
RepositoryService <User> objUser = new RepositoryService <User>(_vContext);
return(objUser.SelectAll());
}
/// <summary>
/// check from amount and to amount duplication
/// </summary>
/// <returns></returns>
public IEnumerable <InvoiceApprovalOrder> CheckAmountDuplicate(decimal fromAmount, decimal toAmount)
{
RepositoryService <InvoiceApprovalOrder> objInvoiceApprovalOrder = new RepositoryService <InvoiceApprovalOrder>(_vContext);
return(objInvoiceApprovalOrder.SelectAll().Where(x => x.FromAmount == fromAmount && x.ToAmount == toAmount).ToList());
}
/// <summary>
/// Getting list of employees
/// </summary>
/// <returns></returns>
public IEnumerable <Employee> getEmployees()
{
RepositoryService <Employee> objEmployee = new RepositoryService <Employee>(_vContext);
return(objEmployee.SelectAll());
}