/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public b2bProductShipment GetByID(int id)
{
var data = qDB.view_ProductShipments.Single(m => m.ProductShipmentID == id);
var model = new b2bProductShipment();
model.ProductShipmentID = data.ProductShipmentID;
model.CompID = data.CompID;
model.CompID = (int)data.CompID;
model.RowFlag = data.RowFlag;
return(model);
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool ValidateUpdateProductShipment(b2bProductShipment data)
{
try
{
b2bProductShipment model = qDB.b2bProductShipments.Single(q => q.ProductShipmentID == data.ProductShipmentID);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertProductShipment(b2bProductShipment model)
{
// default
model.RowFlag = 1;
model.RowVersion = 1;
model.CreatedBy = "sa";
model.CreatedDate = DateTimeNow;
model.ModifiedBy = "sa";
model.ModifiedDate = DateTimeNow;
qDB.b2bProductShipments.InsertOnSubmit(model);// ทำการ save
qDB.SubmitChanges();
IsResult = true;
return(IsResult);
}
//public bool InsertProductShipment(FormCollection form)
//{
// return IsResult;
//}
#endregion
#endregion
#region Method Update
#region Update
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateProductShipment(b2bProductShipment model)
{
var data = qDB.b2bProductShipments.Single(q => q.ProductShipmentID == model.ProductShipmentID);
// set ค่า model
data.ProductID = model.ProductID;
data.CompID = model.CompID;
data.RowFlag = (short)model.RowFlag;
// default
data.RowVersion++;
data.ModifiedBy = "sa";
data.ModifiedDate = DateTimeNow;
qDB.SubmitChanges();// บันทึกค่า
return(true);
}
