public int STOCK_TRANSFER_UpdateById(STOCK_TRANSFER obj, string ID)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "STOCK_TRANSFER_UpdateById",
ID,
obj.RefDate,
obj.Ref_OrgNo,
obj.RefType,
obj.FromStock_ID,
obj.Sender_ID,
obj.ToStock_ID,
obj.Receiver_ID,
obj.Barcode,
obj.Amount,
obj.IsReview,
obj.User_ID,
obj.IsClose,
obj.Description,
obj.Active
));
}
catch
{
//throw ex;
return(-1);
}
}
public List <STOCK_TRANSFER> STOCK_TRANSFER_Search(STOCK_TRANSFER obj)
{
DataTable dt = new DataTable();
try
{
DataProvider.FillDataTable(DataProvider.ConnectionString, dt, "STOCK_TRANSFER_Search",
obj.RefDate,
obj.Ref_OrgNo,
obj.RefType,
obj.Barcode,
obj.Amount,
obj.IsReview,
obj.IsClose,
obj.Description
);
return(MapSTOCK_TRANSFER(dt));
}
catch (Exception ex)
{
throw ex;
}
}
private List <STOCK_TRANSFER> MapSTOCK_TRANSFER(DataTable dt)
{
List <STOCK_TRANSFER> rs = new List <STOCK_TRANSFER>();
for (int i = 0; i < dt.Rows.Count; i++)
{
STOCK_TRANSFER obj = new STOCK_TRANSFER();
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("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("FromStock_ID"))
{
obj.FromStock_ID = dt.Rows[i]["FromStock_ID"].ToString();
}
if (dt.Columns.Contains("Sender_ID"))
{
obj.Sender_ID = dt.Rows[i]["Sender_ID"].ToString();
}
if (dt.Columns.Contains("ToStock_ID"))
{
obj.ToStock_ID = dt.Rows[i]["ToStock_ID"].ToString();
}
if (dt.Columns.Contains("Receiver_ID"))
{
obj.Receiver_ID = dt.Rows[i]["Receiver_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("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("Barcode"))
{
obj.Barcode = dt.Rows[i]["Barcode"].ToString();
}
if (dt.Columns.Contains("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("IsReview"))
{
obj.IsReview = bool.Parse(dt.Rows[i]["IsReview"].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());
}
rs.Add(obj);
}
return(rs);
}
