/// <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> /// Return Downloan Assignment Information By Specific ID /// </summary> /// <param name="id">Download Assignment ID</param> /// <returns>Download Assignment Information</returns> public static Tuple <ErrorObject, tblDownloadAssignment> GetDownload(int id) { tblDownloadAssignment data = new tblDownloadAssignment(); erros = new ErrorObject(); try { using (EileenGaldamezEntities db = new EileenGaldamezEntities()) { data = db.tblDownloadAssignment.Find(id); } erros.Error = false; return(new Tuple <ErrorObject, tblDownloadAssignment>(erros.IfError(false), data)); } catch (Exception ex) { erros.InfoError(ex); return(new Tuple <ErrorObject, tblDownloadAssignment>(erros, data)); } }
private static GetDownloadResponse Downloads(GetDownloadResponse request) { GetDownloadResponse response = new GetDownloadResponse(); response.Error = new Handler.ErrorObject(); try { tblDownloadAssignment bussines = new tblDownloadAssignment() { id = request.Download.id, amount = request.Download.amount, idProduct = request.Download.idProduct, idEmployee = request.Download.idEmployee, detail = request.Download.detail, idCategory = request.Download.idCategory, createDate = request.Download.createDate, upDateDate = null, deleteDate = null, state = "Active" }; var result = DownloadAssignmentData.Insert.Download(bussines); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2.ToString(); } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
/// <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)); } }
public static GetDownloadResponse Downloads(GetDownloadResponse request) { GetDownloadResponse response = new GetDownloadResponse(); try { tblDownloadAssignment bussines = new tblDownloadAssignment() { id = request.Download.id, amount = request.Download.amount, detail = request.Download.detail, idCategory = request.Download.idCategory, idEmployee = request.Download.idEmployee, idProduct = request.Download.idProduct, createDate = request.Download.createDate, upDateDate = request.Download.upDateDate, deleteDate = request.Download.deleteDate, state = request.Download.state }; var result = DownloadAssignmentData.Update.Download(bussines); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2; } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }