public JsonResult EditGenCodeDay(int id)
{
SedesolServiceClient proxy = new SedesolServiceClient();
GencodeDayDTO data = proxy.GetGenerationCodeDayById(id);
return(Json(data, JsonRequestBehavior.AllowGet));
}
private string ValidateCurp(string curp)
{
string message = "Error en la validación del CURP \n";
bool error = false;
SedesolServiceClient proxy = new SedesolServiceClient();
List <ConfigurationDTO> config = proxy.GetConfiguration("CURP");
for (int i = 0; i < curp.Length; i++)
{
//if(curp[i].ToString().Contains((config.Single(r => r.KeyDetail == i.ToString())).ToString()))
//{
//}
if (!(config.Single(r => r.KeyDetail == (i + 1).ToString())).KeyValue.Contains(curp[i].ToString()))
{
message = message + "Valor no permitido en la posición: " + (i + 1).ToString() + "\n";
error = true;
}
//else
//{
// message = message + "Valor no permitido en la posición: " + i.ToString() + "\n";
// error = true;
//}
}
if (error == false)
{
message = "SUCCESS";
}
return(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 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 JsonResult GetDataForAc(string term)
{
SedesolServiceClient proxy = new SedesolServiceClient();
List <AttendanceDTO> listDto = proxy.GetDataForAc(term);
var result = new List <KeyValuePair <string, string> >();
var namecodes = new List <SelectListItem>();
//namecodes = (from u in db.w_Items select new SelectListItem { Text = u.ItemCode, Value = u.w_ItemId.ToString() }).ToList();
namecodes = listDto.Select(x => new SelectListItem()
{
Text = x.Name + " | " + x.LastName + " | " + x.LastName2 +
" | " + x.Curp + " | " + Convert.ToDateTime(x.Birthdate).ToShortDateString() +
" | " + x.Gender + " | " + x.Id_Condition + " | " + x.Id_State_Birth +
" | " + x.Address + " | " + x.PhoneNumber, Value = "0"
}).ToList();
foreach (var item in namecodes)
{
result.Add(new KeyValuePair <string, string>(item.Value.ToString(), item.Text));
}
var namecodes1 = result.Where(s => s.Value.ToLower().Contains(term.ToLower())).Select(w => w).ToList();
return(Json(namecodes1, JsonRequestBehavior.AllowGet));
}
public JsonResult SendToApproval2(int idCapture, int approved, int pState, int pSoupK, int pStatus)
{
UserDTO userDto = (UserDTO)Session["userData"];
SedesolServiceClient proxy = new SedesolServiceClient();
CaptureApprovalDTO dto = new CaptureApprovalDTO();
List <CaptureDTO> captureList = new List <CaptureDTO>();
dto.Id_Capture = idCapture;
dto.UserDto = userDto;
if (approved == 1)
{
dto.Id_Status = Convert.ToInt32(ConfigurationManager.AppSettings["stAprobada"].ToString());
}
else
{
dto.Id_Status = Convert.ToInt32(ConfigurationManager.AppSettings["stRechazada"].ToString());
}
dto.Id_User = userDto.Id;
string resp = proxy.SendToApproval(dto);
if (resp == "SUCCESS")
{
captureList = proxy.GetCapturesSearch(userDto.Id_User_Type, userDto.Id, pState, pSoupK, pStatus);
}
string viewContent = ConvertViewToString("CaptureList", captureList);
return(Json(new { message = resp, PartialView = viewContent }));
}
public ActionResult Login(UserValidationRequest userValRequest)
{
if (userValRequest.Username == null || userValRequest.Password == null)
{
ModelState.AddModelError("", "El Usuario y Contraseña son campos requeridos");
return(View(userValRequest));
}
string passwordEncoded = Encryption.EncodePassword(userValRequest.Password);
userValRequest.Password = passwordEncoded;
SedesolServiceClient proxy = new SedesolServiceClient();
UserDTO uDto = new UserDTO();
uDto = proxy.ValidateUser(userValRequest);
if (uDto != null && uDto.Id > 0)
{
Session.Add("userData", uDto);
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "El usuario y la contraseña no coinciden");
return(View(userValRequest));
}
}
public JsonResult GenerateCode()
{
SedesolServiceClient proxy = new SedesolServiceClient();
string data = proxy.GenerateCode(((UserDTO)Session["userData"]).Id);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult UploadFile(int pYear, int pMonth)
{
string result = string.Empty;
SedesolServiceClient client = new SedesolServiceClient();
foreach (string fileName in Request.Files)
{
HttpPostedFileBase file = Request.Files[fileName];
if (file != null && file.ContentLength > 0)
{
DataTable dt = new DataTable();
dt = GetDataTableFromSpreadsheet(file.InputStream, false, pYear, pMonth);
dt.TableName = "dtRations";
if (dt.Rows.Count > 1)
{
result = client.SaveRations(DTOSerializer.Serialize(dt).InnerXml);
}
else
{
result = "No se pudo obtener la informaciòn del archivo";
}
}
}
RationModel model = new RationModel();
model = client.GetRationSearch(pYear, pMonth);
client.Close();
string viewContent = ConvertViewToString("RationList", model.ListRation);
return(Json(new { message = result, PartialView = viewContent }));
}
public JsonResult EditAttendance(int id)
{
SedesolServiceClient proxy = new SedesolServiceClient();
AttendanceDTO data = proxy.GetAttendanceById(id);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDates()
{
List <GencodeDayDTO> model = new List <GencodeDayDTO>();
SedesolServiceClient proxy = new SedesolServiceClient();
model = proxy.GetGenerationCodeDayAll();
return(PartialView("AvaiDate", model));
}
// GET: InspectionCode
public ActionResult Index()
{
SedesolServiceClient proxy = new SedesolServiceClient();
CodeParam model = proxy.GetParamCode(((UserDTO)Session["userData"]).Id);
List <YearDTO> years = model.Years;
years = years.Where(item => Convert.ToInt32(item.Description) <= DateTime.Now.Year).ToList();
model.Years = years;
return(View(model));
}
public ActionResult GetModalApproval(int id)
{
List <CaptureApprovalDTO> listApproval = new List <CaptureApprovalDTO>();
if (id > 0)
{
SedesolServiceClient proxy = new SedesolServiceClient();
listApproval = proxy.GetApprovalByCaptureId(id);
}
return(PartialView("ModalHistoricApproval", listApproval));
}
public JsonResult FindSoupKitchen(int StateId)
{
UserDTO userDto = (UserDTO)Session["userData"];
SedesolServiceClient proxy = new SedesolServiceClient();
List <SoupKitchenDTO> kitchenList = new List <SoupKitchenDTO>();
kitchenList = proxy.GetSoupKitchenByUser(userDto.Id_User_Type, userDto.Id);
var filteredCollection = kitchenList.Where(item => item.Id_State == StateId).ToList();
return(Json(filteredCollection));
}
public ActionResult Create()
{
UserDTO userDto = (UserDTO)Session["userData"];
SedesolServiceClient proxy = new SedesolServiceClient();
CaptureParam model = proxy.GetParamCapture(userDto.Id_User_Type, userDto.Id);
List <YearDTO> years = model.Years;
years = years.Where(item => Convert.ToInt32(item.Description) <= DateTime.Now.Year).ToList();
model.Years = years;
return(View(model));
}
public ActionResult CreateGencodeDay()
{
GencodeDayParam model = new GencodeDayParam();
SedesolServiceClient proxy = new SedesolServiceClient();
model = proxy.GetParamGen();
List <YearDTO> years = model.Years;
years = years.Where(item => Convert.ToInt32(item.Description) <= DateTime.Now.Year).ToList();
model.Years = years;
return(View(model));
}
public JsonResult FindMonth(int year)
{
UserDTO userDto = (UserDTO)Session["userData"];
SedesolServiceClient proxy = new SedesolServiceClient();
CaptureParam model = proxy.GetParamCapture(userDto.Id_User_Type, userDto.Id);
List <MonthDTO> months = model.Months;
if (year == DateTime.Now.Year)
{
months = months.Where(item => item.Id <= DateTime.Now.Month).ToList();
}
return(Json(months));
}
public ActionResult Search(int pYear = 0, int pMonth = 0)
{
try
{
RationModel model = new RationModel();
SedesolServiceClient proxy = new SedesolServiceClient();
model = proxy.GetRationSearch(pYear, pMonth);
proxy.Close();
return(PartialView("RationList", model.ListRation));
}
catch (Exception ex)
{
return(PartialView("RationList", null));
}
}
public JsonResult DeleteAttendance(int idAttendance)
{
CaptureModel captureModel = (CaptureModel)Session["CaptureModel"];
SedesolServiceClient proxy = new SedesolServiceClient();
string data = proxy.DeleteAttendance(idAttendance);
var ItemRemove = captureModel.Capture.AttendanceList.Single(r => r.Id == idAttendance);
captureModel.Capture.AttendanceList.Remove(ItemRemove);
Session["CaptureModel"] = null;
Session.Add("CaptureModel", captureModel);
string viewContent = ConvertViewToString("AttendanceList", captureModel.Capture.AttendanceList);
return(Json(new { message = data, PartialView = viewContent }));
}
public ActionResult GetCouponFileByState(int pIdState = 0, int pYear = 0, int pMonth = 0)
{
SedesolServiceClient client = new SedesolServiceClient();
List <CouponModel> couponModelList = client.GetCouponDataByState(pIdState, pYear, pMonth);
byte[] bytes;
int count = couponModelList.Count();
using (MemoryStream memoryStream = new MemoryStream())
{
iTextSharp.text.Document pdfDoc = new iTextSharp.text.Document(iTextSharp.text.PageSize.A4, 5, 5, 10, 10);
iTextSharp.text.pdf.PdfWriter writer = iTextSharp.text.pdf.PdfWriter.GetInstance(pdfDoc, memoryStream);
pdfDoc.Open();
foreach (var item in couponModelList)
{
GetPdfSheet(item, pdfDoc);
count--;
if (count != 0)
{
pdfDoc.NewPage();
}
}
pdfDoc.Close();
bytes = memoryStream.ToArray();
memoryStream.Close();
}
Response.Clear();
string pdfName = "Consolidado-" + pIdState.ToString() + "_" + pMonth.ToString() + "" + pYear.ToString();
Response.AddHeader("Content-Disposition", "attachment; filename=" + pdfName + ".pdf");
Response.ContentType = "application/pdf";
Response.Buffer = true;
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
Response.BinaryWrite(bytes);
Response.End();
Response.Close();
return(RedirectToAction("Create"));
}
public ActionResult Create()
{
RationModel model = new RationModel();
List <RationDTO> listRation = new List <RationDTO>();
SedesolServiceClient proxy = new SedesolServiceClient();
model.ListYear = proxy.GetYears();
model.ListMonth = proxy.GetMonths();
model.ListRation = listRation;
var states = proxy.GetActiveStates();
var itemToRemove = states.Single(r => r.Id == Convert.ToInt32(ConfigurationManager.AppSettings["nacExtranjero"].ToString()));
states.Remove(itemToRemove);
model.ListState = states;
return(View(model));
}
public JsonResult DeleteUserSoupKitchen(int id, int idUser)
{
List <SoupKitchenDTO> listToAssign = new List <SoupKitchenDTO>();
List <SoupKitchenDTO> listAssigned = new List <SoupKitchenDTO>();
SedesolServiceClient proxy = new SedesolServiceClient();
string data = proxy.DeleteUserSoupKitchen(id, idUser);
if (data == "SUCCESS")
{
listToAssign = cliente.GetSoupKitchenToAssignUser(idUser);
listAssigned = cliente.GetSKAssignedUser(idUser);
}
string viewContentTo = ConvertViewToString("SoupKitchenList", listToAssign);
string viewContentAss = ConvertViewToString("SKAssignedList", listAssigned);
return(Json(new { message = data, PartialViewTo = viewContentTo, PartialViewAss = viewContentAss }));
}
public ActionResult Index()
{
ListCaptureModel model = new ListCaptureModel();
SedesolServiceClient proxy = new SedesolServiceClient();
UserDTO userDto = (UserDTO)Session["userData"];
List <CaptureDTO> capture = proxy.GetCapturesFilter(userDto.Id_User_Type, userDto.Id);
List <StatusDTO> status = proxy.GetStatus().Where(item => item.IsActive == true).ToList();
List <StateDTO> states = proxy.GetStatesFilter(userDto.Id_User_Type, userDto.Id);
var itemToRemove = states.SingleOrDefault(r => r.Id == Convert.ToInt32(ConfigurationManager.AppSettings["nacExtranjero"].ToString()));
states.Remove(itemToRemove);
model.ListCapture = capture;
model.ListState = states;
model.ListStatus = status;
return(View(model));
}
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 ActionResult GetCouponFile(int pIdRation)
{
SedesolServiceClient client = new SedesolServiceClient();
var couponModel = client.GetCouponData(pIdRation);
byte[] bytes;
using (MemoryStream memoryStream = new MemoryStream())
{
iTextSharp.text.Document pdfDoc = new iTextSharp.text.Document(iTextSharp.text.PageSize.A4, 5, 5, 10, 10);
iTextSharp.text.pdf.PdfWriter writer = iTextSharp.text.pdf.PdfWriter.GetInstance(pdfDoc, memoryStream);
pdfDoc.Open();
GetPdfSheet(couponModel, pdfDoc);
pdfDoc.Close();
bytes = memoryStream.ToArray();
memoryStream.Close();
}
//FileResult fileResult = new FileContentResult(bytes, "application/pdf");
//fileResult.FileDownloadName = "Vale_" + couponModel.Folio + "_" + couponModel.Month + "" + couponModel.Year + ".pdf";
//return fileResult;
Response.Clear();
string pdfName = "Vale_" + couponModel.Folio + "_" + couponModel.Month + "" + couponModel.Year;
Response.AddHeader("Content-Disposition", "attachment; filename=" + pdfName + ".pdf");
Response.ContentType = "application/pdf";
Response.Buffer = true;
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
Response.BinaryWrite(bytes);
Response.End();
Response.Close();
return(RedirectToAction("Create"));
}
public JsonResult SaveUserSoupKitchen(UserSoupKitchen dto)
{
List <SoupKitchenDTO> listToAssign = new List <SoupKitchenDTO>();
List <SoupKitchenDTO> listAssigned = new List <SoupKitchenDTO>();
dto.IsActive = true;
SedesolServiceClient proxy = new SedesolServiceClient();
dto = proxy.SaveUserSoupKitchen(dto);
if (dto.Message == "SUCCESS")
{
listToAssign = cliente.GetSoupKitchenToAssignUser(dto.Id_User);
listAssigned = cliente.GetSKAssignedUser(dto.Id_User);
}
string viewContentTo = ConvertViewToString("SoupKitchenList", listToAssign);
string viewContentAss = ConvertViewToString("SKAssignedList", listAssigned);
return(Json(new { message = dto.Message, PartialViewTo = viewContentTo, PartialViewAss = viewContentAss }));
}
public ActionResult SearchCaptures(int pState = 0, int pSoupK = 0, int pStatus = 0)
{
try
{
UserDTO userDto = (UserDTO)Session["userData"];
ListCaptureModel model = new ListCaptureModel();
SedesolServiceClient proxy = new SedesolServiceClient();
List <CaptureDTO> capture = proxy.GetCapturesSearch(userDto.Id_User_Type, userDto.Id, pState, pSoupK, pStatus);
//if (pState > 0)
// capture = capture.Where(item => item.SoupKitchen.State.Id == pState).ToList();
//if (pSoupK > 0)
// capture = capture.Where(item => item.SoupKitchen.Id == pSoupK).ToList();
return(PartialView("CaptureList", capture));
}
catch (Exception ex)
{
return(PartialView("CaptureList", null));
}
}
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 JsonResult SaveGencodeDay(GencodeDayDTO att)
{
try
{
SedesolServiceClient proxy = new SedesolServiceClient();
att = proxy.SaveGencodeDay(att);
List <GencodeDayDTO> listCode = new List <GencodeDayDTO>();
if (att.Message == "SUCCESS")
{
listCode = proxy.GetGenerationCodeDayAll();
}
string viewContent = ConvertViewToString("AvaiDateEdit", listCode);
return(Json(new { message = att.Message, PartialView = viewContent }));
//return PartialView("AttendanceList", captureModel.Capture.AttendanceList);
}
catch (Exception ex)
{
//return PartialView("AttendanceList", null);
return(Json(new { message = "ERROR" }));
}
}
public JsonResult DeleteLevel(int idUserTypeSk, int idSoupKitchen)
{
try
{
SedesolServiceClient proxy = new SedesolServiceClient();
string message = proxy.DeleteUserTypeSk(idUserTypeSk);
List <SkUserTypeDTOcs> list = new List <SkUserTypeDTOcs>();
if (message == "SUCCESS")
{
list = proxy.GetUserTypeBySKId(idSoupKitchen);
list = list.OrderBy(x => x.UserTypeDto.ApprovalOrder).ToList();
}
string viewContent = ConvertViewToString("UserTypeList", list);
return(Json(new { message = message, PartialView = viewContent }));
}
catch (Exception ex)
{
return(Json(new { message = "ERROR" }));
}
}
