public static Tuple <ErrorObject, List <tblUser> > GetUserButNotConfigurationList() { List <tblUser> Users = new List <tblUser>(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { Users = (from U in db.tblUser join UC in db.tblUserConfiguration on U.id equals UC.idUser into gj from newUser in gj.DefaultIfEmpty() where newUser == null 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> /// 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> /// Insert TransactionType Information /// </summary> /// <param name="data">TransactionType Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, string> TransactionType(tblTransactionType data) { erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { int propertyFind = db.tblTransactionType.Count(); if (propertyFind > 0) { data.id = db.tblTransactionType.Max(s => s.id); } else { data.id = 1; } db.tblTransactionType.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)); } }
public static Tuple <ErrorObject, int> GetTotalAmountToTransaction(int AnchorTransactionID, int TransactionTypeID) { int data = 0; erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { 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 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 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> /// Insert Assignment Information /// </summary> /// <param name="data">Assignment Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, int> Download(tblDownloadAssignment data) { erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { int propertyFind = db.tblDownloadAssignment.Count(); if (propertyFind > 0) { data.id = db.tblDownloadAssignment.Max(s => s.id); } else { data.id = 1; } db.tblDownloadAssignment.Add(data); result = db.SaveChanges(); Message = "Affected Row: " + result.ToString(); return(new Tuple <ErrorObject, int>(erros.IfError(false), data.id)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, int>(erros, 0)); } }
/// <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 Cellar Information /// </summary> /// <param name="data">Cellar Information</param> /// <returns>Cellar ID</returns> public static Tuple <ErrorObject, int> Cellar(tblCellar data) { erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { int propertyFind = db.tblCellar.Count(); if (propertyFind > 0) { data.id = db.tblCellar.Max(s => s.id); } else { data.id = 1; } db.tblCellar.Add(data); result = db.SaveChanges(); Message = "Affected Row: " + result.ToString(); return(new Tuple <ErrorObject, int>(erros.IfError(false), data.id)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, int>(erros, 0)); } }
/// <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> /// Insert 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()) { int propertyFind = db.tblUserConfiguration.Count(); if (propertyFind > 0) { data.id = db.tblUserConfiguration.Max(s => s.id); } else { data.id = 1; } db.tblUserConfiguration.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 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 UserConfiguration /// </summary> /// <returns>All UserConfiguration Or null If Exist Error</returns> public static Tuple <ErrorObject, List <tblUserConfiguration> > GetUserConfigurationList() { List <tblUserConfiguration> data = new List <tblUserConfiguration>(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { data = db.tblUserConfiguration.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 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 All Cellar To Specific ID /// </summary> /// <param name="ProductID">ProductID</param> /// <returns>All Cellar</returns> public static Tuple <ErrorObject, List <tblCellar> > GetCellarByProductID(int ProductID) { List <tblCellar> data = new List <tblCellar>(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { data = db.tblCellar.Where(c => c.idProduct == ProductID).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> /// Update Cellar Information /// </summary> /// <param name="data">Cellar Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, string> Cellar(tblCellar 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> /// Return ID To Product ID and Cellar Area ID /// </summary> /// <param name="ProductID"></param> /// <param name="CellarArea"></param> /// <returns></returns> public static Tuple <ErrorObject, int> GetCellarIDByProductIDAndCellarArea(int ProductID, int CellarAreaID) { int id = 0; erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { id = (int)db.tblCellar.Single(C => C.idProduct == ProductID && C.idcellarArea == CellarAreaID).id; return(new Tuple <ErrorObject, int>(erros.IfError(false), id)); } } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, int>(erros, 0)); } }
/// <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 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 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 TransactionType /// </summary> /// <returns>All TransactionType Or null If Exist Error</returns> public static Tuple <ErrorObject, List <tblTransactionType> > GetTransactionTypeList() { List <tblTransactionType> data = new List <tblTransactionType>(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { data = db.tblTransactionType.ToList(); }; return(new Tuple <ErrorObject, List <tblTransactionType> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblTransactionType> >(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> /// 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 Product Type By Specific ID /// </summary> /// <param name="id">Product Type ID</param> /// <returns>Produc Type By Specific ID Or null If Exist Error</returns> public static Tuple <ErrorObject, tblProductType> GetProductType(int id) { tblProductType productType = new tblProductType(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { productType = db.tblProductType.Find(id); } erros.Error = false; return(new Tuple <ErrorObject, tblProductType>(erros.IfError(false), productType)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblProductType>(erros, productType)); } }
/// <summary> /// Return All Product Type /// </summary> /// <returns>All Product Type Or null If Exist Error</returns> public static Tuple <ErrorObject, List <tblProductType> > GetProductTypeList() { List <tblProductType> productType = new List <tblProductType>(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { productType = db.tblProductType.ToList(); }; return(new Tuple <ErrorObject, List <tblProductType> >(erros.IfError(false), productType)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblProductType> >(erros, productType)); } }
/// <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)); } }
/// <summary> /// Get Type Permission Name By Specific ID /// </summary> /// <param name="id">TypePermissionID</param> /// <returns>Type Permission Name By Specific ID</returns> public static Tuple <ErrorObject, tblTypePermission> GetTypePermissionName(int id) { tblTypePermission TypePermission = new tblTypePermission(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { TypePermission.name = db.tblTypePermission.Find(id).name; } erros.Error = false; return(new Tuple <ErrorObject, tblTypePermission>(erros.IfError(false), TypePermission)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblTypePermission>(erros, TypePermission)); } }
/// <summary> /// Return All TypePermission /// </summary> /// <returns>All TypePermission Or null If Exist Error</returns> public static Tuple <ErrorObject, List <tblTypePermission> > GetTypePermissionList() { List <tblTypePermission> TypePermission = new List <tblTypePermission>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { TypePermission = db.tblTypePermission.ToList(); }; return(new Tuple <ErrorObject, List <tblTypePermission> >(erros.IfError(false), TypePermission)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblTypePermission> >(erros, TypePermission)); } }