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());
}
}
