public static void deletePayment(int id)
{
PaymentType payment = (PaymentType)dbEntity.PaymentTypes.Where(p => p.PaymentTypeID == id).FirstOrDefault();
dbEntity.PaymentTypes.Remove(payment);
dbEntity.SaveChanges();
}
public static void DeleteProductType(int id)
{
ProductType pt = (ProductType)dbEntity.ProductTypes.Where(a => a.ProductTypeID == id).FirstOrDefault();
dbEntity.ProductTypes.Remove(pt);
dbEntity.SaveChanges();
}
public static void InsertProduct(int TypeID, string name, int price, int stock)
{
Product prd = ProductFactory.InsertProduct(TypeID, name, price, stock);
dbEntity.Products.Add(prd);
dbEntity.SaveChanges();
}
public static void RegisterUser(String name, String email, String pass, String gender)
{
User usr = UserFactory.CreateUser(name, email, pass, gender);
dbEntity.Users.Add(usr);
dbEntity.SaveChanges();
}
public static void DeleteType(String ID)
{
MsProductType product = SearchTypeByID(ID);
db.MsProductTypes.Remove(product);
db.SaveChanges();
}
public static void deleteCart(int userID, int productID)
{
Cart cart = (from x in dbEntity.Carts
where x.UserID == userID && x.ProductID == productID
select x).FirstOrDefault();
dbEntity.Carts.Remove(cart);
dbEntity.SaveChanges();
}
public static void insertDetailTransaction(int transactionID, int productID, int quantity)
{
DetailTransaction dt = DetailTransactionFactory.addDetailTransaction(transactionID, productID, quantity);
dbEntity.DetailTransactions.Add(dt);
dbEntity.SaveChanges();
}
public static int insertHeaderTransaction(int userID, int paymentTypeID)
{
HeaderTransaction ht = HeaderTransactionFactory.addHeaderTransaction(userID, paymentTypeID);
dbEntity.HeaderTransactions.Add(ht);
dbEntity.SaveChanges();
return(ht.TransactionID);
}
public static void InsertProduct(String TypeID, String Name, int Price, int Stock, Int64 ID)
{
db.MsProducts.Add(FactoryMsProduct.InitProduct(TypeID, Name, Price, Stock, ID));
db.SaveChanges();
}
public static void InsertPaymentType(Int64 ID, String Name)
{
db.MsPaymentTypes.Add(FactoryMsPaymentType.InitPaymentType(ID, Name));
db.SaveChanges();
}
public static void InsertCart(String UserID, String ProductID, int qty)
{
db.MsCarts.Add(FactoryMsCart.InitCart(UserID, ProductID, qty));
db.SaveChanges();
}
public static void RegisData(String Nama, String Email, String Password, String Gender, Int64 ID)
{
db.MsUsers.Add(FactoryUser.InitUser(Nama, Email, Password, Gender, ID));
db.SaveChanges();
}
public static void insertDetail(String TransactionID, String ProductID, int Quantity)
{
db.DetailTransactions.Add(FactoryDetailTransaction.InitDetail(TransactionID, ProductID, Quantity));
db.SaveChanges();
}
