public void Activate(int id) { using (SEDESOLEntities entities = new SEDESOLEntities()) { CAPTURE b = entities.CAPTUREs.Find(id); b.IsActive = true; entities.SaveChanges(); } }
public string Save(CaptureApprovalDTO dto, int approveStatus, int level) { using (SEDESOLEntities db = new SEDESOLEntities()) { using (var transaction = db.Database.BeginTransaction()) { try { string msj = string.Empty; CAPTURE_APPROVAL app = new CAPTURE_APPROVAL(); app.Id_Capture = dto.Id_Capture; app.Id_User = dto.Id_User; app.Id_Status = approveStatus; app.CreateDate = DateTime.Now; db.CAPTURE_APPROVAL.Add(app); if (db.SaveChanges() > 0) { dto.Id = app.Id; msj = "SUCCESS"; } else { return("ERROR"); } CAPTURE b = db.CAPTUREs.FirstOrDefault(v => v.Id == dto.Id_Capture); if (b != null) { b.Id_Status = dto.Id_Status; b.Id_LevelApproval = level; db.SaveChanges(); msj = "SUCCESS"; } else { transaction.Rollback(); return("ERROR"); } transaction.Commit(); return(msj); } catch (Exception ex) { transaction.Rollback(); return("ERROR"); } } } }
public string EditStatus(int idStatus, int idCapture, int UserTypeId) { using (SEDESOLEntities db = new SEDESOLEntities()) { CAPTURE b = db.CAPTUREs.FirstOrDefault(v => v.Id == idCapture); if (b != null) { b.Id_Status = idStatus; b.Id_LevelApproval = UserTypeId; db.SaveChanges(); return("SUCCESS"); } else { return("El envío de captura no fue completado."); } } }
public bool Update(CaptureDTO capture) { using (SEDESOLEntities db = new SEDESOLEntities()) { CAPTURE b = db.CAPTUREs.Find(capture.Id); b.Description = capture.Description; b.CreateDate = capture.CreateDate; b.IsActive = capture.IsActive; b.Id_Month = capture.Id_Month; b.Id_Year = capture.Id_Year; b.Id_Status = capture.Id_Status; b.Id_SoupKitchen = (int)capture.Id_Soup_Kitchen; b.Folio = capture.Folio; b.InspectionCode = capture.InspectionCode; b.Id_LevelApproval = capture.Id_LevelApproval; b.Id_User = capture.Id_User; db.SaveChanges(); } return(true); }
public CaptureDTO Save(CaptureDTO capture) { try { using (SEDESOLEntities db = new SEDESOLEntities()) { CAPTURE cap = db.CAPTUREs.FirstOrDefault(v => v.Id_Year == capture.Id_Year && v.Id_Month == capture.Id_Month && v.Id_SoupKitchen == capture.Id_Soup_Kitchen && capture.IsActive == true); if (cap != null) { capture.Message = "Se ha creado previamente una captura para el periodo seleccionado."; } else { INSPECTION_CODE code = db.INSPECTION_CODE.FirstOrDefault(v => v.Id_Year == capture.Id_Year && v.Id_Month == capture.Id_Month && v.InspectionCode == capture.InspectionCode); if (code == null) { capture.Message = "El Código de inspección ingresado es incorrecto"; } else { CAPTURE captureEntity = new CAPTURE { Description = capture.Description, CreateDate = capture.CreateDate, IsActive = capture.IsActive, Id_Month = capture.Id_Month, Id_Year = capture.Id_Year, Id_Status = capture.Id_Status, Id_SoupKitchen = (int)capture.Id_Soup_Kitchen, Folio = capture.Folio, InspectionCode = capture.InspectionCode, Id_LevelApproval = capture.Id_LevelApproval, Id_User = capture.Id_User }; db.CAPTUREs.Add(captureEntity); if (db.SaveChanges() > 0) { capture.Id = captureEntity.Id; capture.Message = "SUCCESS"; //var query = from st in db.STATUS // where st.Id == capture.Id_Status // select new StatusDTO // { // Id = captureEntity.STATUS.Id, // Description = captureEntity.STATUS.Description, // IsActive = captureEntity.STATUS.IsActive // }; //capture.Status = query.FirstOrDefault(); } else { return(new CaptureDTO()); } } } return(capture); } } catch (Exception ex) { return(new CaptureDTO()); } }