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);
}
