/// <summary> /// Return All Assingnment To specific Product, category, Codition and TransactionType IDS /// </summary> /// <param name="ProductID"></param> /// <param name="CategoryID"></param> /// <param name="ConditionID"></param> /// <param name="TransactionTypeID"></param> /// <returns>All Assignment</returns> public static Tuple <ErrorObject, tblAssignment> GetAssignmentByProductIDAndCategoryWithCondition(int ProductID, int CategoryID, int ConditionID, int TransactionTypeID) { tblAssignment data = new tblAssignment(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = (from TC in db.tblTransactionConfigurate join A in db.tblAssignment on TC.idAnchorTransaction equals A.id join T in db.tblTransaction on TC.idTransaction equals T.id where A.idProduct == ProductID && TC.idTransactionType == TransactionTypeID && T.idConditionProduct == ConditionID select A).First(); } erros.Error = false; return(new Tuple <ErrorObject, tblAssignment>(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblAssignment>(erros, data)); } }
/// <summary> /// Return All Product By Specific Cellar Area ID /// </summary> /// <param name="CellarAreaID">CellarAreaID</param> /// <returns>All Product</returns> public static Tuple <ErrorObject, List <tblProduct> > GetProductToCellarArea(int CellarAreaID) { List <tblProduct> data = new List <tblProduct>(); List <int> ids = new List <int>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { //ids = (from C in db.tblCellar where C.idcellarArea == CellarAreaID select (int)C.idProduct).ToList(); //data = db.tblProduct.ToList(); //for (int v = 0; v < ids.Count; v++) //{ // var itemToRemove = data.SingleOrDefault(r => r.id == ids[v]); // if (itemToRemove != null) // data.Remove(itemToRemove); //} data = db.SP_Product_SelectProduct("GetProductToCellarArea", CellarAreaID, 0, 0).ToList(); }; return(new Tuple <ErrorObject, List <tblProduct> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblProduct> >(erros, data)); } }
/// <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> /// 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> /// Return All User Data with Configuration /// </summary> /// <returns>All User Data with Configuration</returns> public static Tuple <ErrorObject, List <tblUser> > GetUserButConfigurationList() { List <tblUser> Users = new List <tblUser>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { Users = (from U in db.tblUser join UC in db.tblUserConfiguration on U.id equals UC.idUser select U ).ToList(); }; return(new Tuple <ErrorObject, List <tblUser> >(erros.IfError(false), Users)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblUser> >(erros, Users)); } }
/// <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> /// 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 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> /// 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> /// Return Amoun from Transaction BY Specific AnchorTransactionID and TransactionTypeID /// </summary> /// <param name="AnchorTransactionID"></param> /// <param name="TransactionTypeID"></param> /// <returns>Amoun from Transaction</returns> public static Tuple <ErrorObject, int> GetTotalAmountToTransaction(int AnchorTransactionID, int TransactionTypeID) { int data = 0; erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = (from TC in db.tblTransactionConfigurate join T in db.tblTransaction on TC.idTransaction equals T.id where TC.idAnchorTransaction == AnchorTransactionID && TC.idTransactionType == TransactionTypeID select T.amount ).Sum(T => (int)T.Value); } erros.Error = false; return(new Tuple <ErrorObject, int>(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, int>(erros, data)); } }
/// <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> /// Return All Transaction Condition Detail By Specific TransactionType ID and TransactionAnchorID /// </summary> /// <param name="TransactionTypeID">TransactionType ID</param> /// <param name="TransactionAnchorID">TransactionAnchor ID</param> /// <param name="ConditionID">Condition ID</param> /// <returns>All Transaction Condition Detail</returns> public static Tuple <ErrorObject, bool> GetTransactionTypeConditionDetailCount(int TransactionTypeID, int TransactionAnchorID, int ConditionID) { erros = new ErrorObject(); try { // using (HSCMEntities db = new HSCMEntities()) using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { var data = db.tblTransactionTypeConditionDetail.Where(t => t.idTransactionType == TransactionTypeID && t.idTransactionAnchor == TransactionAnchorID && t.idCondition == ConditionID).Count(); erros.Error = false; if (data > 0) { return(new Tuple <ErrorObject, bool>(erros.IfError(false), true)); } else { return(new Tuple <ErrorObject, bool>(erros.IfError(false), false)); } } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, bool>(erros, false)); } }
/// <summary> /// Return Amount To ProductID and CellarID From Cellar /// </summary> /// <param name="ProductID">Product ID</param> /// <param name="CellarArea">CellarAreaID</param> /// <returns>Amount from Cellar</returns> public static Tuple <ErrorObject, tblCellar> GetCellarByProductIDAndCellarArea(int ProductID, int CellarAreaID, int conditionID, int transactionTypeID) { tblCellar Amount = new tblCellar(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { Amount = ( from TC in db.tblTransactionConfigurate join C in db.tblCellar on TC.idAnchorTransaction equals C.id join T in db.tblTransaction on TC.idTransaction equals T.id where C.idProduct == ProductID && C.idcellarArea == CellarAreaID && TC.idTransactionType == transactionTypeID && T.idConditionProduct == conditionID select C).First(); return(new Tuple <ErrorObject, tblCellar>(erros.IfError(false), Amount)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblCellar>(erros, Amount)); } }
/// <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 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> /// Return All Transaction COnfiguraction Data By Specific AnchorTransactionID and TransactionTypeID /// </summary> /// <param name="AnchorTransactionID">AnchorTransaction ID</param> /// <param name="TransactionTypeID">TransactionType ID</param> /// <returns>All Transaction COnfiguraction Data</returns> public static Tuple <ErrorObject, List <GetTransactionConfigurateDataResponse> > GetTransactionList(int AnchorTransactionID, int TransactionTypeID) { List <GetTransactionConfigurateDataResponse> data = new List <GetTransactionConfigurateDataResponse>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = (from TC in db.tblTransactionConfigurate join T in db.tblTransaction on TC.idTransaction equals T.id join TT in db.tblTransactionType on TC.idTransactionType equals TT.id where TC.idAnchorTransaction == AnchorTransactionID && TC.idTransactionType == TransactionTypeID select new GetTransactionConfigurateDataResponse() { TCid = TC.id, TCcreateDate = TC.createDate, TCdeleteDate = TC.deleteDate, TCdetail = TC.detail, TCidAnchorTransaction = TC.idAnchorTransaction, TCidTransaction = TC.idTransaction, TCidTransactionType = TC.idTransactionType, TCstate = TC.state, TCupDateDate = TC.upDateDate, Tamount = T.amount, Tstate = T.state, TexpeditionDate = T.expeditionDate, TidConditionProduct = T.idConditionProduct, TcreateDate = T.createDate, Tdetail = T.detail, TdeleteDate = T.deleteDate, TidProvide = T.idProvide, TupDateDate = T.upDateDate, TTdetail = TT.detail, TTcreateDate = TT.createDate, TTstate = TT.state, TTname = TT.name, TTdeleteDate = TT.deleteDate, TTupDateDate = TT.upDateDate }).ToList(); }; return(new Tuple <ErrorObject, List <GetTransactionConfigurateDataResponse> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <GetTransactionConfigurateDataResponse> >(erros, data)); } }
/// <summary> /// Return all items to menu /// </summary> /// <returns>All items to menu</returns> public static Tuple <ErrorObject, List <GetMenuResult> > GetCellarAreaListMenu() { List <GetMenuResult> data = new List <GetMenuResult>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { var datas = (from CA in db.tblCellarArea join C in db.tblCategory on CA.id equals C.idCellarArea select new GetMenuResult { Department = CA.name, CategoryID = C.id, CellarAreaID = CA.id, FatherCategoryID = (int)C.idCategory, Area = C.name }).OrderBy(C => C.CellarAreaID).ToList(); foreach (var data3 in datas) { int f = (from C in db.tblCategory where C.idCategory == data3.CategoryID select C.id).Count(); data.Add(new GetMenuResult() { Area = data3.Area, CellarAreaID = data3.CellarAreaID, CategoryID = data3.CategoryID, Department = data3.Department, FatherCategoryID = data3.FatherCategoryID, Father = (f > 0 ? true : false) }); } }; return(new Tuple <ErrorObject, List <GetMenuResult> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <GetMenuResult> >(erros, data)); } }
/// <summary> /// Return All Transaction Condition Detail By Specific TransactionType ID and TransactionAnchorID /// </summary> /// <param name="TransactionTypeID">TransactionType ID</param> /// <param name="TransactionAnchorID">TransactionAnchor ID</param> /// <param name="ConditionID">Condition ID</param> /// <returns>All Transaction Condition Detail</returns> public static Tuple <ErrorObject, List <tblTransactionTypeConditionDetail> > GetTransactionTypeConditionDetailList(int TransactionTypeID, int TransactionAnchorID, int ConditionID) { List <tblTransactionTypeConditionDetail> data = new List <tblTransactionTypeConditionDetail>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblTransactionTypeConditionDetail.Where(T => T.idTransactionType == TransactionTypeID && T.idTransactionAnchor == TransactionAnchorID && T.idCondition == ConditionID).ToList(); }; return(new Tuple <ErrorObject, List <tblTransactionTypeConditionDetail> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblTransactionTypeConditionDetail> >(erros, data)); } }
/// <summary> /// Return Cellar Information /// </summary> /// <param name="id">Cellar ID</param> /// <returns>Cellar Information</returns> public static Tuple <ErrorObject, tblCellar> GetCellar(int id) { tblCellar data = new tblCellar(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblCellar.Find(id); }; return(new Tuple <ErrorObject, tblCellar>(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblCellar>(erros, data)); } }
/// <summary> /// Return Department Information /// </summary> /// <param name="CategoryID">Category ID</param> /// <returns>Department Information</returns> public static Tuple <ErrorObject, tblCategory> GetCategory(int CategoryID) { tblCategory c = new tblCategory(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { c = db.tblCategory.Find(CategoryID); return(new Tuple <ErrorObject, tblCategory>(erros.IfError(false), c)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblCategory>(erros, c)); } }
/// <summary> /// Return All Cellar By Specific Cellar Area ID /// </summary> /// <param name="CellarAreaID"></param> /// <returns>All Cellar</returns> public static Tuple <ErrorObject, List <tblCellar> > GetCellarToArea(int CellarAreaID) { List <tblCellar> data = new List <tblCellar>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblCellar.Where(m => m.idcellarArea == CellarAreaID).ToList(); }; return(new Tuple <ErrorObject, List <tblCellar> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblCellar> >(erros, data)); } }
/// <summary> /// Return ID To Product ID and Cellar Area ID /// </summary> /// <param name="ProductID"></param> /// <param name="CellarArea"></param> /// <returns></returns> public static Tuple <ErrorObject, tblCellar> GetCellarIDByProductIDAndCellarArea(int ProductID, int CellarAreaID) { tblCellar data = new tblCellar(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblCellar.Single(C => C.idProduct == ProductID && C.idcellarArea == CellarAreaID); return(new Tuple <ErrorObject, tblCellar>(erros.IfError(false), data)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblCellar>(erros, data)); } }
/// <summary> /// Return All UserConfiguration To Specific User ID /// </summary> /// <param name="UserID">UserID</param> /// <returns>All UserConfiguration To Specific User ID</returns> public static Tuple <ErrorObject, List <tblUserConfiguration> > GetUserConfigurationListByUserID(int UserID) { List <tblUserConfiguration> data = new List <tblUserConfiguration>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblUserConfiguration.Where(u => u.idUser == UserID).ToList(); }; return(new Tuple <ErrorObject, List <tblUserConfiguration> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblUserConfiguration> >(erros, data)); } }
/// <summary> /// Return All Employee /// </summary> /// <returns>All Employee Or null If Exist Error</returns> public static Tuple <ErrorObject, List <tblEmployee> > GetEmployeeList() { List <tblEmployee> data = new List <tblEmployee>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblEmployee.ToList(); }; return(new Tuple <ErrorObject, List <tblEmployee> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblEmployee> >(erros, data)); } }
/// <summary> /// Return All Download Assignment By Specific Product ID /// </summary> /// <param name="ProductID">Product ID</param> /// <returns>All Download Assignment</returns> public static Tuple <ErrorObject, List <tblDownloadAssignment> > GetDownloadByProductID(int ProductID) { List <tblDownloadAssignment> data = new List <tblDownloadAssignment>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblDownloadAssignment.Where(c => c.idProduct == ProductID).ToList(); }; return(new Tuple <ErrorObject, List <tblDownloadAssignment> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblDownloadAssignment> >(erros, data)); } }
/// <summary> /// Return Category List /// </summary> /// <returns>Category List</returns> public static Tuple <ErrorObject, List <tblCategory> > GetCategory() { List <tblCategory> c = new List <tblCategory>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { c = db.tblCategory.OrderBy(d1 => d1.idCategory).OrderBy(d1 => d1.id).OrderBy(f => f.idCellarArea).ToList(); return(new Tuple <ErrorObject, List <tblCategory> >(erros.IfError(false), c)); }; } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblCategory> >(erros, c)); } }
/// <summary> /// Return Cellar /// </summary> /// <returns>All Cellar </returns> public static Tuple <ErrorObject, List <tblCellar> > GetCellarHome() { List <tblCellar> data = new List <tblCellar>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblCellar.Where(c => c.amount <= c.min).ToList(); }; return(new Tuple <ErrorObject, List <tblCellar> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblCellar> >(erros, data)); } }
/// <summary> /// Return All Assignment TO AnchorAssignment ID and Assignment Type /// </summary> /// <returns>All Assignment Or null If Exist Error</returns> public static Tuple <ErrorObject, List <tblAssignment> > GetAssignmentByCategoryID(int CategoryID) { List <tblAssignment> data = new List <tblAssignment>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblAssignment.Where(c => c.idCategory == CategoryID).ToList(); }; return(new Tuple <ErrorObject, List <tblAssignment> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblAssignment> >(erros, data)); } }
/// <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> /// Return Transaction By Specific ID /// </summary> /// <param name="id">Transaction ID</param> /// <returns>Transaction By Specific ID Or null If Exist Error</returns> public static Tuple <ErrorObject, tblTransaction> GetTransaction(int id) { tblTransaction data = new tblTransaction(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblTransaction.Find(id); } erros.Error = false; return(new Tuple <ErrorObject, tblTransaction>(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblTransaction>(erros, data)); } }