/// <summary> /// Update User Type Information /// </summary> /// <param name="data">UserType Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, string> UserType(tblUserType data) { erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { var row = db.tblUserType.Single(p => p.id == data.id); row.name = data.name; 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 State Fields To Specific Employee ID /// </summary> /// <param name="CellarID">Cellar ID</param> /// <param name="state">Active Or Disable</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, string> CellarDisable(int CellarID, string state) { erros = new ErrorObject(); try { // using (HSCMEntities db = new HSCMEntities()) using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { var row = db.tblEmployee.Single(p => p.id == CellarID); 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> /// Insert Employee Information /// </summary> /// <param name="data">Employee Information</param> /// <returns>Number Affected Row</returns> public static Tuple <ErrorObject, int> product(tblProduct data) { erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { int propertyFind = db.tblProduct.Count(); if (propertyFind > 0) { data.id = db.tblProduct.Max(s => s.id); } else { data.id = 1; } db.tblProduct.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 Product List To Special AssignmentType and AnchorAssignment /// </summary> /// <param name="AssignmentType">AssignmentType</param> /// <param name="AnchorAssingment">AnchorAssingment</param> /// <returns>Product List</returns> public static Tuple <ErrorObject, List <tblProduct> > GetProductsOfAssignment(int AssignmentType, int AnchorAssingment) { List <tblProduct> data = new List <tblProduct>(); erros = new ErrorObject(); try { using (HSCMEntities db = new HSCMEntities()) { data = ( from A in db.tblAssignment join P in db.tblProduct on A.idProduct equals P.id where A.idAnchorAssingment == AnchorAssingment && A.idAssignmentType == AssignmentType select P).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> /// Return FileManger By Specific Product ID /// </summary> /// <param name="Productid">ProductID</param> /// <returns>FileManger By Specific Product ID</returns> public static Tuple <ErrorObject, List <tblFileManager> > GetProductFileManager(int Productid) { List <tblFileManager> data = new List <tblFileManager>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = (from FM in db.tblFileManager join PFM in db.tblProductFileManager on FM.id equals PFM.idFileManager join P in db.tblProduct on PFM.idProduct equals P.id where P.id == Productid select FM ).ToList(); }; return(new Tuple <ErrorObject, List <tblFileManager> >(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, List <tblFileManager> >(erros, data)); } }
/// <summary> /// Return Product List To Special AssignmentType and AnchorAssignment /// </summary> /// <param name="CategoryID">CategoryID</param> /// <returns>Product List</returns> public static Tuple <ErrorObject, List <tblProduct> > GetProductsOfAssignment(int CategoryID) { List <tblProduct> data = new List <tblProduct>(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = ( from A in db.tblAssignment join P in db.tblProduct on A.idProduct equals P.id where A.idCategory == CategoryID select P).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)); } }