/// <summary>
/// Insert Cellar Area Information
/// </summary>
/// <param name="data">Cellar Area Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CellarArea(tblCellarArea data)
{
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
int propertyFind = db.tblCellarArea.Count();
if (propertyFind > 0)
{
data.id = db.tblCellarArea.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblCellarArea.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>
/// Update Cellar Area Information
/// </summary>
/// <param name="data">Cellar Area Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CellarArea(tblCellarArea data)
{
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
db.Entry(data).State = EntityState.Modified;
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>
/// Update State Fields To Specific Category ID
/// </summary>
/// <param name="CategoryID">Category ID</param>
/// <param name="state"></param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CategoryDisable(int CategoryID, string state)
{
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
var row = db.tblCategory.Single(p => p.id == CategoryID);
row.state = state;
row.deleteDate = DateTime.Now;
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
erros.Error = false;
return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, string>(erros, String.Empty));
}
}
