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; } } } }