/// <summary>
/// Return Affected Row Or Error If Exist
/// </summary>
/// <param name="request">ConditionProduct Information</param>
/// <returns>Affected Row Or Error If Exist</returns>
public static GetConditionProductResponse ConditionProduct(GetConditionProductResponse request)
{
GetConditionProductResponse response = new GetConditionProductResponse();
response.Error = new Handler.ErrorObject();
try
{
tblConditionProduct CellarArea = new tblConditionProduct()
{
id = request.ConditionProduct.id,
name = request.ConditionProduct.name,
detail = request.ConditionProduct.detail,
createDate = request.ConditionProduct.createDate,
upDateDate = DateTime.Now,
deleteDate = null,
state = "Active"
};
var result = ConditionProductData.Update.ConditionProduct(CellarArea);
if (result.Item1.Error)
{
response.Error.InfoError(result.Item1);
}
else
{
response.Message = result.Item2;
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
/// <summary>
/// Insert ConditionProduct Information
/// </summary>
/// <param name="data">ConditionProduct Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> ConditionProduct(tblConditionProduct data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblConditionProduct.Count();
if (propertyFind > 0)
{
data.id = db.tblConditionProduct.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblConditionProduct.Add(data);
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, string>(erros, String.Empty));
}
}
/// <summary>
/// Return ConditionProduct By Specific ID
/// </summary>
/// <param name="id">ConditionProduct ID</param>
/// <returns>ConditionProduct By Specific ID Or null If Exist Error</returns>
public static Tuple <ErrorObject, tblConditionProduct> GetConditionProduct(int id)
{
tblConditionProduct data = new tblConditionProduct();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.tblConditionProduct.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblConditionProduct>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblConditionProduct>(erros, data));
}
}
/// <summary>
/// Update ConditionProduct Information
/// </summary>
/// <param name="data">ConditionProduct Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> ConditionProduct(tblConditionProduct data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblConditionProduct.Single(p => p.id == data.id);
row.name = data.name;
row.detail = data.detail;
row.upDateDate = data.upDateDate;
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, string>(erros, String.Empty));
}
}
