public JsonResult SetParamCapture(int idYear, int idMonth, int idSoupK, string soupK, string year, string month, string pFolio, string pCode)
{
SedesolServiceClient proxy = new SedesolServiceClient();
CaptureModel cModel = new CaptureModel();
CaptureDTO captDto = new CaptureDTO();
AttendanceDTO attDto = new AttendanceDTO();
UserDTO userDto = (UserDTO)Session["userData"];
string message = string.Empty;
captDto.Id_Month = idMonth;
captDto.Id_Year = idYear;
captDto.Id_Soup_Kitchen = idSoupK;
captDto.CreateDate = DateTime.Now;
captDto.Description = year + " | " + month + " | " + soupK;
captDto.IsActive = true;
captDto.Id_Status = Convert.ToInt32(ConfigurationManager.AppSettings["stIniciada"].ToString());
captDto.Folio = pFolio;
captDto.InspectionCode = pCode;
captDto.Id_LevelApproval = userDto.UserType.Id;
captDto.Id_User = userDto.Id;
cModel.Capture = proxy.SaveCapture(captDto);
//cModel.Capture = captDto;
cModel.Attendance = attDto;
Session.Add("CaptureModel", cModel);
return(Json(new { message = cModel.Capture.Message }));
}
public ActionResult CaptureAttendance(int id = 0)
{
SedesolServiceClient proxy = new SedesolServiceClient();
CaptureModel model = new CaptureModel();
int countImg = 0;
if (id != null && id > 0)
{
CaptureDTO capture = proxy.GetCaptureById(id);
foreach (CaptureImageDTO item in capture.ImageList)
{
item.ImageFileB64 = "data:image/jpeg; base64," + Convert.ToBase64String(item.ImageFile);
}
countImg = capture.ImageList.Count();
model.Capture = capture;
model.StateDtoList = proxy.GetActiveStates();
model.ConditionDtoList = proxy.GetActiveCondition();
//CaptureModel cModel = new CaptureModel();
//cModel.Capture = capture;
Session.Add("CountImg", countImg);
Session.Add("CaptureModel", model);
}
else
{
model = (CaptureModel)Session["CaptureModel"];
model.StateDtoList = proxy.GetActiveStates();
model.ConditionDtoList = proxy.GetActiveCondition();
}
return(View(model));
}
public CaptureDTO Save(CaptureDTO dto)
{
CaptureDAO b = new CaptureDAO();
dto = b.Save(dto);
string message = dto.Message;
CaptureDTO capt = new CaptureDTO();
capt = b.GetCaptureById(dto.Id);
if (capt == null)
{
capt = new CaptureDTO();
}
capt.Message = message;
return(capt);
}
public ActionResult GetModalAttendance(int id)
{
CaptureModel model = new CaptureModel();
if (id != null && id > 0)
{
SedesolServiceClient proxy = new SedesolServiceClient();
CaptureDTO capture = proxy.GetCaptureById(id);
model.Capture = capture;
CaptureModel cModel = new CaptureModel();
cModel.Capture = capture;
//Session.Add("CaptureModel", cModel);
}
else
{
model = (CaptureModel)Session["CaptureModel"];
}
return(PartialView("ModalAttendance", model));
}
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 JsonResult EditStatus(int id)
{
SedesolServiceClient proxy = new SedesolServiceClient();
CaptureDTO capture = proxy.GetCaptureById(id);
string data = string.Empty;
UserDTO userDto = (UserDTO)Session["userData"];
if (capture.AttendanceList.Count() == 0)
{
data = "Debe registrar asistencia a la captura.";
}
else if (capture.ImageList.Count() == 0)
{
data = "Debe ingresar imágenes a la captura.";
}
else
{
data = proxy.EditStatus(Convert.ToInt32(ConfigurationManager.AppSettings["stEnviada"].ToString()), id, userDto.Id_User_Type);
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
public bool Update(CaptureDTO dto)
{
CaptureDAO b = new CaptureDAO();
return(b.Update(dto));
}
public bool UpdateCapture(CaptureDTO capture)
{
CaptureDAL dal = new CaptureDAL();
return(dal.Update(capture));
}
public CaptureDTO SaveCapture(CaptureDTO capture)
{
CaptureDAL dal = new CaptureDAL();
return(dal.Save(capture));
}
public Resp_Binary_Member <AlarmDTO> Add_One(CaptureDTO model) => _service.Add_One(model);
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());
}
}
