protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
PURCHASE_ORDER_DETAIL theEntity = (PURCHASE_ORDER_DETAIL)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.PURCHASE_ORDER_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PURCHASE_ORDER_ID", theEntity.PURCHASE_ORDER_ID));
}
if (!string.IsNullOrEmpty(theEntity.SNO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SNO", theEntity.SNO));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_ID", theEntity.PRODUCT_ID));
}
if (!string.IsNullOrEmpty(theEntity.QUANTITY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_QUANTITY", theEntity.QUANTITY));
}
if (!string.IsNullOrEmpty(theEntity.UNIT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_UNIT", theEntity.UNIT));
}
if (!string.IsNullOrEmpty(theEntity.RATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RATE", theEntity.RATE));
}
if (!string.IsNullOrEmpty(theEntity.TOTAL))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_TOTAL", theEntity.TOTAL));
}
if (!string.IsNullOrEmpty(theEntity.REMARKS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REMARKS", theEntity.REMARKS));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
public int PURCHASE_ORDER_DETAIL_Update(PURCHASE_ORDER_DETAIL obj)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "PURCHASE_ORDER_DETAIL_Update",
obj.ID
, obj.PURCHASE_ID
, obj.Product_ID
, obj.ProductName
, obj.RefType
, obj.Stock_ID
, obj.Unit
, obj.UnitConvert
, obj.Vat
, obj.VatAmount
, obj.CurrentQty
, obj.Quantity
, obj.UnitPrice
, obj.Amount
, obj.QtyConvert
, obj.DiscountRate
, obj.Discount
, obj.Charge
, obj.Limit
, obj.Width
, obj.Height
, obj.Orgin
, obj.Size
, obj.Color
, obj.StoreID
, obj.Description
, obj.Sorted
, obj.Active
, obj.LastEditDate
, obj.CreationDate
));
}
catch
{
//throw ex;
return(-1);
}
}
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr)
{
PURCHASE_ORDER_DETAIL theEntity = new PURCHASE_ORDER_DETAIL();
theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty;
theEntity.PURCHASE_ORDER_ID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty;
theEntity.SNO = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty;
theEntity.PRODUCT_ID = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty;
theEntity.QUANTITY = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty;
theEntity.UNIT = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty;
theEntity.RATE = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty;
theEntity.TOTAL = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty;
theEntity.REMARKS = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty;
return(theEntity);
}
partial void DeletePURCHASE_ORDER_DETAIL(PURCHASE_ORDER_DETAIL instance);
partial void UpdatePURCHASE_ORDER_DETAIL(PURCHASE_ORDER_DETAIL instance);
partial void InsertPURCHASE_ORDER_DETAIL(PURCHASE_ORDER_DETAIL instance);
private List <PURCHASE_ORDER_DETAIL> MapPURCHASE_ORDER_DETAIL(DataTable dt)
{
List <PURCHASE_ORDER_DETAIL> rs = new List <PURCHASE_ORDER_DETAIL>();
for (int i = 0; i < dt.Rows.Count; i++)
{
PURCHASE_ORDER_DETAIL obj = new PURCHASE_ORDER_DETAIL();
if (dt.Columns.Contains("ID"))
{
obj.ID = new Guid(dt.Rows[i]["ID"].ToString().Trim());
}
if (dt.Columns.Contains("PURCHASE_ID"))
{
obj.PURCHASE_ID = dt.Rows[i]["PURCHASE_ID"].ToString();
}
if (dt.Columns.Contains("Product_ID"))
{
obj.Product_ID = dt.Rows[i]["Product_ID"].ToString();
}
if (dt.Columns.Contains("ProductName"))
{
obj.ProductName = dt.Rows[i]["ProductName"].ToString();
}
if (dt.Columns.Contains("RefType"))
{
obj.RefType = int.Parse(dt.Rows[i]["RefType"].ToString());
}
if (dt.Columns.Contains("Stock_ID"))
{
obj.Stock_ID = dt.Rows[i]["Stock_ID"].ToString();
}
if (dt.Columns.Contains("Unit"))
{
obj.Unit = dt.Rows[i]["Unit"].ToString();
}
if (dt.Columns.Contains("UnitConvert"))
{
obj.UnitConvert = double.Parse(dt.Rows[i]["UnitConvert"].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("CurrentQty"))
{
obj.CurrentQty = double.Parse(dt.Rows[i]["CurrentQty"].ToString());
}
if (dt.Columns.Contains("Quantity"))
{
obj.Quantity = double.Parse(dt.Rows[i]["Quantity"].ToString());
}
if (dt.Columns.Contains("UnitPrice"))
{
obj.UnitPrice = double.Parse(dt.Rows[i]["UnitPrice"].ToString());
}
if (dt.Columns.Contains("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("QtyConvert"))
{
obj.QtyConvert = double.Parse(dt.Rows[i]["QtyConvert"].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("Charge"))
{
obj.Charge = double.Parse(dt.Rows[i]["Charge"].ToString());
}
if (dt.Columns.Contains("Limit"))
{
obj.Limit = DateTime.Parse(dt.Rows[i]["Limit"].ToString());
}
if (dt.Columns.Contains("Width"))
{
obj.Width = double.Parse(dt.Rows[i]["Width"].ToString());
}
if (dt.Columns.Contains("Height"))
{
obj.Height = double.Parse(dt.Rows[i]["Height"].ToString());
}
if (dt.Columns.Contains("Orgin"))
{
obj.Orgin = dt.Rows[i]["Orgin"].ToString();
}
if (dt.Columns.Contains("Size"))
{
obj.Size = dt.Rows[i]["Size"].ToString();
}
if (dt.Columns.Contains("Color"))
{
obj.Color = dt.Rows[i]["Color"].ToString();
}
//if (dt.Columns.Contains("Batch"))
// obj.Batch = dt.Rows[i]["Batch"].ToString();
//if (dt.Columns.Contains("Serial"))
// obj.Serial = dt.Rows[i]["Serial"].ToString();
//if (dt.Columns.Contains("ChassyNo"))
// obj.ChassyNo = dt.Rows[i]["ChassyNo"].ToString();
//if (dt.Columns.Contains("IME"))
// obj.IME = dt.Rows[i]["IME"].ToString();
if (dt.Columns.Contains("StoreID"))
{
obj.StoreID = long.Parse(dt.Rows[i]["StoreID"].ToString());
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString());
}
if (dt.Columns.Contains("Active"))
{
obj.Active = bool.Parse(dt.Rows[i]["Active"].ToString());
}
if (dt.Columns.Contains("LastEditDate"))
{
obj.LastEditDate = DateTime.Parse(dt.Rows[i]["LastEditDate"].ToString());
}
if (dt.Columns.Contains("CreationDate"))
{
obj.CreationDate = DateTime.Parse(dt.Rows[i]["CreationDate"].ToString());
}
rs.Add(obj);
}
return(rs);
}