public bool UserActive(string username, string keyString)
{
try
{
T3UsersLogin t3user = db.T3UsersLogin.First(e => e.UserName == username && e.KeyStringValidEmail == keyString);
t3user.IsApply = 1;
db.Entry(t3user).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
internal static void AddClient(Client client)
{
using (ErpEntities dbContext = new ErpEntities())
{
dbContext.Client.Add(client);
dbContext.SaveChanges();
}
}
internal static void AddProduct(Product product)
{
using (ErpEntities dbContext = new ErpEntities())
{
dbContext.Product.Add(product);
dbContext.SaveChanges();
}
}
internal static void ChangeStock(int productID, int new_quantity)
{
using (ErpEntities dbContext = new ErpEntities())
{
Stock stock = dbContext.Stock.FirstOrDefault(f => f.ProductID == productID);
stock.ProductQuantity = new_quantity;
dbContext.SaveChanges();
}
}
internal static void ModifyClient(int userID, string clientName, string clientEmail)
{
using (ErpEntities dbContext = new ErpEntities())
{
var client = dbContext.Client.SingleOrDefault(f => f.ClientID == userID);
client.ClientName = clientName;
client.ClientEmail = clientEmail;
dbContext.SaveChanges();
}
}
internal static void ModifyProduct(int productID, string productName, decimal productPrice)
{
using (ErpEntities dbContext = new ErpEntities())
{
var product = dbContext.Product.SingleOrDefault(f => f.ProductID == productID);
product.ProductName = productName;
product.ProductPrice = productPrice;
dbContext.SaveChanges();
}
}
internal static void AddStock(Product product, int productQuantity)
{
using (ErpEntities dbContext = new ErpEntities())
{
Stock stock = new Stock
{
ProductID = product.ProductID,
ProductQuantity = productQuantity
};
dbContext.Stock.Add(stock);
dbContext.SaveChanges();
}
}
internal static bool RemoveClient(int userID)
{
using (ErpEntities dbContext = new ErpEntities())
{
Client client = dbContext.Client.FirstOrDefault(f => f.ClientID == userID);
if (client != null)
{
dbContext.Client.Remove(client);
dbContext.SaveChanges();
return(true);
}
else
{
Display.NoEntry();
return(false);
}
}
}
internal static bool RemoveProduct(int productID)
{
using (ErpEntities dbContext = new ErpEntities())
{
Product product = dbContext.Product.FirstOrDefault(f => f.ProductID == productID);
if (product != null)
{
dbContext.Product.Remove(product);
dbContext.SaveChanges();
return(true);
}
else
{
Display.NoEntry();
return(false);
}
}
}
public long Insert(User entity)
{
db.Users.Add(entity);
db.SaveChanges();
return(entity.ID);
}