public bool addInvoice(INVOICE invoice, List <INVOICE_ITEM> itemList)
{
try
{
UShopDB.INVOICEs.InsertOnSubmit(invoice);
UShopDB.SubmitChanges();
invoice.INVOICE_CODE = getCODE("INV", invoice.INVOICE_ID);
if (itemList != null && itemList.Count > 0)
{
UShopDB.INVOICE_ITEMs.InsertAllOnSubmit(itemList);
UShopDB.SubmitChanges();
double totalDiscount = 0;
foreach (var item in itemList)
{
item.INVOICE_ITEM_CODE = getCODE("INVI", item.INVOICE_ITEM_ID);
item.INVOICE_ID = invoice.INVOICE_ID;
totalDiscount += (double)item.DISCOUNT;
//updateProductSize((int)item.PRODUCT_ID, item.SIZE,0 -(int)item.QUANTITY);
}
invoice.TOTAL_SALE = totalDiscount;
}
UShopDB.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
public void deleteProductSize(string id, string size)
{
PRODUCT_SIZE obj = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == Convert.ToInt32(id) && o.SIZE.Equals(size)).SingleOrDefault();
UShopDB.PRODUCT_SIZEs.DeleteOnSubmit(obj);
UShopDB.SubmitChanges();
}
public void deleteSupplier(string id)
{
SUPPLIER obj = UShopDB.SUPPLIERs.Where(o => o.SUPPLIER_ID == Convert.ToInt32(id)).SingleOrDefault();
obj.RECORD_STATUS = "D";
UShopDB.SubmitChanges();
}
public bool updateAppointment(APPOINTMENT updateApp)
{
bool ret = false;
try
{
var result = UShopDB.APPOINTMENTs.Where(o => o.APP_ID == updateApp.APP_ID);
APPOINTMENT app = result.SingleOrDefault();
app.APP_DATE = updateApp.APP_DATE;
app.CREATED_DATE = updateApp.CREATED_DATE;
app.CUS_ID = updateApp.CUS_ID;
app.DESCRIPTION = updateApp.DESCRIPTION;
app.NOTE = updateApp.NOTE;
app.PREPARER_ID = updateApp.PREPARER_ID;
app.RECORD_STATUS = updateApp.RECORD_STATUS;
UShopDB.SubmitChanges();
ret = true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(ret);
}
public void updateProductSize(PRODUCT_SIZE product)
{
PRODUCT_SIZE obj = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == product.PRODUCT_ID && o.SIZE.Equals(product.SIZE)).SingleOrDefault();
obj.IN_STOCK_QUANTITY = product.IN_STOCK_QUANTITY;
obj.PRODUCT_ID = product.PRODUCT_ID;
obj.SIZE = product.SIZE;
UShopDB.SubmitChanges();
}
public void add(RECEIPT_NOTE obj, DataTable dtItems)
{
UShopDB.RECEIPT_NOTEs.InsertOnSubmit(obj);
UShopDB.SubmitChanges();
obj.RN_CODE = getCODE("RCN", obj.RN_ID);
List <RECEIPT_NOTE_ITEM> lst = new List <RECEIPT_NOTE_ITEM>();
foreach (DataRow r in dtItems.Rows)
{
RECEIPT_NOTE_ITEM item = new RECEIPT_NOTE_ITEM();
item.RN_ID = obj.RN_ID;
item.PRODUCT_ID = Int32.Parse(r[0].ToString().Substring(r[0].ToString().IndexOf('0'), r[0].ToString().Length - r[0].ToString().IndexOf('0')));
item.QUANTITY_STOCK_S = Int32.Parse(r[2].ToString());
item.QUANTITY_VOUCHER_S = Int32.Parse(r[3].ToString());
item.SIZE = r[4].ToString();
item.PRICE = Int32.Parse(r[5].ToString());
item.AMOUNT = Int32.Parse(r[6].ToString());
item.RECORD_STATUS = "A";
lst.Add(item);
//
foreach (RECEIPT_NOTE_ITEM i in lst)
{
if (UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID.Equals(i.PRODUCT_ID) && o.SIZE.Equals(i.SIZE)).Count() > 0)
{
PRODUCT_SIZE p = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID.Equals(i.PRODUCT_ID) && o.SIZE.Equals(i.SIZE)).First();
p.IN_STOCK_QUANTITY += item.QUANTITY_STOCK_S;
}
else
{
PRODUCT_SIZE p = new PRODUCT_SIZE();
p.PRODUCT_ID = i.PRODUCT_ID ?? 1;
p.SIZE = i.SIZE;
p.IN_STOCK_QUANTITY = item.QUANTITY_STOCK_S;
UShopDB.PRODUCT_SIZEs.InsertOnSubmit(p);
}
}
}
UShopDB.RECEIPT_NOTE_ITEMs.InsertAllOnSubmit(lst);
UShopDB.SubmitChanges();
foreach (RECEIPT_NOTE_ITEM i in UShopDB.RECEIPT_NOTE_ITEMs.Where(o => o.RN_ID == obj.RN_ID))
{
i.RN_ITEM_CODE = getCODE("RIT", i.RN_ITEM_ID);
}
UShopDB.SubmitChanges();
}
public void add(RECEIPT_NOTE obj, DataTable dtItems)
{
UShopDB.RECEIPT_NOTEs.InsertOnSubmit(obj);
UShopDB.SubmitChanges();
obj.RN_CODE = getCODE("RCN", obj.RN_ID);
List <RECEIPT_NOTE_ITEM> lst = new List <RECEIPT_NOTE_ITEM>();
foreach (DataRow r in dtItems.Rows)
{
RECEIPT_NOTE_ITEM item = new RECEIPT_NOTE_ITEM();
item.RN_ID = obj.RN_ID;
item.PRODUCT_ID = Int32.Parse(r[0].ToString().Substring(r[0].ToString().IndexOf('0'), 5));
item.QUANTITY_STOCK_S = Int32.Parse(r[2].ToString());
item.QUANTITY_VOUCHER_S = Int32.Parse(r[3].ToString());
item.QUANTITY_STOCK_M = Int32.Parse(r[4].ToString());
item.QUANTITY_VOUCHER_M = Int32.Parse(r[5].ToString());
item.QUANTITY_STOCK_L = Int32.Parse(r[6].ToString());
item.QUANTITY_VOUCHER_L = Int32.Parse(r[7].ToString());
item.QUANTITY_STOCK_XL = Int32.Parse(r[8].ToString());
item.QUANTITY_VOUCHER_XL = Int32.Parse(r[9].ToString());
item.QUANTITY_STOCK_XXL = Int32.Parse(r[10].ToString());
item.QUANTITY_VOUCHER_XXL = Int32.Parse(r[11].ToString());
item.TOTAL_STOCK = Int32.Parse(r[12].ToString());
item.TOTAL_VOUCHER = Int32.Parse(r[13].ToString());
item.PRICE = Int32.Parse(r[14].ToString());
item.AMOUNT = Int32.Parse(r[15].ToString());
item.RECORD_STATUS = "A";
lst.Add(item);
foreach (PRODUCT p in UShopDB.PRODUCTs.Where(o => o.PRODUCT_ID == item.PRODUCT_ID))
{
p.SIZE_S += item.QUANTITY_STOCK_S;
p.SIZE_M += item.QUANTITY_STOCK_M;
p.SIZE_L += item.QUANTITY_STOCK_L;
p.SIZE_XL += item.QUANTITY_STOCK_XL;
p.SIZE_XXL += item.QUANTITY_STOCK_XXL;
}
}
UShopDB.RECEIPT_NOTE_ITEMs.InsertAllOnSubmit(lst);
UShopDB.SubmitChanges();
foreach (RECEIPT_NOTE_ITEM i in UShopDB.RECEIPT_NOTE_ITEMs.Where(o => o.RN_ID == obj.RN_ID))
{
i.RN_ITEM_CODE = getCODE("RIT", i.RN_ITEM_ID);
}
UShopDB.SubmitChanges();
}
public void updateSupplier(SUPPLIER supplier)
{
SUPPLIER obj = UShopDB.SUPPLIERs.Where(o => o.SUPPLIER_ID == Convert.ToInt32(supplier.SUPPLIER_ID)).SingleOrDefault();
obj.SUPPLIER_NAME = supplier.SUPPLIER_NAME;
obj.TAX_CODE = supplier.TAX_CODE;
obj.PHONE = supplier.PHONE;
obj.ADDRESS = supplier.ADDRESS;
UShopDB.SubmitChanges();
}
public void updateUShop(SUPPLIER obj)
{
getUShop();
SUPPLIER ushop = UShopDB.SUPPLIERs.Where(o => o.RECORD_STATUS.Equals("U")).First();
ushop.TAX_CODE = obj.TAX_CODE;
ushop.ADDRESS = obj.ADDRESS;
ushop.SUPPLIER_NAME = obj.SUPPLIER_NAME;
ushop.PHONE = obj.PHONE;
UShopDB.SubmitChanges();
}
public void addAccount(ACCOUNT obj)
{
try
{
UShopDB.ACCOUNTs.InsertOnSubmit(obj);
UShopDB.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception();
}
}
public void addReceiptNote(RECEIPT_NOTE obj)
{
try
{
UShopDB.RECEIPT_NOTEs.InsertOnSubmit(obj);
UShopDB.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception();
}
}
public void deleteProduct(string id)
{
PRODUCT obj = UShopDB.PRODUCTs.Where(o => o.PRODUCT_ID == Convert.ToInt32(id)).SingleOrDefault();
obj.RECORD_STATUS = "D";
foreach (PRODUCT_SIZE z in UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == Convert.ToInt32(id)))
{
UShopDB.PRODUCT_SIZEs.DeleteOnSubmit(z);
}
UShopDB.SubmitChanges();
}
public void addSupplier(SUPPLIER obj)
{
try
{
UShopDB.SUPPLIERs.InsertOnSubmit(obj);
UShopDB.SubmitChanges();
obj.SUPPLIER_CODE = getCODE("SUP", obj.SUPPLIER_ID);
UShopDB.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception();
}
}
public void addProduct(PRODUCT obj)
{
try
{
UShopDB.PRODUCTs.InsertOnSubmit(obj);
UShopDB.SubmitChanges();
obj.PRODUCT_CODE = getCODE("PRO", obj.PRODUCT_ID);
UShopDB.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception();
}
}
bool IAccount.deleteAccount(string code)
{
bool ret = false;
try
{
var result = UShopDB.ACCOUNTs.Where(o => o.ACC_CODE.Equals(code));
ACCOUNT acc = result.SingleOrDefault();
acc.RECORD_STATUS = ((char)RECORD_STATUS.INACTIVE) + "";
UShopDB.SubmitChanges();
ret = true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(ret);
}
public bool deleteAppointment(string code)
{
bool ret = false;
try
{
var result = UShopDB.APPOINTMENTs.Where(o => o.APP_CODE.Equals(code));
APPOINTMENT app = result.SingleOrDefault();
app.RECORD_STATUS = ((char)RECORD_STATUS.INACTIVE) + "";
UShopDB.SubmitChanges();
ret = true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(ret);
}
public bool addAppointment(APPOINTMENT app)
{
try
{
UShopDB.APPOINTMENTs.InsertOnSubmit(app);
UShopDB.SubmitChanges();
app.APP_CODE = getCODE("APP", app.APP_ID);
UShopDB.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
private bool updateProductSize(int productId, string size, int deltaQuantity)
{
PRODUCT_SIZE prosize = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == productId && o.SIZE.Equals(size)).SingleOrDefault();
if (prosize != null)
{
if (prosize.IN_STOCK_QUANTITY == 0)
{
throw new Exception("instock quantity is zero but still has an invoice item ");
}
prosize.IN_STOCK_QUANTITY = prosize.IN_STOCK_QUANTITY + deltaQuantity;
UShopDB.SubmitChanges();
return(true);
}
return(false);
}
public bool addAccount(ACCOUNT obj)
{
try
{
UShopDB.ACCOUNTs.InsertOnSubmit(obj);
UShopDB.SubmitChanges();
return(true);
}
catch (Exception ex)
{
//wtf ???
//throw new Exception();
Console.WriteLine(ex.Message);
}
return(false);
}
public SUPPLIER getUShop()
{
int count = UShopDB.SUPPLIERs.Where(o => o.RECORD_STATUS.Equals("U")).Count();
if (count == 0)
{
SUPPLIER ushop = new SUPPLIER();
ushop.TAX_CODE = "0000";
ushop.ADDRESS = "Quận 3, TP HCM";
ushop.SUPPLIER_NAME = "UShop";
ushop.RECORD_STATUS = "U";
ushop.PHONE = "0975862516";
UShopDB.SUPPLIERs.InsertOnSubmit(ushop);
UShopDB.SubmitChanges();
ushop.SUPPLIER_CODE = getCODE("SUP", ushop.SUPPLIER_ID);
UShopDB.SubmitChanges();
}
return(UShopDB.SUPPLIERs.Where(o => o.RECORD_STATUS.Equals("U")).First());
}
