public static DetailTransaction AddTransactionDetail(DetailTransaction transactionDetail)
{
db.DetailTransactions.Add(transactionDetail);
db.SaveChanges();
return(transactionDetail);
}
public static void doInsertDetailTransaction(int transactionId, int productId, int qty)
{
DetailTransaction dt = DetailTransactionFactory.createDetailTransaction(transactionId, productId, qty);
db.DetailTransactions.Add(dt);
db.SaveChanges();
}
public static void InsertNewDetailTrans(int transId, int productId, int quantity)
{
DetailTransaction detailTrans = TransactionFactory.CreateNewDetailTrans(transId, productId, quantity);
db.DetailTransactions.Add(detailTrans);
db.SaveChanges();
}
public static long getSubTotal(DetailTransaction dt)
{
long subTotal = 0;
subTotal = dt.Quantity * dt.Product.Price;
return(subTotal);
}
public static void newTransactionDetail(int transactionID, int productID, int quantity)
{
DetailTransaction dt = DetailTransactionFactory.addNewDetail(transactionID, productID, quantity);
db.DetailTransactions.Add(dt);
db.SaveChanges();
}
public ActionResult DetailTransaction(string TransID)
{
TransactionHistoryDetailTableAdapter transactionDetail = new TransactionHistoryDetailTableAdapter();
DetailTransaction detail = new DetailTransaction();
try
{
int tranID = int.Parse(TransID);
transactionDT = transactionDetail.GetData(tranID);
DataRow data = transactionDT.Rows[0];
detail.Username = (string)data["Username"];
detail.TransactionTypeName = (string)data["TransactionTypeName"];
detail.Name = (string)data["Name"];
detail.TransactionContent = (string)data["TransactionContent"];
detail.Value = (int)data["Value"];
detail.InsertedDate = (DateTime)data["InsertedDate"];
detail.UpdatedBy = (string)data["UpdatedBy"];
detail.LastUpdated = (DateTime)data["LastUpdated"];
//detail.MealSetName = data.Field<string>("MealSetName");
detail.MealSetName = data["DishName"].ToString();
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
return RedirectToAction("ListTransaction", "Transaction");
}
return View(detail);
}
public bool checkout(int userID, int paymentID)
{
HeaderTransaction header = new HeaderTransaction();
header.UserID = userID;
header.PaymentTypesID = paymentID;
header.Date = DateTime.Now;
var head = db.HeaderTransactions.Add(header);
if (head == null)
{
return(false);
}
db.SaveChanges();
var carts = cartRepository.GetCartByUser(userID);
foreach (Cart item in carts)
{
DetailTransaction detail = new DetailTransaction();
detail.TransactionID = head.TransactionID;
detail.ProductID = item.ProductID.Value;
detail.Quantity = item.Quantity.Value;
db.DetailTransactions.Add(detail);
decreaseStock(item.ProductID.Value, item.Quantity.Value);
cartRepository.deleteCart(item.ID);
db.SaveChanges();
}
return(true);
}
public static void insertDetailTransaction(int transactionID, int productID, int quantity)
{
DetailTransaction dt = TransactionFactory.addDetailTransaction(transactionID, productID, quantity);
dbEntity.DetailTransactions.Add(dt);
dbEntity.SaveChanges();
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView2.Rows.Count == 0)
{
MessageBox.Show("No laptop in cart!");
return;
}
for (int i = 0; i < dataGridView2.Rows.Count; i++)
{
HeaderTransaction ht = new HeaderTransaction();
DetailTransaction dtn = new DetailTransaction();
ht.TransactionID = transactionID;
ht.UserID = currentUser;
ht.TransactionDate = DateTime.Now.ToString();
dtn.TransactionID = transactionID;
dtn.LaptopID = dataGridView2.CurrentRow.Cells[0].Value.ToString();
DataGridViewRow row = dataGridView2.Rows[0];
dtn.Quantity = Convert.ToInt32(row.Cells[2].Value.ToString());
de.HeaderTransactions.Add(ht);
de.DetailTransactions.Add(dtn);
de.SaveChanges();
dataGridView2.Rows.RemoveAt(0);
}
MessageBox.Show("Checkout Success");
loadCart();
}
protected DetailTransaction getDATA()
{
DetailTransaction apa = new DetailTransaction();
var detailTran = apa._DetailTransaction;
var headerTran = apa.HeaderTransaction;
List <Model.Header_Transaction> htList = new JavaScriptSerializer().Deserialize <List <Model.Header_Transaction> >(htController.getALLHTLIST());
foreach (Model.Header_Transaction obj in htList)
{
var tempHeader = headerTran.NewRow();
tempHeader["UserName"] = obj.User.Username; //TODO
tempHeader["HeaderTransactionID"] = obj.HeaderTransactionID; //TODO
headerTran.Rows.Add(tempHeader);
List <Model.Detail_Transaction> dtList = new JavaScriptSerializer().Deserialize <List <Model.Detail_Transaction> >(dtController.GetDTBYHEADERID(obj.HeaderTransactionID));
foreach (Model.Detail_Transaction obj2 in dtList)
{
var dtRows = detailTran.NewRow();
dtRows["HeaderTransactionID"] = obj2.HeaderTransactionID;
dtRows["ShoeName"] = obj2.Sho.ShoeName;
dtRows["Quantity"] = obj2.Quantity;
detailTran.Rows.Add(dtRows);
}
}
return(apa);
}
public static Boolean SimpanTransaksi(TransactionViewModel mdl)
{
try
{
//disimpan pertama adalah master
//buat instanisasi mastertransaksi
MasterTransaction masterTransaction = new MasterTransaction();
using (DataContext db = new DataContext())
{
masterTransaction.NoFaktur = mdl.NoFaktur;
masterTransaction.TransactionDate = mdl.TransactionDate;
masterTransaction.Total = mdl.Total;
masterTransaction.CashReturn = mdl.CashReturn;
db.MasterTransaction.Add(masterTransaction);
db.SaveChanges(); //menyimpan ke tabel mastertransaksi
DetailTransaction detailTransaction = new DetailTransaction();
foreach (var item in mdl.TrxDetail)
{
detailTransaction.NoFaktur = mdl.NoFaktur;
detailTransaction.BarangID = item.BarangID;
detailTransaction.Quantity = item.Quantity;
db.DetailTransaction.Add(detailTransaction);
db.SaveChanges(); //menyimpandata
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static DetailTransaction insertDetailTransaction(int headerId, int productId, int quantity)
{
DetailTransaction dt = TransactionFactory.insertDetailTransaction(headerId, productId, quantity);
db.DetailTransactions.Add(dt);
db.SaveChanges();
return(dt);
}
public static DetailTransaction InsertDetailTransaction(int transactionId, int productId, int qty)
{
DetailTransaction dt = TransactionFactory.GetDetailTransaction(transactionId, productId, qty);
db.DetailTransactions.Add(dt);
db.SaveChanges();
return(dt);
}
public static DetailTransaction InitDetail(String TransactionID, String ProductID, int Quantity)
{
DetailTransaction detail = new DetailTransaction();
detail.TransactionID = TransactionID;
detail.ProductID = ProductID;
detail.Quantity = Quantity;
return(detail);
}
public static DetailTransaction CreateNewDetailTrans(int transId, int productId, int quantity)
{
DetailTransaction detail = new DetailTransaction();
detail.TransactionID = transId;
detail.ProductID = productId;
detail.Quantity = quantity;
return(detail);
}
public static void insertDetailTransaction(int TransactionID, int UserID, int Quantity)
{
DetailTransaction dt = DetailTransactionFactory.createDetailTransaction(TransactionID, UserID, Quantity);
Database1Entities db = new Database1Entities();
db.DetailTransactions.Add(dt);
db.SaveChanges();
}
public static DetailTransaction addDetailTransaction(int transactionID, int productID, int quantity)
{
DetailTransaction dt = new DetailTransaction();
dt.TransactionID = transactionID;
dt.ProductID = productID;
dt.Quantity = quantity;
return(dt);
}
public static DetailTransaction createDetailTransaction(int TransactionID, int ProductID, int Quantity)
{
DetailTransaction dt = new DetailTransaction();
dt.TransactionID = TransactionID;
dt.ProductID = ProductID;
dt.Quantity = Quantity;
return(dt);
}
public static DetailTransaction createDetailTransaction(int transactionId, int productId, int qty)
{
DetailTransaction dt = new DetailTransaction();
dt.TransactionID = transactionId;
dt.ProductID = productId;
dt.Quantity = qty;
return(dt);
}
public static DetailTransaction createDetailTransaction(int headerTransactionId, int productId, int quantity)
{
DetailTransaction dt = new DetailTransaction();
dt.HTransactionsId = headerTransactionId;
dt.ProductsId = productId;
dt.Quantity = quantity;
return(dt);
}
public static void Checkout(User user, List <Cart> carts)
{
HeaderTransaction headerTransaction = TransactionFactory.CreateHeader(user.username);
int headerTransactionId = TransactionRepository.InsertHeaderTransaction(headerTransaction).id;
foreach (var item in carts)
{
DetailTransaction detailTransaction = TransactionFactory.CreateDetail(headerTransactionId, item);
TransactionRepository.InsertDetailTransaction(detailTransaction);
}
}
public static DetailTransaction insertDetailTransaction(int headerId, int productId, int quantity)
{
DetailTransaction dt = new DetailTransaction()
{
TransactionID = headerId,
ProductID = productId,
Quantity = quantity
};
return(dt);
}
public DetailTransaction CreateDetailTransaction(int transactionID, int productID, int quantity)
{
DetailTransaction newDT = new DetailTransaction
{
TransactionID = transactionID,
ProductID = productID,
Quantity = quantity
};
return(newDT);
}
public static void checkout(int userId, List <Cart> cartList, int paymentTypeId, DateTime date)
{
HeaderTransaction newHT = TransactionFactory.createHeaderTransaction(userId, paymentTypeId, date);
int htId = TransactionRepository.addHeaderTransaction(newHT).HTransactionsId;
foreach (Cart cart in cartList)
{
DetailTransaction newDT = TransactionFactory.createDetailTransaction(htId, cart.ProductsId, cart.Quantity);
TransactionRepository.addDetailTransaction(newDT);
}
}
public static DetailTransaction GetDetailTransaction(int transactionId, int productId, int qty)
{
DetailTransaction dt = new DetailTransaction()
{
TransactionId = transactionId,
ProductId = productId,
Quantity = qty
};
return(dt);
}
public static DetailTransaction CreateDetailTransaction(int transactionid, int productid, int quantity)
{
DetailTransaction newDetailTransaction = new DetailTransaction()
{
TransactionId = transactionid,
ProductId = productid,
Quantity = quantity,
};
return(newDetailTransaction);
}
public static DetailTransaction CreateDetail(int headerTransactionId, Cart cart)
{
DetailTransaction detailTransaction = new DetailTransaction()
{
trans_id = headerTransactionId,
product_id = cart.Product.id,
price = cart.Product.price,
quantity = cart.Quantity
};
return(detailTransaction);
}
//Function to store Detail Transaction
private void storeDetailTransaction(string ht, string shoeid, int qty)
{
DB = Db4oFactory.OpenFile("Detail Transaction.yap");
DetailTransaction dt = new DetailTransaction()
{
ShoeID = shoeid,
HeaderTransactionID = ht,
Quantity = qty
};
DB.Store(dt);
DB.Close();
}
public bool Insert(TransactionParam transactionParam)
{
var get = new DetailTransaction(transactionParam);
_context.DetailTransactions.Add(get);
var result = _context.SaveChanges();
if (result > 0)
{
status = true;
}
return(status);
}
public static DetailTransaction InsertDetailTransaction(DetailTransaction detailTransaction)
{
using (WatchShopEntities db = new WatchShopEntities())
{
db.DetailTransaction.Add(detailTransaction);
db.SaveChanges();
int productId = detailTransaction.product_id;
int quantity = detailTransaction.quantity.Value;
ProductRepository.DecreaseStock(productId, quantity);
return(detailTransaction);
}
}
public static void checkout(int userid, int paymentTypeid, List <Cart> carts)
{
HeaderTransaction headerTransaction = TransactionFactory.headerTransaction(userid, paymentTypeid, DateTime.Now);
int TrID = TransactionRepository.addHT(headerTransaction).Id;
foreach (Cart i in carts)
{
DetailTransaction detailTransaction = TransactionFactory.detailTransaction(TrID, i.ProductID, i.Quantity);
TransactionRepository.addDT(detailTransaction);
ProductRepository.decreaseproduct(i.ProductID, i.Quantity);
}
CartRepository.deleteCarts(carts);
}
private void CityGridRegistration()
{
var cityDetail = new DetailTransaction<City>(CityDataSource.CityDataSource.GetCitys().Take(100).ToList());
this.DetailContainer["PagingCityGrid"] = cityDetail;
}
