public bool InsertProduct(ProductEntity product, List <string> dataPhoto)
{
string sql = "sp_product_INSERT";
//string sql_productsup = "sp_PRODUCTSUPPLIER_INSERT";
string retID = "";
int i = 1;
object[] objProduct = { "@Description", product.Description, "@Waranty", product.Waranty, "@ClrID", product.ClrID, "@TypeProductID", product.TypeProductID, "@BrandID", product.BrandID, "@ReorderPoint", product.ReorderPoint, "@Price", product.Price, "@SerialStatus", product.SerialStatus };
using (TransactionScope ts = new TransactionScope())
{
try
{
retID = Db.InsertReturnID(sql, objProduct);
//object[] ojbProSup = { "@PrdID", retID, "@SupID", product.SupID };
//try { Db.Insert(sql_productsup, ojbProSup); }
//catch { return false; }
string sql_path = "sp_photo_INSERT";
foreach (var ls in dataPhoto)
{
object[] objPh = { "@PhotoID", i++, "@PrdID", retID, "@Photo", ls };
try { Db.Insert(sql_path, objPh); }
catch { return(false); }
}
ts.Complete();
return(true);
}
catch { return(false); }
}
}
public bool InsertPROMOTION(PROMOTION PROMOTION)
{
string sql = @"sp_promotion_INSERT";
string sql_dta = @"sp_promotionproduct_INSERT";
object[] obj = { "@ProMStartDate", PROMOTION.ProMStartDate, "@ProMEndDate", PROMOTION.ProMEndDate, "@Discount", PROMOTION.Discount };
using (TransactionScope ts = new TransactionScope())
{
string retID = Db.InsertReturnID(sql, obj);
if (retID != null)
{
foreach (var ls in PROMOTION.PRODUCT)
{
object[] objs = { "@PrdID", ls.PrdID, "@ProMID", retID };
try
{
Db.Insert(sql_dta, objs);
}
catch
{
return(false);
}
}
ts.Complete();
return(true);
}
else
{
return(false);
}
}
}
public bool InsertOffer(OfferModel[] off, OfferDetailModel[] list)
{
string sql = @"[sp_offer_INSERT]";
string sql_Detail = @"[sp_offerDetail_INSERT]";
int i = 0;
string retID = "";
using (TransactionScope ts = new TransactionScope())
{
foreach (var ls in list)
{
if (ls.OfdNo == 1)
{
//สร้างหัว
object[] h_obj = { "@EmpID", off[i].EmpID, "@SupID", off[i].SupID, "@OffDate", off[i].OffDate };
retID = Db.InsertReturnID(sql, h_obj);
}
object[] obj = { "@OffID", retID, "@OfdNo", ls.OfdNo, "@PrdID", ls.PrdID, "@AmountPost", ls.AmountPost, "@AmountApprove", ls.AmountApprove, "@Cost", ls.Cost };
try
{
Db.Insert(sql_Detail, obj);
i++;
}
catch
{
return(false);
}
}
ts.Complete();
return(true);
}
}
public bool InsertPosandRole(PositionsEntity position, PosInRoleDetailDto[] list, string UPDATEDATA)
{
string sql = @"sp_position_INSERT";
string sql_role = @"sp_PosAndRole_INSERT";
string retID = "";
if (UPDATEDATA.Equals("INSERT"))
{
using (TransactionScope ts = new TransactionScope())
{
retID = Db.InsertReturnID(sql, Take(position));
if (retID != null)
{
foreach (var ls in list)
{
object[] obj = { "@RoleID", ls.RoleID, "@PosID", retID };
try
{
Db.Insert(sql_role, obj);
}
catch
{
return(false);
}
}
ts.Complete();
return(true);
}
else
{
return(false);
}
}
}
else if (UPDATEDATA.Equals("UPDATE"))
{
string sql_upd = @"sp_PosAndRole_UPDATE";
using (TransactionScope ts = new TransactionScope())
{
DeletePosition(position.PosID);
{
foreach (var ls in list)
{
object[] obj = { "@RoleID", ls.RoleID, "@PosID", position.PosID };
Db.Insert(sql_upd, obj);
}
ts.Complete();
return(true);
}
}
}
return(false);
}
public string InsertDeliver(DELIVER data)
{
string sql = "[sp_deliver_INSERT]";
string retID = "";
object[] obj = { "@EmpId", data.EmpID, "@SlpID", data.SlpID, "@DlvDate", data.DlvDate, "@DlvSerial", data.DlvSerial };
using (TransactionScope ts = new TransactionScope())
{
try { retID = Db.InsertReturnID(sql, obj); ts.Complete(); return(retID); }
catch { return(retID = ""); }
}
}
public string InsertOrder(OrderEntity ord, Models.OrderDetailModel[] list)
{
string sql = @"[sp_order_INSERT]";
string sql_Detail = @"[sp_orderproduct_dta_INSERT]";
// update Offer status => Approve to Purchase
string sql_UPDATE = @"sp_orderANDoffer_UPDATE";
var check = "";
string retID = "";
object[] objOrd = { "@SupID", ord.SupID, "@EmpID", ord.EmpID, "@OrdDate", ord.OrdDate, "@TotalCost", ord.TotalCost };
using (TransactionScope ts = new TransactionScope())
{
try
{
retID = Db.InsertReturnID(sql, objOrd);
if (retID != null)
{
foreach (var ls in list)
{
object[] obj = { "@OrdID", retID, "@OrdNo", ls.OrdNo, "@OffID", ls.OffID, "@OfdNo", ls.OfdNo, "@OrdAmount", ls.AmountApprove };
try
{
Db.Insert(sql_Detail, obj);
if (!check.Equals(ls.OffID))
{
object[] objU = { "@OffID", ls.OffID };
check = ls.OffID;
Db.Update(sql_UPDATE, objU);
}
}
catch
{
return(retID);
}
}
ts.Complete();
return(retID);
}
else
{
return(retID);
}
}
catch
{
return(retID);
}
}
}
public bool InsertMember(MEMBER member)
{
string sql = @"sp_member_INSERT";
string sql_phone = @"sp_memAndPhone_INSERT";
string retID = "";
using (TransactionScope ts = new TransactionScope())
{
object[] obj_mem = { "@MFname", member.MFname, "@MLname", member.MLname, "@MAddress", member.MAddress, "@MSex", member.MSex, "@MEmail", member.MEmail, "@MPassword", member.MPassword };
retID = Db.InsertReturnID(sql, obj_mem);
if (retID != null)
{
if (member.MEMBER_PHONE.Count == 0)
{
return(false);
}
else
{
foreach (var ls in member.MEMBER_PHONE)
{
object[] obj = { "@MemID", retID, "@Phone", ls.Phone };
try
{
Db.Insert(sql_phone, obj);
}
catch
{
return(false);
}
}
}
ts.Complete();
return(true);
}
else
{
return(false);
}
}
}
public bool InsertSellProduct(SELLPRODUCT sellpd)
{
string sql = @"sp_sellproduct_INSERT";
string sql_dta = @"sp_sellproductDTA_INSERT";
string sql_reserve = @"sp_checkout_reserve";
string retID = "";
using (TransactionScope ts = new TransactionScope())
{
object[] obj = { "@MemID", sellpd.MemID, "@SlpDate", sellpd.SlpDate, "@FnameRec", sellpd.FnameRec,
"@LnameRec", sellpd.LnameRec, "@AdressRec", sellpd.AdressRec,
"@SlpStatus", "ยังไม่ได้ชำระเงิน", "@SlpSum", sellpd.SlpSum };
retID = Db.InsertReturnID(sql, obj);
if (retID != null)
{
int Num = 0;
foreach (var ls in sellpd.SELLPRODUCT_DTA)
{
object[] obj_dta = { "@SlpID", retID, "@SlpNo", Num++, "@PrdID", ls.PrdID,
"@SpdAmount", ls.SpdAmount, "@SpdPrice", ls.SpdPrice, "@Discount", ls.Discount };
object[] obj_reserve = { "@PrdID", ls.PrdID, "@Amount", ls.SpdAmount };
try
{
Db.Insert(sql_dta, obj_dta);
Db.Update(sql_reserve, obj_reserve);
}
catch
{
return(false);
}
}
ts.Complete();
return(true);
}
else
{
return(false);
}
}
}
public bool InsertSupAndPhone(SupplierEntity Supplier, ICollection <Models.SUPPLIER_PHONE> list)
{
string sql = @"sp_supplier_INSERT";
string sql_phone = @"sp_supAndPhone_INSERT";
using (TransactionScope ts = new TransactionScope())
{
string retID = Db.InsertReturnID(sql, Take(Supplier));
if (retID != null)
{
if (list.Count() == 0)
{
object[] obj = { "@PhoneNumber", "XXXXXXXXXX" };
Db.Insert(sql_phone, obj);
}
else
{
foreach (var ls in list)
{
object[] obj = { "@SupID", retID, "@PhoneNumber", ls.Phone };
try
{
Db.Insert(sql_phone, obj);
}
catch
{
return(false);
}
}
}
ts.Complete();
return(true);
}
else
{
return(false);
}
}
}
public bool InsertReceive(ReceiveModel rec, List <ReceiveDetailModel> list, List <SERIAL> serial)
{
string sql = @"[sp_receiveorder_INSERT]";
string sql_Detail = @"[sp_receiveorder_dta_INSERT]";
string sql_Lot = @"[sp_productlot_INSERT]";
string sql_serial = @"[sp_serial_INSERT]";
// update Offer status => Approve to Purchase
// string sql_UPDATE = @"sp_orderANDoffer_UPDATE";
string retID = "";
string tempID = "";
object[] objRec = { "@EmpID", rec.EmpID, "@RecODate", rec.RecODate };
using (TransactionScope ts = new TransactionScope())
{
try
{
retID = Db.InsertReturnID(sql, objRec);
if (retID != null)
{
foreach (var ls in list)
{
object[] obj = { "@RecOID", retID, "@RecONo", ls.RecONo, "@OrdID", ls.OrdID, "@OrdNo", ls.OrdNo, "@AmountRec", ls.AmountRec };
object[] obj_lot = { "@LotNo", tempID, "@PrdID", ls.PrdID, "@RecOID", retID, "@RecONo", ls.RecONo, "@AmountRec", ls.AmountRec, "@Amount", ls.AmountRec, "@Price", ls.Cost, "@LotDate", System.DateTime.Now.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture) };
//object[] obj_stock =
try
{
Db.Insert(sql_Detail, obj);
tempID = Db.InsertReturnID(sql_Lot, obj_lot);
}
catch
{
return(false);
}
}
foreach (var ls in serial)
{
object[] obj_serial = { "@LotNo", tempID, "@PrdID", ls.PrdID, "@SrlID", ls.SrlID };
try
{
Db.Insert(sql_serial, obj_serial);
}
catch
{
return(false);
}
}
ts.Complete();
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool InsertEmpAndPhone(EmployeeEntity employee, ICollection <EMPLOYEE_PHONE> list, string UPDATEDATA)
{
string sql = @"sp_employee_INSERT";
string sql_phone = @"sp_empAndPhone_INSERT";
string retID = "";
if (UPDATEDATA.Equals("INSERT"))
{
using (TransactionScope ts = new TransactionScope())
{
retID = Db.InsertReturnID(sql, Take(employee));
if (retID != null)
{
if (list.Count() == 0)
{
object[] obj = { "@PhoneNumber", "XXXXXXXXXX" };
Db.Insert(sql_phone, obj);
}
else
{
foreach (var ls in list)
{
object[] obj = { "@EmpID", retID, "@PhoneNumber", ls.Phone };
try
{
Db.Insert(sql_phone, obj);
}
catch
{
return(false);
}
}
}
ts.Complete();
return(true);
}
else
{
return(false);
}
}
}
else if (UPDATEDATA.Equals("UPDATE"))
{
string sql_emp = @"sp_employee_UPDATE";
string sql_upd = @"sp_empAndPhone_UPDATE";
string sql_del = @"sp_empAndPhone_DELETE";
using (TransactionScope ts = new TransactionScope())
{// UPDATE พนักงาน
Db.Update(sql_emp, Take2(employee));
// ลบ และ สร้าง เบอร์ใหม่ เพื่อ อัพเดท
object[] del = { "@EmpID", employee.EmpID };
Db.Delete(sql_del, del);
{
foreach (var ls in list)
{
object[] obj = { "@EmpID", employee.EmpID, "@Phone", ls.Phone };
try { Db.Insert(sql_upd, obj); }
catch { return(false); }
}
ts.Complete();
return(true);
}
}
}
return(false);
}
