public bool UpdateDashboardType(DashboardType_Model DashboardType) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.DashboardTypes.Where(dashboardType => dashboardType.DashboardTypeID == DashboardType.DashboardTypeID).FirstOrDefault(); data.DashboardTypeID = DashboardType.DashboardTypeID; data.TypeName = DashboardType.TypeName; data.DateUpdated = DateTime.Now; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public Users_Model GetModelByToken(string token) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from actionUser in _dbContext.Users.Where(actionUser => actionUser.Token == token) join actionUserProfile in _dbContext.UserProfiles on actionUser.UserProfileID equals actionUserProfile.UserProfileID join actionVericication in _dbContext.Verifications on actionUser.UserID equals actionVericication.UserID select new Users_Model() { UserID = actionUser.UserID, UserProfileID = actionUserProfile.UserProfileID, DistrubitorID = actionUser.DistrubitorID, FullName = actionUser.FullName, PasswordHash = actionUser.PasswordHash, Email = actionUser.Email, Token = actionUser.Token, MobileNo = actionUser.MobileNo, ImageString = actionUser.ImageString, UsersStatus = actionUser.UsersStatus, ProfileName = actionUserProfile.ProfileName, Description = actionUserProfile.Description, CreatedBy = actionUserProfile.CreatedBy, UserProfileStatus = actionUserProfile.UserProfileStatus, VerificationID = actionVericication.VerificationID, IsVerified = actionVericication.IsVerified, VerifiedToken = actionVericication.VerifiedToken, DateVerified = actionVericication.DateVerified, ResetToken = actionVericication.ResetToken, ResetTriggered = actionVericication.ResetTriggered, DateCreated = actionUser.DateCreated, DateUpdated = actionUser.DateUpdated }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public bool Update(ProductCategory_Model model) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.ProductCategories.Where(ProductCategory => ProductCategory.ProductCategoryID == model.ProductCategoryID).FirstOrDefault(); data.ProductCategoryName = model.ProductCategoryName; data.IsSubCategory = model.IsSubCategory; data.SubCategoryOf = model.SubCategoryOf; data.CategoryStatus = model.CategoryStatus; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool UpdateUserProfile(UserProfile_Model userProfile) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.UserProfiles.Where(userProfiles => userProfiles.UserProfileID == userProfile.UserProfileID).FirstOrDefault(); data.ProfileName = userProfile.ProfileName; data.UserProfileStatus = userProfile.UserProfileStatus; data.Description = userProfile.Description; //data.CreatedBy = userProfile.CreatedBy; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool UpdateAction(ModuleAction_Model action) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.ModuleActions.Where(moduleActions => moduleActions.ModuleActionID == action.ModuleActionID).FirstOrDefault(); data.ModuleID = action.ModuleID; data.ActionName = action.ActionName; data.ActionStatus = action.ActionStatus; data.Description = action.Description; data.DateUpdated = DateTime.Now; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool UpdateModule(Module_Model model) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.Modules.Where(ActionModules => ActionModules.ModuleID == model.ModuleID).FirstOrDefault(); data.ModuleName = model.ModuleName; data.ControllerName = model.ControllerName; data.ModuleStatus = model.ModuleStatus; data.Description = model.Description; data.DateUpdated = DateTime.Now; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool UpdateUnit(Unit_Model unit_Model) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.Units.Where(unit => unit.UnitId == unit_Model.UnitId).FirstOrDefault(); data.UnitId = unit_Model.UnitId; data.UnitName = unit_Model.UnitName; data.UnitAbb = unit_Model.UnitAbb; data.Description = unit_Model.Description; data.DateUpdated = DateTime.Now; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool UpdateUserProfile(Users_Model users_Model) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = _dbContext.Users.Where(act => act.UserID == users_Model.UserID).FirstOrDefault(); data.FullName = users_Model.FullName; data.MobileNo = users_Model.MobileNo; if (users_Model.ImageString != null) { data.ImageString = users_Model.ImageString; } _dbContext.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public List <ProductCategory_Model> ListAllData() { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.ProductCategories.Select(ProductCategory => new ProductCategory_Model() { ProductCategoryID = ProductCategory.ProductCategoryID, ProductCategoryName = ProductCategory.ProductCategoryName, IsSubCategory = ProductCategory.IsSubCategory, SubCategoryOf = ProductCategory.SubCategoryOf, CategoryStatus = ProductCategory.CategoryStatus }).ToList().OrderBy(ProductCategory => ProductCategory.ProductCategoryName).ToList(); return(data); } catch (Exception) { throw; } } }
public bool SaveDashboardTable(DashboardTable_Model DashboardTable) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = new DashboardTable() { DashboardTableId = GetNewDashboardTableID(), TableName = DashboardTable.TableName, DateCreated = DateTime.Now }; _dbContext.DashboardTables.Add(data); _dbContext.SaveChanges(); return(true); } catch (Exception) { throw; } } }
public List <DashboardTable_Model> DisplayTable() { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from table in _dbContext.DashboardTables select new DashboardTable_Model() { DashboardTableId = table.DashboardTableId, TableName = table.TableName, DateCreated = table.DateCreated, DateUpdated = table.DateUpdated }).ToList(); return(data); } catch (Exception) { throw; } } }
public string StockLeftByProduct(long productID) { string StockLeft; using (var _dbContext = new SalesTrackingSystemEntities()) { try { StockLeft = (_dbContext.Batches.Where(bate => bate.ProductID == productID).Sum(bat => bat.StockLeft)).ToString(); if (StockLeft == "") { StockLeft = "0"; } return(StockLeft); } catch (Exception) { StockLeft = "0"; return(StockLeft); } } }
public List <Module_Model> DisplayTable() { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = _dbContext.Modules.Select(ModuleAction => new Module_Model() { ModuleID = ModuleAction.ModuleID, ModuleName = ModuleAction.ModuleName, ControllerName = ModuleAction.ControllerName, ModuleStatus = ModuleAction.ModuleStatus, Description = ModuleAction.Description }).ToList().OrderBy(ModuleAction => ModuleAction.ModuleName).ToList(); return(data); } catch (Exception) { throw; } } }
public List <UserProfile_Model> DisplayTable() { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = _dbContext.UserProfiles.Select(userProfile => new UserProfile_Model() { UserProfileID = userProfile.UserProfileID, ProfileName = userProfile.ProfileName, UserProfileStatus = userProfile.UserProfileStatus, CreatedBy = userProfile.CreatedBy, Description = userProfile.Description }).ToList().OrderBy(userProfile => userProfile.ProfileName).ToList(); return(data); } catch (Exception) { throw; } } }
public ProductCategory_Model GetProductCatgoryById(long id) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.ProductCategories.Where(productCategory => productCategory.ProductCategoryID == id).Select(productCategory => new ProductCategory_Model() { ProductCategoryID = productCategory.ProductCategoryID, ProductCategoryName = productCategory.ProductCategoryName, IsSubCategory = productCategory.IsSubCategory, SubCategoryOf = productCategory.SubCategoryOf, CategoryStatus = productCategory.CategoryStatus }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public DashboardTable_Model DashboardTableByID(long DashboardTableId) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from dashboardTable in _dbContext.DashboardTables.Where(dashboardTable => dashboardTable.DashboardTableId == DashboardTableId) select new DashboardTable_Model() { DashboardTableId = dashboardTable.DashboardTableId, TableName = dashboardTable.TableName, DateCreated = dashboardTable.DateCreated, DateUpdated = dashboardTable.DateUpdated }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public bool SaveTransactionDetails(List <TransactionDetail> transactionDetail) { using (SalesTrackingSystemEntities db_Context = new SalesTrackingSystemEntities()) { using (DbContextTransaction db = db_Context.Database.BeginTransaction()) { try { foreach (TransactionDetail TDItem in transactionDetail) { db_Context.TransactionDetails.Add(TDItem); } db_Context.SaveChanges(); Batch_Interface batch_ = new Batch_Service(); foreach (TransactionDetail item in transactionDetail) { TransactionId = Convert.ToInt64(item.TransactionID); QuantitySum += item.Quantity; productId = Convert.ToInt64(item.ProductID); batch_.SubtractStockLeft(item.Quantity, Convert.ToInt64(item.ProductID)); } decimal MamPrice = batch_.MaxPriceByProductID(productId); decimal balance = QuantitySum * MamPrice; UpateBalance(balance, TransactionId); db.Commit(); return(true); } catch (DbEntityValidationException) { db.Rollback(); DeleteTransaction(TransactionId); return(false); } } } }
public ModuleAction_Model ActionByID(long actionId) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from moduleActions in _dbContext.ModuleActions.Where(moduleActions => moduleActions.ModuleActionID == actionId) select new ModuleAction_Model() { ModuleActionID = moduleActions.ModuleActionID, ModuleID = moduleActions.ModuleID, ActionName = moduleActions.ActionName, ActionStatus = moduleActions.ActionStatus, Description = moduleActions.Description, }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public UserProfile_Model UserProfilByID(long userProfileId) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from userProfile in _dbContext.UserProfiles.Where(userProfiles => userProfiles.UserProfileID == userProfileId) select new UserProfile_Model() { UserProfileID = userProfile.UserProfileID, ProfileName = userProfile.ProfileName, UserProfileStatus = userProfile.UserProfileStatus, CreatedBy = userProfile.CreatedBy, Description = userProfile.Description }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public bool Update(Products_Model model) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.Products.Where(prod => prod.ProductID == model.ProductID).FirstOrDefault(); data.ProductID = model.ProductID; data.ProductCategoryID = model.ProductCategoryID; data.ProductName = model.ProductName; data.PackRate = model.PackRate; data.UnitId = model.UnitId; data.Description = model.Description; data.DateUpdated = DateTime.Now; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public Module_Model ModuleByID(long moduleId) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from ModuleActions in _dbContext.Modules.Where(ModuleActions => ModuleActions.ModuleID == moduleId) select new Module_Model() { ModuleID = ModuleActions.ModuleID, ModuleName = ModuleActions.ModuleName, ModuleStatus = ModuleActions.ModuleStatus, ControllerName = ModuleActions.ControllerName, Description = ModuleActions.Description }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public bool SaveDashboardGivenColumn(DashboardGivenColumn_Model GivenColumn) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = new DashboardGivenColumn() { DashboardGivenColumnId = GetNewDashboardGivenColumnID(), DashboardTableId = GivenColumn.DashboardTableId, ColumnName = GivenColumn.ColumnName, DateCreated = DateTime.Now }; _dbContext.DashboardGivenColumns.Add(data); _dbContext.SaveChanges(); return(true); } catch (Exception) { throw; } } }
public Unit_Model GetUnitById(long unitID) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.Units.Where(Unit => Unit.UnitId == unitID).Select(Unit => new Unit_Model() { UnitId = Unit.UnitId, UnitAbb = Unit.UnitAbb, UnitName = Unit.UnitName, Description = Unit.Description, DateCreated = Unit.DateCreated, DateUpdated = Unit.DateUpdated }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public string CheckLogin(string email, string password) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from actions in _dbContext.Users.Where(actions => actions.Email == email && actions.PasswordHash == password) select new Users_Model() { FullName = actions.FullName, Email = actions.Email, PasswordHash = actions.PasswordHash, UsersStatus = actions.UsersStatus }).FirstOrDefault(); if (data.UsersStatus == 1 && data.Email == email && data.PasswordHash == password) { return("ValidUserActiveStatus"); } else if (data.UsersStatus == 2 && data.Email == email && data.PasswordHash == password) { return("ValidUserInactiveStatus"); } else if (data.UsersStatus == 3 && data.Email == email && data.PasswordHash == password) { return("ValidUserBlockedStatus"); } else { return("InvalidUser"); } } catch (Exception) { return("InvalidUserUnknownStatus"); } } }
public bool Save(Unit_Model unit_Model) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = new Unit() { UnitId = GetNewUnitID(), UnitAbb = unit_Model.UnitAbb, UnitName = unit_Model.UnitName, Description = unit_Model.Description, DateCreated = DateTime.Now }; _context.Units.Add(data); _context.SaveChanges(); return(true); } catch (Exception) { throw; } } }
public Verification_Model checkReset(long userId, string resetToken) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from verificationAction in _dbContext.Verifications.Where(verificationAction => verificationAction.UserID == userId && verificationAction.ResetToken == resetToken) select new Verification_Model() { VerificationID = verificationAction.VerificationID, UserID = verificationAction.UserID, ResetTriggered = verificationAction.ResetTriggered, ResetToken = verificationAction.ResetToken, DateCreated = verificationAction.DateCreated, DateUpdated = verificationAction.DateUpdated }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public bool UpdateUserProfileDetails(UserProfileDetails_Model userProfileDetails) { using (var _context = new SalesTrackingSystemEntities()) { try { var data = _context.UserProfileDetails.Where(userProfileDetail => userProfileDetail.UserProfileDetailID == userProfileDetails.UserProfileDetailID).FirstOrDefault(); data.UserProfileDetailID = userProfileDetails.UserProfileDetailID; data.UserProfileID = userProfileDetails.UserProfileID; data.ModuleID = userProfileDetails.ModuleID; data.ModuleActionID = userProfileDetails.ModuleActionID; data.ProfileDetailStatus = userProfileDetails.ProfileDetailStatus; data.Description = userProfileDetails.Description; data.DateUpdated = DateTime.Now; data.CreatedBy = userProfileDetails.CreatedBy; _context.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public UserProfileDetails_Model UserProfilDetailsByID(long userProfileDetailsId) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = (from userProfileDetails in _dbContext.UserProfileDetails.Where(userProfileDetails => userProfileDetails.UserProfileDetailID == userProfileDetailsId) select new UserProfileDetails_Model() { UserProfileDetailID = userProfileDetails.UserProfileDetailID, UserProfileID = userProfileDetails.UserProfileID, ModuleID = userProfileDetails.ModuleID, ModuleActionID = userProfileDetails.ModuleActionID, ProfileDetailStatus = userProfileDetails.ProfileDetailStatus, Description = userProfileDetails.Description, }).FirstOrDefault(); return(data); } catch (Exception) { throw; } } }
public bool SaveUserProfile(UserProfile_Model userProfile) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = new UserProfile() { ProfileName = userProfile.ProfileName, UserProfileStatus = userProfile.UserProfileStatus, Description = userProfile.Description, DateCreated = DateTime.Now //CreatedBy = userProfile.CreatedBy }; _dbContext.UserProfiles.Add(data); _dbContext.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool SaveModule(Module_Model model) { using (var _dbContext = new SalesTrackingSystemEntities()) { try { var data = new Module() { ModuleName = model.ModuleName, ControllerName = model.ControllerName, ModuleStatus = model.ModuleStatus, Description = model.Description, DateCreated = DateTime.Now }; _dbContext.Modules.Add(data); _dbContext.SaveChanges(); return(true); } catch (Exception) { throw; } } }