public List <STOCK_OUTWARD> STOCK_OUTWARD_Search(STOCK_OUTWARD obj) { DataTable dt = new DataTable(); try { DataProvider.FillDataTable(DataProvider.ConnectionString, dt, "STOCK_OUTWARD_Search", obj.RefDate, obj.Ref_OrgNo, obj.RefType, obj.Barcode, obj.CustomerName, obj.CustomerAddress, obj.Contact, obj.Reason, obj.Payment, obj.ExchangeRate, obj.Amount, obj.FAmount, obj.Discount, obj.Charge, obj.Cost, obj.Profit, obj.IsClose, obj.Description ); return(MapSTOCK_OUTWARD(dt)); } catch (Exception ex) { throw ex; } }
public int STOCK_OUTWARD_Update(STOCK_OUTWARD obj, string ID) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "STOCK_OUTWARD_Update", ID, obj.RefDate, obj.Ref_OrgNo, obj.RefType, obj.RefStatus, obj.PaymentMethod, obj.TermID, obj.PaymentDate, obj.DeliveryDate, obj.Barcode, obj.Department_ID, obj.Employee_ID, obj.Stock_ID, obj.Branch_ID, obj.Contract_ID, obj.Customer_ID, obj.CustomerName, obj.CustomerAddress, obj.Contact, obj.Reason, obj.Payment, obj.Currency_ID, obj.ExchangeRate, obj.Vat, obj.VatAmount, obj.Amount, obj.FAmount, obj.DiscountDate, obj.DiscountRate, obj.Discount, obj.OtherDiscount, obj.Charge, obj.Cost, obj.Profit, obj.User_ID, obj.IsClose, obj.Sorted, obj.Description, obj.Active )); } catch { //throw ex; return(-1); } }
public void STOCK_OUTWARD_Insert_Test(STOCK_OUTWARD obj) { try { DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "STOCK_OUTWARD_Insert_Test", obj.ID, obj.RefDate, obj.Ref_OrgNo, obj.RefType, obj.RefStatus, obj.PaymentMethod, obj.TermID, obj.PaymentDate, obj.DeliveryDate, obj.Barcode, obj.Department_ID, obj.Employee_ID, obj.Stock_ID, obj.Branch_ID, obj.Contract_ID, obj.Customer_ID, obj.CustomerName, obj.CustomerAddress, obj.Contact, obj.Reason, obj.Payment, obj.Currency_ID, obj.ExchangeRate, obj.Vat, obj.VatAmount, obj.Amount, obj.FAmount, obj.DiscountDate, obj.DiscountRate, obj.Discount, obj.OtherDiscount, obj.Charge, obj.Cost, obj.Profit, obj.User_ID, obj.IsClose, obj.Sorted, obj.Description, obj.Active ); } catch (Exception ex) { throw ex; //return -1; } }
private List <STOCK_OUTWARD> MapSTOCK_OUTWARD(DataTable dt) { List <STOCK_OUTWARD> rs = new List <STOCK_OUTWARD>(); for (int i = 0; i < dt.Rows.Count; i++) { STOCK_OUTWARD obj = new STOCK_OUTWARD(); if (dt.Columns.Contains("ID")) { obj.ID = dt.Rows[i]["ID"].ToString(); } if (dt.Columns.Contains("RefDate")) { obj.RefDate = DateTime.Parse(dt.Rows[i]["RefDate"].ToString()); } if (dt.Columns.Contains("Ref_OrgNo")) { obj.Ref_OrgNo = dt.Rows[i]["Ref_OrgNo"].ToString(); } if (dt.Columns.Contains("RefType")) { obj.RefType = int.Parse(dt.Rows[i]["RefType"].ToString()); } if (dt.Columns.Contains("RefStatus")) { obj.RefStatus = int.Parse(dt.Rows[i]["RefStatus"].ToString()); } if (dt.Columns.Contains("PaymentMethod")) { obj.PaymentMethod = new Guid(dt.Rows[i]["PaymentMethod"].ToString()); } if (dt.Columns.Contains("TermID")) { obj.TermID = dt.Rows[i]["TermID"].ToString(); } if (dt.Columns.Contains("PaymentDate")) { obj.PaymentDate = DateTime.Parse(dt.Rows[i]["PaymentDate"].ToString()); } if (dt.Columns.Contains("DeliveryDate")) { obj.DeliveryDate = DateTime.Parse(dt.Rows[i]["DeliveryDate"].ToString()); } if (dt.Columns.Contains("Barcode")) { obj.Barcode = dt.Rows[i]["Barcode"].ToString(); } if (dt.Columns.Contains("Department_ID")) { obj.Department_ID = dt.Rows[i]["Department_ID"].ToString(); } if (dt.Columns.Contains("Employee_ID")) { obj.Employee_ID = dt.Rows[i]["Employee_ID"].ToString(); } if (dt.Columns.Contains("Stock_ID")) { obj.Stock_ID = dt.Rows[i]["Stock_ID"].ToString(); } if (dt.Columns.Contains("Branch_ID")) { obj.Branch_ID = dt.Rows[i]["Branch_ID"].ToString(); } if (dt.Columns.Contains("Contract_ID")) { obj.Contract_ID = dt.Rows[i]["Contract_ID"].ToString(); } if (dt.Columns.Contains("Customer_ID")) { obj.Customer_ID = dt.Rows[i]["Customer_ID"].ToString(); } if (dt.Columns.Contains("CustomerName")) { obj.CustomerName = dt.Rows[i]["CustomerName"].ToString(); } if (dt.Columns.Contains("CustomerAddress")) { obj.CustomerAddress = dt.Rows[i]["CustomerAddress"].ToString(); } if (dt.Columns.Contains("Contact")) { obj.Contact = dt.Rows[i]["Contact"].ToString(); } if (dt.Columns.Contains("Reason")) { obj.Reason = dt.Rows[i]["Reason"].ToString(); } if (dt.Columns.Contains("Payment")) { obj.Payment = int.Parse(dt.Rows[i]["Payment"].ToString()); } if (dt.Columns.Contains("Currency_ID")) { obj.Currency_ID = dt.Rows[i]["Currency_ID"].ToString(); } if (dt.Columns.Contains("ExchangeRate")) { obj.ExchangeRate = double.Parse(dt.Rows[i]["ExchangeRate"].ToString()); } if (dt.Columns.Contains("Vat")) { obj.Vat = int.Parse(dt.Rows[i]["Vat"].ToString()); } if (dt.Columns.Contains("VatAmount")) { obj.VatAmount = double.Parse(dt.Rows[i]["VatAmount"].ToString()); } if (dt.Columns.Contains("Amount")) { obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString()); } if (dt.Columns.Contains("FAmount")) { obj.FAmount = double.Parse(dt.Rows[i]["FAmount"].ToString()); } if (dt.Columns.Contains("DiscountDate")) { obj.DiscountDate = DateTime.Parse(dt.Rows[i]["DiscountDate"].ToString()); } if (dt.Columns.Contains("DiscountRate")) { obj.DiscountRate = double.Parse(dt.Rows[i]["DiscountRate"].ToString()); } if (dt.Columns.Contains("Discount")) { obj.Discount = double.Parse(dt.Rows[i]["Discount"].ToString()); } if (dt.Columns.Contains("OtherDiscount")) { obj.OtherDiscount = double.Parse(dt.Rows[i]["OtherDiscount"].ToString()); } if (dt.Columns.Contains("Charge")) { obj.Charge = double.Parse(dt.Rows[i]["Charge"].ToString()); } if (dt.Columns.Contains("Cost")) { obj.Cost = double.Parse(dt.Rows[i]["Cost"].ToString()); } if (dt.Columns.Contains("Profit")) { obj.Profit = double.Parse(dt.Rows[i]["Profit"].ToString()); } if (dt.Columns.Contains("User_ID")) { obj.User_ID = dt.Rows[i]["User_ID"].ToString(); } if (dt.Columns.Contains("IsClose")) { obj.IsClose = bool.Parse(dt.Rows[i]["IsClose"].ToString()); } if (dt.Columns.Contains("Sorted")) { obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString()); } if (dt.Columns.Contains("Description")) { obj.Description = dt.Rows[i]["Description"].ToString(); } if (dt.Columns.Contains("Active")) { obj.Active = bool.Parse(dt.Rows[i]["Active"].ToString()); } //if (dt.Columns.Contains("Timestamp")) //obj.Timestamp = DateTime.Parse(dt.Rows[i]["Timestamp"].ToString()); rs.Add(obj); } return(rs); }