public bool SubtractStockLeft(decimal stockAmount, long productID)
{
decimal stockLeft = Convert.ToDecimal(StockLeftByProduct(productID));
if (stockLeft >= stockAmount)
{
using (var _context = new SalesTrackingSystemEntities())
{
decimal newFistbatchStockLeft;
var FirstBatchdata = (from batch in _context.Batches.Where(batch => batch.ProductID == productID && batch.StockLeft != 0)
select new Batch_Model()
{
BatchID = batch.BatchID,
StockLeft = batch.StockLeft,
}).FirstOrDefault();
if (FirstBatchdata.StockLeft >= stockAmount)
{
newFistbatchStockLeft = Convert.ToDecimal(FirstBatchdata.StockLeft) - stockAmount;
var data = _context.Batches.Where(batch => batch.BatchID == FirstBatchdata.BatchID).FirstOrDefault();
data.StockLeft = newFistbatchStockLeft;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
}
else
{
newFistbatchStockLeft = Convert.ToDecimal(FirstBatchdata.StockLeft) - stockAmount;
var data = _context.Batches.Where(batch => batch.BatchID == FirstBatchdata.BatchID).FirstOrDefault();
data.StockLeft = newFistbatchStockLeft;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
var SecondtBatchdata = (from batch in _context.Batches.Where(batch => batch.ProductID == productID && batch.StockLeft != 0)
select new Batch_Model()
{
BatchID = batch.BatchID,
StockLeft = batch.StockLeft,
}).FirstOrDefault();
var newSecondbatchStockLeft = Convert.ToDecimal(FirstBatchdata.StockLeft) - newFistbatchStockLeft;
var SecondData = _context.Batches.Where(batch => batch.BatchID == SecondtBatchdata.BatchID).FirstOrDefault();
data.StockLeft = newSecondbatchStockLeft;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
}
}
return(true);
}
else
{
return(false);
}
}
public bool Save(Products_Model model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = new Product()
{
ProductID = GetNewProductID(),
ProductCategoryID = model.ProductCategoryID,
ProductName = model.ProductName,
PackRate = model.PackRate,
UnitId = model.UnitId,
Description = model.Description,
DateCreated = DateTime.Now
};
_context.Products.Add(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
public bool Save(DistributorArea_Model distArea)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = new DistributorArea()
{
DistributorAreaID = GetNewDistributorAreaID(),
DistrubitorID = distArea.DistrubitorID,
City = distArea.City,
State = distArea.State,
District = distArea.District,
Address = distArea.Address,
Latitude = distArea.Latitude,
Longitude = distArea.Longitude,
DateCreated = DateTime.Now
};
_context.DistributorAreas.Add(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
public bool Save(Batch_Model model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = new Batch()
{
BatchID = GetNewBatchID(),
BatchName = model.BatchName,
ProductCategoryId = model.ProductCategoryId,
ProductID = model.ProductID,
QunatityProduced = model.QunatityProduced,
UnitPrice = model.UnitPrice,
StockLeft = Convert.ToInt64(model.QunatityProduced),
DateProduced = model.DateProduced,
ExpiryDate = model.ExpiryDate,
DateCreated = DateTime.Now
};
_context.Batches.Add(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
public bool Update(DistributorArea_Model model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.DistributorAreas.Where(distArea => distArea.DistributorAreaID == model.DistributorAreaID).FirstOrDefault();
data.DistributorAreaID = model.DistributorAreaID;
data.DistrubitorID = model.DistrubitorID;
data.State = model.State;
data.District = model.District;
data.City = model.City;
data.Address = model.Address;
data.Latitude = model.Latitude;
data.Longitude = model.Longitude;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
//throw;
}
}
}
public bool UpdateUserAccount(Users_Model users_Model)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = _dbContext.Users.Where(act => act.UserID == users_Model.UserID).FirstOrDefault();
data.UserProfileID = users_Model.UserProfileID;
data.DistrubitorID = users_Model.DistrubitorID;
data.FullName = users_Model.FullName;
data.MobileNo = users_Model.MobileNo;
if (users_Model.ImageString != null)
{
data.ImageString = users_Model.ImageString;
}
data.UsersStatus = users_Model.UsersStatus;
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Update(Batch_Model model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Batches.Where(batch => batch.BatchID == model.BatchID).FirstOrDefault();
data.BatchName = model.BatchName;
data.ProductCategoryId = model.ProductCategoryId;
data.ProductID = model.ProductID;
data.QunatityProduced = model.QunatityProduced;
data.UnitPrice = model.UnitPrice;
data.StockLeft = model.StockLeft;
data.DateProduced = model.DateProduced;
data.ExpiryDate = model.ExpiryDate;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool SaveUserProfileDetails(UserProfileDetails_Model userProfileDetails)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = new UserProfileDetail()
{
UserProfileDetailID = userProfileDetails.UserProfileDetailID,
UserProfileID = userProfileDetails.UserProfileID,
ModuleID = userProfileDetails.ModuleID,
ModuleActionID = userProfileDetails.ModuleActionID,
ProfileDetailStatus = userProfileDetails.ProfileDetailStatus,
Description = userProfileDetails.Description,
CreatedBy = userProfileDetails.CreatedBy,
DateCreated = DateTime.Now
};
_dbContext.UserProfileDetails.Add(data);
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Update(Distributor_Model model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Distributors.Where(dist => dist.DistrubitorID == model.DistrubitorID).FirstOrDefault();
data.DistrubitorID = model.DistrubitorID;
data.DistrubitorName = model.DistrubitorName;
data.OwnerName = model.OwnerName;
data.RegestrationID = model.RegestrationID;
data.MobileNo = model.MobileNo;
data.Phone = model.Phone;
data.Fax = model.Fax;
data.Email = model.Email;
data.State = model.State;
data.District = model.District;
data.Address = model.Address;
data.Latitude = model.Latitude;
data.Longitude = model.Longitude;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public Int64 SaveTransaction(Transaction_Model transaction)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = new Transaction()
{
TransactionID = GetNewTransactionID(),
TransactionLevel = transaction.TransactionLevel,
SupplierID = transaction.SupplierID,
ReceiverID = transaction.ReceiverID,
InvoiceNo = transaction.InvoiceNo,
InvoiceDate = transaction.InvoiceDate,
InvoiceEntryDate = DateTime.Now,
DiscountPercent = transaction.DiscountPercent,
TaxPercent = transaction.TaxPercent,
DateCreated = DateTime.Now
};
_dbContext.Transactions.Add(data);
_dbContext.SaveChanges();
var transactionID = data.TransactionID;
return(transactionID);
}
catch (Exception)
{
throw;
}
}
}
public bool Save(Distributor_Model model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = new Distributor()
{
DistrubitorID = GetNewDistributorID(),
DistrubitorName = model.DistrubitorName,
OwnerName = model.OwnerName,
RegestrationID = model.RegestrationID,
MobileNo = model.MobileNo,
Phone = model.Phone,
Fax = model.Fax,
Email = model.Email,
State = model.State,
District = model.District,
Address = model.Address,
Latitude = model.Latitude,
Longitude = model.Longitude,
DateCreated = DateTime.Now
};
_context.Distributors.Add(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
public bool Save(Reseller_Model res)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = new Reseller()
{
ResellerID = GetNewResellerId(),
ResellerName = res.ResellerName,
OwnerName = res.OwnerName,
RegestrationID = res.RegestrationID,
DistrubitorID = res.DistrubitorID,
Mobile = res.Mobile,
Phone = res.Phone,
Email = res.Email,
State = res.State,
District = res.District,
Address = res.Address,
Latitude = res.Latitude,
Longitude = res.Longitude,
DateCreated = DateTime.Now
};
_context.Resellers.Add(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
public bool Update(Reseller_Model res)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Resellers.Where(reseller => reseller.ResellerID == res.ResellerID).FirstOrDefault();
data.ResellerID = res.ResellerID;
data.ResellerName = res.ResellerName;
data.OwnerName = res.OwnerName;
data.RegestrationID = res.RegestrationID;
data.DistrubitorID = res.DistrubitorID;
data.Mobile = res.Mobile;
data.Phone = res.Phone;
data.Email = res.Email;
data.State = res.State;
data.District = res.District;
data.Address = res.Address;
data.Latitude = res.Latitude;
data.Longitude = res.Longitude;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
public bool SaveUserAccount(Users_Model users_Model)
{
using (var db_Context = new SalesTrackingSystemEntities())
{
using (DbContextTransaction db = db_Context.Database.BeginTransaction())
{
try
{
var UserData = new User()
{
UserID = GetNewUserId(),
UserProfileID = users_Model.UserProfileID,
FullName = users_Model.FullName,
PasswordHash = users_Model.PasswordHash,
Email = users_Model.Email,
MobileNo = users_Model.MobileNo,
ImageString = users_Model.ImageString,
UsersStatus = users_Model.UsersStatus,
DateCreated = DateTime.Now
};
db_Context.Users.Add(UserData);
db_Context.SaveChanges();
var userId = UserData.UserID;
Verification_Interface verification_ = new Verification_service();
var DataVarification = new Verification()
{
VerificationID = verification_.GetNewVerificationId(),
UserID = userId,
IsVerified = false,
DateCreated = DateTime.Now
};
db_Context.Verifications.Add(DataVarification);
db_Context.SaveChanges();
db.Commit();
return(true);
}
catch (DbEntityValidationException)
{
db.Rollback();
return(false);
}
}
}
}
public bool Delete(long ResellerId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Resellers.Where(res => res.ResellerID == ResellerId).FirstOrDefault();
_context.Resellers.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool DeleteUserProfileDetails(long userProfileDetailsId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.UserProfileDetails.Where(userProfileDetails => userProfileDetails.UserProfileDetailID == userProfileDetailsId).FirstOrDefault();
_context.UserProfileDetails.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool DeleteModule(long moduleId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Modules.Where(ModuleActions => ModuleActions.ModuleID == moduleId).FirstOrDefault();
_context.Modules.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool updateCheckedVerification(long userId, byte isVerified)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = _dbContext.Verifications.Where(verificationAction => verificationAction.UserID == userId).FirstOrDefault();
data.IsVerified = Convert.ToBoolean(isVerified);
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public Users_Model UpdateOnLogin(string email, string password, string token = null, int status = 1)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = _dbContext.Users.Where(actionUser => actionUser.Email == email && actionUser.PasswordHash == password).FirstOrDefault();
data.Token = token;
data.UsersStatus = status;
_dbContext.SaveChanges();
var returnData = (from actionUser in _dbContext.Users.Where(actionUser => actionUser.Email == email && actionUser.PasswordHash == password)
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(returnData);
}
catch (Exception)
{
throw;
}
}
}
public bool MakeDistrubitorNull(long userId)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = _dbContext.Users.Where(a => a.UserID == userId).FirstOrDefault();
data.DistrubitorID = null;
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Delete(long DistributorId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Distributors.Where(dist => dist.DistrubitorID == DistributorId).FirstOrDefault();
_context.Distributors.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Delete(long unitID)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Units.Where(dist => dist.UnitId == unitID).FirstOrDefault();
_context.Units.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Delete(long ProductId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Products.Where(prod => prod.ProductID == ProductId).FirstOrDefault();
_context.Products.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool DeleteDashboardTable(long DashboardTableId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.DashboardTables.Where(dashboardTable => dashboardTable.DashboardTableId == DashboardTableId).FirstOrDefault();
_context.DashboardTables.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool DeleteDashboardGivenColumn(long GivenColumnId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.DashboardGivenColumns.Where(GivenColumns => GivenColumns.DashboardGivenColumnId == GivenColumnId).FirstOrDefault();
_context.DashboardGivenColumns.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool DeleteVerification(long userId)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Verifications.Where(act => act.UserID == userId).FirstOrDefault();
_context.Verifications.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
public bool DeleteTransaction(long TransactionID)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Transactions.Where(trans => trans.TransactionID == TransactionID).FirstOrDefault();
_context.Transactions.Remove(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool updateResetAuthentication(Int64 userId, DateTime dateTriggered, string resetToken)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = _dbContext.Verifications.Where(verificationAction => verificationAction.UserID == userId).FirstOrDefault();
data.ResetTriggered = dateTriggered;
data.ResetToken = resetToken;
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool UpdateOnLogout(string email, string password, string token = null, int status = 2)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = _dbContext.Users.Where(a => a.Email == email && a.PasswordHash == password).FirstOrDefault();
data.Token = token;
data.UsersStatus = status;
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool UpateBalance(decimal balance, long transactionID)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Transactions.Where(trans => trans.TransactionID == transactionID).FirstOrDefault();
data.Balance = balance;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}