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