public int CheckUser_ForgotPassword_URL(string Id)
{
int query = 0;
try
{
using (var db = new WebPortalEntities())
{
var data = db.CheckForgotPasswordURL(Convert.ToInt32(Id));
if (data.Count() > 0)
{
query = 1;
}
else
{
query = 0;
}
}
}
catch (Exception ex)
{
query = 0;
logger.Error("EndUserRepository_CheckUser_ForgotPassword_URL Error: ", ex);
}
return(query);
}
public int Delete(CustomerAddress_VM Model)
{
int result = 0;
using (var db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
result = db.DeleteCustomerAddress(Model.CustomerID, Model.AddressType, Model.CurrentLanguageCode, Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint);
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
logger.Error("CustomerAddressRepository_Delete Error: ", ex);
trans.Rollback();
throw;
}
}
}
return(result);
}
/// <summary>
/// Update File Info
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public FolderFile_VM UpdateFileInfo(FolderFile_VM Model)
{
using (WebPortalEntities db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
ObjectParameter pTxnTimestamp = new ObjectParameter("pTxnTimestamp", Model.TxnTimestamp);
db.UpdateFileInfo(Model.FileID, Model.FileRemarks, pTxnTimestamp);
db.SaveChanges();
trans.Commit();
Model.TxnTimestamp = (byte[])pTxnTimestamp.Value;
return(Model);
}
catch (Exception ex)
{
trans.Rollback();
logger.Error("FileSystem_UpdateFileInfo Error: ", ex);
throw;
}
}
}
}
/// <summary>
/// Get Deleted Files Info
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public List <FolderFile_VM> GetDeletedFilesInfo(FolderFile_VM Model)
{
List <FolderFile_VM> model = new List <FolderFile_VM>();
using (WebPortalEntities db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <GetDeletedFilesInfo_Result, FolderFile_VM>());
var mapper = config.CreateMapper();
List <GetDeletedFilesInfo_Result> data = db.GetDeletedFilesInfo(Model.FileName, Model.FileType, Model.FileRemarks).ToList();
mapper.Map <List <GetDeletedFilesInfo_Result>, List <FolderFile_VM> >(data, model);
trans.Commit();
return(model);
}
catch (Exception ex)
{
trans.Rollback();
logger.Error("FileSystem_GetDeletedFilesInfo Error: ", ex);
throw;
}
}
}
}
public List <ScreenAccess_VM> GetScreen(ScreenAccess_VM VM)
{
List <ScreenAccess_VM> query = new List <ScreenAccess_VM>();
using (var db = new WebPortalEntities())
{
query = db.Database.SqlQuery <ScreenAccess_VM>("exec GetScreen", new SqlParameter[] { }).ToList();
}
return(query);
}
public List <CustomerContact_VM> GetData(CustomerContact_VM Model)
{
List <CustomerContact_VM> query = new List <CustomerContact_VM>();
try
{
using (var db = new WebPortalEntities())
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <GetCustomerContact_Result, CustomerContact_VM>());
var mapper = config.CreateMapper();
List <GetCustomerContact_Result> data = db.GetCustomerContact(Model.CustomerID, Model.ContactName,
Model.Email, Model.Telephone, Model.Mobile, Model.IsPrimaryContact, Model.CurrentLanguageCode,
Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint).ToList();
mapper.Map <List <GetCustomerContact_Result>, List <CustomerContact_VM> >(data, query);
}
if (query.Count > 0)
{
if (query[0].UserID != null && Model.IsChildResult == true)
{
var customerContact = query[0];
UserRepository user_ = new UserRepository();
var CustomerContactUser = user_.GetData(new EndUser_VM()
{
EndUserID = customerContact.UserID, IsChildResult = true, IsCustomerUser = true
});
if (CustomerContactUser.Count > 0)
{
var _CustomerContactUser = CustomerContactUser[0];
customerContact.IsWebAccess = true;
customerContact.LanguageCode = _CustomerContactUser.LanguageCode;
customerContact.Gender = _CustomerContactUser.Gender;
customerContact.UTCOffset = _CustomerContactUser.UTCOffset;
customerContact.DefaultModuleCode = _CustomerContactUser.DefaultModuleCode;
customerContact.EndUserModuleList = _CustomerContactUser.EndUserModuleList;
customerContact.UserRoleUserList = _CustomerContactUser.UserRoleUserList;
}
}
}
}
catch (Exception ex)
{
logger.Error("CustomerContactRepository_GetData Error: ", ex);
throw;
}
return(query);
}
private List <UserRole_VM> ConnectGetDataProcedure(UserRole_VM VM)
{
List <UserRole_VM> query = new List <UserRole_VM>();
using (var db = new WebPortalEntities())
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <GetUserRole_Result, UserRole_VM>());
var mapper = config.CreateMapper();
List <GetUserRole_Result> data = db.GetUserRole(VM.UserRoleID, VM.UserRoleName).ToList();
return(mapper.Map <List <GetUserRole_Result>, List <UserRole_VM> >(data, query));
}
}
private List <Language_VM> ConnectGetDataProcedure(Language_VM VM)
{
List <Language_VM> query = new List <Language_VM>();
using (var db = new WebPortalEntities())
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <Language_VM, Language_VM>());
var mapper = config.CreateMapper();
List <Language_VM> data = null;
return(mapper.Map <List <Language_VM>, List <Language_VM> >(data, query));
}
}
private List <LoginDetails_VM> ConnectGetAccessDetailsDataProcedure(LoginDetails_VM VM)
{
List <LoginDetails_VM> query = new List <LoginDetails_VM>();
using (var db = new WebPortalEntities())
{
//Get User Role of string type
query = db.Database.SqlQuery <LoginDetails_VM>("exec UserLoginDetails @p_EndUserID",
new SqlParameter[] {
new SqlParameter("p_EndUserID", GetDBNULL(VM.EndUserID, true))
}).ToList();
}
return(query);
}
public List <ScreenAccess_VM> GetScreenAccess(ScreenAccess_VM VM)
{
List <ScreenAccess_VM> query = new List <ScreenAccess_VM>();
using (var db = new WebPortalEntities())
{
//Get Opportunity Type of string type
query = db.Database.SqlQuery <ScreenAccess_VM>("exec GetScreenAccess @p_MenuCode,@p_UserRoleID,@p_ModuleCode",
new SqlParameter[] {
new SqlParameter("p_MenuCode", GetDBNULLString(VM.MenuCode)),
new SqlParameter("p_UserRoleID", GetDBNULL(VM.UserRoleID)),
new SqlParameter("p_ModuleCode", GetDBNULL(VM.CurrentModuleCode))
}).ToList();
}
return(query);
}
/// <summary>
/// Get File Info
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public FolderFile_VM GetFileInfo(FolderFile_VM Model)
{
using (WebPortalEntities db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
ObjectParameter pFileRelativePath = new ObjectParameter("pFileRelativePath", DBNull.Value);
ObjectParameter pFileName = new ObjectParameter("pFileName", DBNull.Value);
ObjectParameter pFileType = new ObjectParameter("pFileType", DBNull.Value);
ObjectParameter pFileRemarks = new ObjectParameter("pFileRemarks", DBNull.Value);
ObjectParameter pCreatedDateTime = new ObjectParameter("pCreatedDateTime", DBNull.Value);
ObjectParameter pLastAccessDateTime = new ObjectParameter("pLastAccessDateTime", DBNull.Value);
ObjectParameter pAccessCount = new ObjectParameter("pAccessCount", 0);
ObjectParameter pTxnTimestamp = new ObjectParameter("pTxnTimestamp", DBNull.Value);
db.GetFileInfo(Model.FileID, pFileRelativePath, pFileName, pFileType, pFileRemarks, pCreatedDateTime, pLastAccessDateTime, pAccessCount, pTxnTimestamp);
db.SaveChanges();
trans.Commit();
Model.FileRelativePath = pFileRelativePath.Value.ToString();
Model.FileName = pFileName.Value.ToString();
Model.FileType = pFileType.Value.ToString();
Model.FileRemarks = pFileRemarks.Value.ToString();
Model.CreatedDateTime = Convert.ToDateTime(pCreatedDateTime.Value);
if (pLastAccessDateTime.Value != DBNull.Value)
{
Model.LastAccessDateTime = Convert.ToDateTime(pLastAccessDateTime.Value);
}
Model.AccessCount = Convert.ToInt32(pAccessCount.Value);
Model.TxnTimestamp = (byte[])pTxnTimestamp.Value;
return(Model);
}
catch (Exception ex)
{
trans.Rollback();
logger.Error("FileSystem_GetFileInfo Error: ", ex);
throw;
}
}
}
}
private List <Menu_VM> ConnectGetDataProcedure(Menu_VM VM)
{
List <Menu_VM> query = new List <Menu_VM>();
using (var db = new WebPortalEntities())
{
query = db.Database.SqlQuery <Menu_VM>("exec GetMenu @p_MenuCode,@p_MenuName,@p_Sequence, @p_ParentMenuCode, @p_ModuleCode",
new SqlParameter[] {
new SqlParameter("p_MenuCode", GetDBNULLString(VM.MenuCode)),
new SqlParameter("p_MenuName", GetDBNULLString(VM.MenuName)),
new SqlParameter("p_Sequence", GetDBNULL(VM.Sequence, true)),
new SqlParameter("p_ParentMenuCode", GetDBNULL(VM.ParentMenuCode)),
new SqlParameter("p_ModuleCode", GetDBNULLString(VM.ModuleCode)),
}).ToList();
}
return(query);
}
public int RefreshUserLeafLocation(EndUser_VM Model)
{
List <int> outPara = new List <int>();
using (var db = new WebPortalEntities())
{
try
{
var par = new SqlParameter[] { new SqlParameter("@p_EndUserID", GetDBNULL(Model.EndUserID)) };
var dd = db.Database.SqlQuery <List <int> >("exec InsertUserLeafLocation", par).ToList();
return(1);
}
catch (Exception ex)
{
logger.Error("CustomerDashboardRepository_RefreshUserLeafLocation Error: ", ex);
throw;
}
}
}
public bool Update(UserRole_VM Model)
{
try
{
using (var db = new WebPortalEntities())
{
int returnResult = db.UpdateUserRole(Model.UserRoleID, Model.UserRoleName, Model.CurrentEndUserID, Model.CurrentScreenID, Model.AccessPoint);
db.SaveChanges();
return(returnResult > 0);
}
}
catch (Exception ex)
{
logger.Error("Error: ", ex);
throw;
}
}
public int Delete(CustomerWeeklyOff_VM Model)
{
int result = 0;
try
{
using (var db = new WebPortalEntities())
{
result = db.DeleteCustomerWeeklyOff(Model.LocationID, Model.DayName, Model.CurrentLanguageCode, Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint);
db.SaveChanges();
}
}
catch (Exception ex)
{
logger.Error("CustomerWeeklyOffRepository_Delete Error: ", ex);
throw;
}
return(result);
}
/// <summary>
/// Get Files Info
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public List <FolderFile_VM> GetFilesInfo(FolderFile_VM Model)
{
List <FolderFile_VM> model = new List <FolderFile_VM>();
using (WebPortalEntities db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
DataTable dt_FileIDModule = new DataTable();
if (Model.FileID_TableTypeList != null && Model.FileID_TableTypeList.Count > 0)
{
dt_FileIDModule = ConvertToDatatable(Model.FileID_TableTypeList);
}
else
{
dt_FileIDModule = ConvertToDatatable(new List <FileID_TableType_VM>());
}
var par = new SqlParameter[] {
new SqlParameter("@pFileTable", dt_FileIDModule)
{
TypeName = "FileID_TableType"
}
};
model = db.Database.SqlQuery <FolderFile_VM>("exec GetFilesInfo", par).ToList();
trans.Commit();
return(model);
}
catch (Exception ex)
{
trans.Rollback();
logger.Error("FileSystem_GetFilesInfo Error: ", ex);
throw;
}
}
}
}
public List <Language_VM> GetLanguageData(string LanguageCode)
{
List <Language_VM> RoleModel = new List <Language_VM>();
try
{
using (var db = new WebPortalEntities())
{
return(RoleModel = ConnectGetDataProcedure(new Language_VM()
{
LanguageCode = LanguageCode
}).ToList());
}
}
catch (Exception ex)
{
logger.Error("CommonRepository_GetLanguageData: ", ex);
throw;
}
}
public bool Add(UserRole_VM Model)
{
try
{
using (var db = new WebPortalEntities())
{
var returnResult = new ObjectParameter("p_UserRoleID", 0);
db.AddUserRole(Model.UserRoleName, Model.CurrentEndUserID, Model.CurrentScreenID, Model.AccessPoint, returnResult);
db.SaveChanges();
return(Convert.ToInt32(returnResult.Value) > 0);
}
}
catch (Exception ex)
{
logger.Error("UserRoleRepository_Add: ", ex);
throw;
}
}
public bool ChangeForgotPassword(ResetPasswordVM model)
{
try
{
bool result = false;
using (var db = new WebPortalEntities())
{
var data = db.ResetPassword(model.EndUserID, model.NewPassword, model.LoginID);
if (data.Count() > 0)
{
result = true;
}
return(result);
}
}
catch (Exception ex)
{
logger.Error("Error: ", ex);
throw;
}
}
/// <summary>
/// Delete File Physically
/// </summary>
/// <param name="filePath"></param>
/// <returns></returns>
public bool DeleteFilePhysical(string filePath)
{
using (WebPortalEntities db = new WebPortalEntities())
{
try
{
File.Delete(filePath);
return(true);
}
catch (IOException iox)
{
logger.Error("FileSystem_DeleteFilePhysical Error: ", iox);
throw;
}
catch (Exception ex)
{
logger.Error("FileSystem_DeleteFilePhysical Error: ", ex);
throw;
}
}
}
public List <SafetyDashboardYearlyChart_VM> GetDashboardYearlySnapshot(SafetyDashboard_VM Model)
{
var query = new List <SafetyDashboardYearlyChart_VM>();
try
{
using (var db = new WebPortalEntities())
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <GetCustomerSafetyDashboardYearlyChart_Result, SafetyDashboardYearlyChart_VM>());
var mapper = config.CreateMapper();
var data = db.GetCustomerSafetyDashboardYearlyChart(Model.CustomerID, Model.CurrentModuleCode, Model.CurrentServiceLineCode, Model.CurrentLanguageCode,
Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint).ToList();
return(mapper.Map <List <GetCustomerSafetyDashboardYearlyChart_Result>, List <SafetyDashboardYearlyChart_VM> >(data, query));
}
}
catch (Exception ex)
{
logger.Error("CustomerDashboardRepository_GetDashboardYearlySnapshot Error: ", ex);
throw;
}
}
public List <CustomerAddress_VM> GetData(CustomerAddress_VM Model)
{
List <CustomerAddress_VM> query = new List <CustomerAddress_VM>();
try
{
using (var db = new WebPortalEntities())
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <GetCustomerAddress_Result, CustomerAddress_VM>());
var mapper = config.CreateMapper();
ObjectResult <GetCustomerAddress_Result> data = db.GetCustomerAddress(Model.CustomerID, Model.AddressType, Model.AddressLine1, Model.AddressLine2, Model.CityName, Model.StateName, Model.CountryName, Model.Pincode, Model.IsPrimaryAddress, Model.CurrentLanguageCode, Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint);
mapper.Map <ObjectResult <GetCustomerAddress_Result>, List <CustomerAddress_VM> >(data, query);
}
}
catch (Exception ex)
{
logger.Error("CustomerAddressRepository_GetData Error: ", ex);
throw;
}
return(query);
}
/// <summary>
/// UnDelete File
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public bool UnDeleteFile(FolderFile_VM Model)
{
using (WebPortalEntities db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
db.UnDeleteFile(Model.FileID, Model.TxnTimestamp);
db.SaveChanges();
trans.Commit();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
logger.Error("FileSystem_UnDeleteFile Error: ", ex);
throw;
}
}
}
}
/// <summary>
/// Hard delete file
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public bool RemoveFile(FolderFile_VM Model, string filePath)
{
FolderFile_VM model = new FolderFile_VM();
using (WebPortalEntities db = new WebPortalEntities())
{
try
{
model = GetFileInfo(Model);
db.RemoveFile(Model.FileID, model.TxnTimestamp);
db.SaveChanges();
DeleteFilePhysical(filePath + model.FileRelativePath + "." + model.FileType);
return(true);
}
catch (Exception ex)
{
logger.Error("FileSystem_RemoveFile Error: ", ex);
throw;
}
}
}
/// <summary>
/// Save file
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public FolderFile_VM AddFile(FolderFile_VM Model, HttpPostedFileBase file, string path)
{
using (WebPortalEntities db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
Model.FileName = file.FileName;
Model.FileType = Path.GetExtension(file.FileName).Replace(".", "").ToLower();
//Model.FileSize = file.ContentLength;
ObjectParameter pFileID = new ObjectParameter("pFileID", 0);
ObjectParameter pFileRelativePath = new ObjectParameter("pFileRelativePath", "");
db.AddFile(Model.ObjectType, Model.ObjectInstanceID, Model.FileName, Model.FileType, Model.FileSize, Model.FileRemarks, pFileID, pFileRelativePath);
db.SaveChanges();
Model.FileID = Convert.ToInt32(pFileID.Value);
Model.FileRelativePath = pFileRelativePath.Value.ToString();
Model.FileRelativePath = path + Model.FileRelativePath;
UploadFiles(file, Model.FileRelativePath, Model);
trans.Commit();
return(Model);
}
catch (Exception ex)
{
trans.Rollback();
logger.Error("FileSystem_AddFile Error: ", ex);
throw;
}
}
}
}
