/// <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)); } }