/// <summary>
/// Update Transaction Information
/// </summary>
/// <param name="data">Transaction Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Transaction(tblTransaction data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblTransaction.Single(p => p.id == data.id);
row.amount = data.amount;
row.expeditionDate = data.expeditionDate;
row.idConditionProduct = data.idConditionProduct;
row.idProvide = data.idProvide;
row.state = data.state;
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));
}
}
/// <summary>
/// Insert TransactionType Information
/// </summary>
/// <param name="data">Transaction Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, int> Transaction(tblTransaction data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblTransaction.Count();
if (propertyFind > 0)
{
data.id = db.tblTransaction.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblTransaction.Add(data);
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
if (result > 0)
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), data.id));
}
else
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), result));
}
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, int>(erros, 0));
}
}
/// <summary>
/// Insert Employee Information
/// </summary>
/// <param name="data">Employee Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Employee(tblEmployee data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblEmployee.Count();
if (propertyFind > 0)
{
data.id = db.tblEmployee.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblEmployee.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>
/// Insert Prodcuto File Manager Information
/// </summary>
/// <param name="data">Product FileManager INformaation</param>
/// <returns>Product File Manager ID</returns>
public static Tuple <ErrorObject, int> ProductFileManager(tblProductFileManager data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
int propertyFind = db.tblProductFileManager.Count();
if (propertyFind > 0)
{
data.id = db.tblProductFileManager.Max(s => s.id);
}
else
{
data.id = 1;
}
db.tblProductFileManager.Add(data);
result = db.SaveChanges();
if (result > 0)
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), data.id));
}
else
{
return(new Tuple <ErrorObject, int>(erros.IfError(false), result));
}
}
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, int>(erros, 0));
}
}
/// <summary>
/// Update Specific Infomation to Cellar how Min, Max and detail
/// </summary>
/// <param name="data"></param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CellarUpdate(tblCellar data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblCellar.Single(p => p.id == data.id);
row.idcellarArea = data.idcellarArea;
row.min = data.min;
row.max = data.max;
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));
}
}
/// <summary>
/// Update Employee Information
/// </summary>
/// <param name="data">Employee Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Employee(tblEmployee data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblEmployee.Single(p => p.id == data.id);
row.email = data.email;
row.firstName = data.firstName;
row.lastName = data.lastName;
row.idUser = data.idUser;
row.idUserType = data.idUserType;
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));
}
}
/// <summary>
/// Update Users Information
/// </summary>
/// <param name="data">Users Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Users(tblUser data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblUser.Single(p => p.id == data.id);
if (!String.IsNullOrEmpty(data.password))
{
row.password = data.password;
}
row.user = data.user;
row.upDateDate = 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));
}
}
/// <summary>
/// Update UserConfiguration Information
/// </summary>
/// <param name="data">UserConfiguration Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> UserConfiguration(tblUserConfiguration data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblUserConfiguration.Single(p => p.id == data.id);
row.idUser = data.idUser;
row.idTypePermission = data.idTypePermission;
row.idCellarArea = data.idCellarArea;
row.idAssignmentType = data.idAssignmentType;
row.idAnchorAssignmentType = data.idAnchorAssignmentType;
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));
}
}
/// <summary>
/// Update Product Information
/// </summary>
/// <param name="data">Product Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> product(tblProduct data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblProduct.Single(p => p.id == data.id);
row.name = data.name;
row.code = data.code;
row.unit = data.unit;
row.idProductType = data.idProductType;
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));
}
}
/// <summary>
/// Update Category and All category child
/// </summary>
/// <param name="data">Category information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CategoryAndAllChildCellarArea(tblCategory data)
{
List <int> Child = new List <int>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblCategory.Single(p => p.id == data.id);
row.name = data.name;
row.idCategory = data.idCategory;
row.idCellarArea = data.idCellarArea;
row.detail = data.detail;
row.upDateDate = data.upDateDate;
result = db.SaveChanges();
Message = "Affected Row: " + result.ToString();
Child = (
from C in db.tblCategory
where C.idCategory == data.id
select C.id).ToList();
if (Child.Count > 0)
{
foreach (var item in Child)
{
var row2 = db.tblCategory.Single(p => p.id == item);
row2.idCellarArea = data.idCellarArea;
db.SaveChanges();
}
}
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 Amount TO Specific Cellar ID
/// </summary>
/// <param name="CellarID">Cellar ID</param>
/// <param name="CellarAmount">Cellar Amount</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> CellarAmoun(int CellarID, int CellarAmount)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblCellar.Single(p => p.id == CellarID);
row.amount = CellarAmount;
row.upDateDate = DateTime.Now;
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 Transaction Information
/// </summary>
/// <param name="data">Transaction Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> TransactionTypeConditionDetailAmount(tblTransactionTypeConditionDetail data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblTransactionTypeConditionDetail.Single(p => p.idCondition == data.idCondition && p.idTransactionAnchor == data.idTransactionAnchor && p.idTransactionType == data.idTransactionType);
row.amount = data.amount;
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));
}
}
/// <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 (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
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));
}
}
/// <summary>
/// Update Amount Assignment Information
/// </summary>
/// <param name="idAssignment">Assignment ID</param>
/// <param name="DownloadAmount">Amount</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> DownloadAmount(int idAssignment, int DownloadAmount)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblDownloadAssignment.Find(idAssignment);
row.amount = DownloadAmount;
row.upDateDate = DateTime.Now;
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 Assignment Information
/// </summary>
/// <param name="data">Assignment Information</param>
/// <returns>Number Affected Row</returns>
public static Tuple <ErrorObject, string> Download(tblDownloadAssignment data)
{
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
var row = db.tblDownloadAssignment.Single(p => p.id == data.id);
row.idEmployee = data.idEmployee;
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));
}
}