public JsonResult Eliminar(int id)
{
PeriodBL oPeriodBL = new PeriodBL();
oPeriodBL.Eliminar(id);
return(Json(new
{
// this is what datatables wants sending back
status = "1",
}));
}
public void BindDays(int intClassMID, int intMode)
{
ApplicationResult objResult = new ApplicationResult();
PeriodBL objPeriodBl = new PeriodBL();
Controls objControl = new Controls();
objResult = objPeriodBl.Period_SelectAll_Days(intClassMID, intMode);
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlDay, "DayName", "DayNo");
}
ddlDay.Items.Insert(0, new ListItem("--Select--", ""));
}
public JsonResult Verificar([Bind(Include = "period_id,name,start_date_text, end_date_text")] PeriodViewModel pPeriodViewModel)
{
pPeriodViewModel.start_date = DateTime.ParseExact(pPeriodViewModel.start_date_text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
pPeriodViewModel.end_date = DateTime.ParseExact(pPeriodViewModel.end_date_text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
PeriodBL oBL = new PeriodBL();
var valido_duplicado = oBL.VerificarDuplicado(pPeriodViewModel.period_id, pPeriodViewModel.name);
var valido_fechas = oBL.VerificarDuplicado(pPeriodViewModel);
return(Json(new
{
// this is what datatables wants sending back
valido_duplicado = valido_duplicado,
valido_fechas = valido_fechas,
}));
}
public JsonResult ObtenerLista(DataTableAjaxPostModel ofilters)//DataTableAjaxPostModel model
{
PeriodBL oPeriodBL = new PeriodBL();
//PeriodFiltersViewModel ofilters = new PeriodFiltersViewModel();
GridModel <PeriodViewModel> grid = oPeriodBL.ObtenerLista(ofilters);
return(Json(new
{
// this is what datatables wants sending back
draw = ofilters.draw,
recordsTotal = grid.total,
recordsFiltered = grid.recordsFiltered,
data = grid.rows
}));
}
public ActionResult Editar([Bind(Include = "period_id,name,start_date_text, end_date_text")] PeriodViewModel pPeriodViewModel)
{
// TODO: Add insert logic here
if (pPeriodViewModel == null)
{
return(HttpNotFound());
}
PeriodBL oPeriodBL = new PeriodBL();
pPeriodViewModel.user_id_modified = AuthorizeUserAttribute.UsuarioLogeado().user_id;
pPeriodViewModel.start_date = DateTime.ParseExact(pPeriodViewModel.start_date_text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
pPeriodViewModel.end_date = DateTime.ParseExact(pPeriodViewModel.end_date_text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
oPeriodBL.Modificar(pPeriodViewModel);
return(RedirectToAction("Index"));
}
public ActionResult Index()
{
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
SelectorBL oSelectorBL = new SelectorBL();
List <SelectOptionItem> oPeriods = oSelectorBL.PeriodsSelector();
List <SelectListItem> periods = Helper.ConstruirDropDownList <SelectOptionItem>(oPeriods, "Value", "Text", "", false, "", "");
ViewBag.periods = periods;
GeneralFilterViewModel oGeneralFilterViewModel = new GeneralFilterViewModel();
oGeneralFilterViewModel.period_id = oPeriod.period_id;
return(View(oGeneralFilterViewModel));
}
public ActionResult Editar(string id)
{
PeriodBL oBL = new PeriodBL();
int pIntID = 0;
int.TryParse(id, out pIntID);
PeriodViewModel pPeriodViewModel = oBL.Obtener(pIntID);
if (pPeriodViewModel.start_date.HasValue)
{
pPeriodViewModel.start_date_text = pPeriodViewModel.start_date.Value.ToString("dd/MM/yyyy");
}
if (pPeriodViewModel.end_date.HasValue)
{
pPeriodViewModel.end_date_text = pPeriodViewModel.end_date.Value.ToString("dd/MM/yyyy");
}
return(View(pPeriodViewModel));
}
// GET: User
public ActionResult Index()
{
SelectorBL oSelectorBL = new SelectorBL();
List <SelectOptionItem> oCommissions = oSelectorBL.CommissionsSelector();
List <SelectListItem> commissions = Helper.ConstruirDropDownList <SelectOptionItem>(oCommissions, "Value", "Text", "", true, "0", "TODOS");
ViewBag.commissions = commissions;
List <SelectOptionItem> oInterestAreas = oSelectorBL.InterestAreasSelector();
List <SelectListItem> interest_areas = Helper.ConstruirDropDownList <SelectOptionItem>(oInterestAreas, "Value", "Text", "", true, "0", "TODOS");
ViewBag.commissions = commissions;
ViewBag.interest_areas = interest_areas;
List <SelectOptionItem> oEstados = oSelectorBL.StatusSelector();
List <SelectListItem> estados = Helper.ConstruirDropDownList <SelectOptionItem>(oEstados, "Value", "Text", "", true, "0", "TODOS");
ViewBag.commissions = commissions;
ViewBag.estados = estados;
List <SelectOptionItem> oOrigins = oSelectorBL.OriginSelector();
List <SelectListItem> origins = Helper.ConstruirDropDownList <SelectOptionItem>(oOrigins, "Value", "Text", "", true, "0", "TODOS");
ViewBag.commissions = commissions;
ViewBag.origins = origins;
List <SelectOptionItem> oPeriods = oSelectorBL.PeriodsSelector();
List <SelectListItem> periods = Helper.ConstruirDropDownList <SelectOptionItem>(oPeriods, "Value", "Text", "", false, "", "");
ViewBag.commissions = commissions;
ViewBag.periods = periods;
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
ReportFilterViewModel oReportFilterViewModel = new ReportFilterViewModel();
oReportFilterViewModel.period_id = oPeriod.period_id;
return(View(oReportFilterViewModel));
}
public IHttpActionResult DraftLawSearch(DraftLawSearchFilterLiteViewModel filter)
{
DraftLawBL oBL = new DraftLawBL();
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
filter.period_id = oPeriod.period_id;
List <DraftLawLiteViewModel> lista = oBL.ObtenerProyectosLeyMovil(filter);
var result = new
{
// this is what datatables wants sending back
data = lista
};
return(Ok(result));
}
public void BindPeriod()
{
ApplicationResult objResult = new ApplicationResult();
PeriodBL objPeriodBl = new PeriodBL();
objResult = objPeriodBl.Period_Select_By_School_Class(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlClass.SelectedValue));
if (objResult.resultDT.Rows.Count > 0)
{
gvPeriod.DataSource = objResult.resultDT;
gvPeriod.DataBind();
PanelVisibility(1);
}
else
{
PanelVisibility(2);
BindDays(Convert.ToInt32(ddlClass.SelectedValue), 2);
int intcount = Convert.ToInt32(hfNoOfPeriod.Value);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>BindPeriod(" + intcount + ");</script>");
}
}
public IHttpActionResult ConceptsAll(ConceptsFilterLiteViewModel filter)
{
ConceptBL oConceptBL = new ConceptBL();
//ConceptFiltersViewModel ofilters = new ConceptFiltersViewModel();
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
filter.period_id = oPeriod.period_id;
List <ConceptLiteViewModel> lista = oConceptBL.ObtenerMovil(filter);
var path = ConfigurationManager.AppSettings["pdf.path"];
lista.ForEach(a => a.pdf_file = a.pdf_file.Replace(path, ""));
var result = new
{
// this is what datatables wants sending back
data = lista
};
return(Ok(result));
}
protected void gvPeriod_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
PeriodBL objPeriodBl = new PeriodBL();
if (e.CommandName.ToString() == "Edit1")
{
BindDays(-1, 1);
ViewState["Mode"] = "Edit1";
objResult = objPeriodBl.Period_Select_By_Class(Convert.ToInt32(ddlClass.SelectedValue),
Convert.ToInt32(e.CommandArgument.ToString()));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
ddlDay.SelectedValue = objResult.resultDT.Rows[0][PeriodBO.PERIOD_DAYNO].ToString();
int intcount = Convert.ToInt32(objResult.resultDT.Rows.Count);
for (int i = 0, j = 1; i < intcount; i++, j++)
{
string[] strFrom =
objResult.resultDT.Rows[i][PeriodBO.PERIOD_FROMTIME].ToString().Split(':');
TextBox txt1 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtFromHH" + j.ToString()) as TextBox;
TextBox txt2 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtFromMM" + j.ToString()) as TextBox;
txt1.Text = strFrom[0];
txt2.Text = strFrom[1];
string[] strTo =
objResult.resultDT.Rows[i][PeriodBO.PERIOD_TOTIME].ToString().Split(':');
TextBox txt3 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtToHH" + j.ToString()) as TextBox;
TextBox txt4 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtToMM" + j.ToString()) as TextBox;
txt3.Text = strTo[0];
txt4.Text = strTo[1];
}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>BindPeriod(" + intcount + ");</script>");
PanelVisibility(2);
}
}
}
else if (e.CommandName.ToString() == "Delete1")
{
objResult = objPeriodBl.Period_Delete_By_Class_Day(Convert.ToInt32(ddlClass.SelectedValue),
Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.USERID].ToString()), DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>");
PanelVisibility(1);
BindPeriod();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnSaveClass_OnClick(object sender, EventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
PeriodBO objPeriodBo = new PeriodBO();
PeriodBL objPeriodBl = new PeriodBL();
objPeriodBo.DayName = ddlDay.SelectedItem.ToString();
objPeriodBo.DayNo = Convert.ToInt32(ddlDay.SelectedValue);
objPeriodBo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue);
objPeriodBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString());
int intCount = Convert.ToInt32(hfNoOfPeriod.Value);
if (ViewState["Mode"].ToString() == "Save")
{
for (int i = 1; i <= intCount; i++)
{
objPeriodBo.PeriodNo = i;
TextBox txt1 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtFromHH" + i.ToString()) as
TextBox;
TextBox txt2 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtFromMM" + i.ToString()) as
TextBox;
string a, b, c, d;
a = txt1.Text;
b = txt2.Text;
if (txt1.Text == "")
{
a = "--";
}
if (txt2.Text == "")
{
b = "--";
}
objPeriodBo.FromTime = a + ":" + b;
TextBox txt3 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtToHH" + i.ToString()) as
TextBox;
TextBox txt4 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtToMM" + i.ToString()) as
TextBox;
c = txt3.Text;
d = txt4.Text;
if (c == "")
{
c = "--";
}
if (d == "")
{
d = "--";
}
objPeriodBo.ToTime = c + ":" + d;
objPeriodBo.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID].ToString());
objPeriodBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objPeriodBl.Period_Insert(objPeriodBo);
}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record saved successfully.');</script>");
}
else if (ViewState["Mode"].ToString() == "Edit")
{
for (int i = 1; i <= intCount; i++)
{
objPeriodBo.PeriodNo = i;
TextBox txt1 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtFromHH" + i.ToString()) as
TextBox;
TextBox txt2 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtFromMM" + i.ToString()) as
TextBox;
string a, b, c, d;
a = txt1.Text;
b = txt2.Text;
if (txt1.Text == "")
{
a = "--";
}
if (txt2.Text == "")
{
b = "--";
}
objPeriodBo.FromTime = a + ":" + b;
TextBox txt3 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtToHH" + i.ToString()) as
TextBox;
TextBox txt4 =
Page.Master.FindControl("ContentPlaceHolder1").FindControl("txtToMM" + i.ToString()) as
TextBox;
c = txt3.Text;
d = txt4.Text;
if (c == "")
{
c = "--";
}
if (d == "")
{
d = "--";
}
objPeriodBo.ToTime = c + ":" + d;
objPeriodBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID].ToString());
objPeriodBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objPeriodBl.Period_Update(objPeriodBo);
}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record updated successfully.');</script>");
}
ClearAll();
BindPeriod();
PanelVisibility(1);
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
public JsonResult Crear([Bind(Include = "draft_law_id,draft_law_number,title,author,origin,date_presentation,date_presentation_text,commission_id,debate_speaker,debate_speaker2,debate_speaker3,debate_speaker4,status,status_comment,interest_area_id,initiative,summary,link")] DraftLawViewModel pDraftLawViewModel)
{
// TODO: Add insert logic here
if (pDraftLawViewModel == null)
{
// return HttpNotFound();
return(Json(new
{
message_error = "Datos inavalidos",
status = "0",
}));
}
pDraftLawViewModel.date_presentation = DateTime.ParseExact(pDraftLawViewModel.date_presentation_text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
pDraftLawViewModel.draft_law_id = 0;
pDraftLawViewModel.user_id_created = AuthorizeUserAttribute.UsuarioLogeado().user_id;
pDraftLawViewModel.commission = "";
pDraftLawViewModel.interest_area = "";
List <ImportError> oErrores = null;
DraftLawBL oBL = new DraftLawBL();
List <DraftLawViewModel> lista = new List <DraftLawViewModel>();
lista.Add(pDraftLawViewModel);
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
oErrores = ValidarPeriodo(oPeriod, oErrores);
if (oErrores.Count > 0)
{
return(Json(new { successfully = 0, errores = oErrores }));
}
if (VerificarPonentes(lista, out oErrores))
{
DraftLawBL oDraftLawBL = new DraftLawBL();
CommissionBL oCommissionBL = new CommissionBL();
InterestAreaBL oInterestAreaBL = new InterestAreaBL();
DraftLawStatusBL oDraftLawStatusBL = new DraftLawStatusBL();
OriginBL oOriginBL = new OriginBL();
Dictionary <string, int> commisions = new Dictionary <string, int>();
Dictionary <string, int> origins = oOriginBL.ObtenerDiccionarioPorNombre(lista.Select(a => a.origin).Distinct().ToList(), AuthorizeUserAttribute.UsuarioLogeado().user_id);
Dictionary <string, int> interest_areas = new Dictionary <string, int>();
Dictionary <string, DraftLawStatusViewModel> draftlaw_status = oDraftLawStatusBL.ObtenerDiccionarioPorNombre(lista.Select(a => a.status).Distinct().ToList(), AuthorizeUserAttribute.UsuarioLogeado().user_id);
oDraftLawBL.Import(oPeriod, lista, origins, commisions, interest_areas, draftlaw_status, AuthorizeUserAttribute.UsuarioLogeado().user_id);
// NotificacionNuevoProyectoLey(lista);
}
// oBL.Agregar(pDraftLawViewModel);
if (oErrores.Count == 0)
{
return(Json(new { successfully = 1 }));
}
else
{
return(Json(new { successfully = 0, errores = oErrores }));
}
// return RedirectToAction("Index");
}
public ActionResult UploadFiles()
{
List <ImportError> oErrores = null;
// Checking no of files injected in Request object
if (Request.Files.Count > 0)
{
try
{
// Get all files from Request object
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
//string path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/";
//string filename = Path.GetFileName(Request.Files[i].FileName);
HttpPostedFileBase file = files[i];
string fname = Guid.NewGuid().ToString() + ".xlsx";
fname = Path.Combine(Server.MapPath("~/Uploads/"), fname);
file.SaveAs(fname);
DataTable dt = Util.ReadExcelToDataTable(fname);
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
oErrores = ValidarPeriodo(oPeriod, oErrores);
List <DraftLawViewModel> lista = new List <DraftLawViewModel>();
if (oErrores.Count == 0)
{
lista = ConvertirDatatable(dt, out oErrores);
}
if (oErrores.Count == 0)
{
if (VerificarPonentes(lista, out oErrores))
{
DraftLawBL oDraftLawBL = new DraftLawBL();
CommissionBL oCommissionBL = new CommissionBL();
InterestAreaBL oInterestAreaBL = new InterestAreaBL();
DraftLawStatusBL oDraftLawStatusBL = new DraftLawStatusBL();
OriginBL oOriginBL = new OriginBL();
Dictionary <string, int> commisions = oCommissionBL.ObtenerDiccionarioPorNombre(lista.Select(a => a.commission).Distinct().ToList(), AuthorizeUserAttribute.UsuarioLogeado().user_id);
Dictionary <string, int> origins = oOriginBL.ObtenerDiccionarioPorNombre(lista.Select(a => a.origin).Distinct().ToList(), AuthorizeUserAttribute.UsuarioLogeado().user_id);
Dictionary <string, int> interest_areas = oInterestAreaBL.ObtenerDiccionarioPorNombre(lista.Select(a => a.interest_area).Distinct().ToList(), AuthorizeUserAttribute.UsuarioLogeado().user_id);
Dictionary <string, DraftLawStatusViewModel> draftlaw_status = oDraftLawStatusBL.ObtenerDiccionarioPorNombre(lista.Select(a => a.status).Distinct().ToList(), AuthorizeUserAttribute.UsuarioLogeado().user_id);
oDraftLawBL.Import(oPeriod, lista, origins, commisions, interest_areas, draftlaw_status, AuthorizeUserAttribute.UsuarioLogeado().user_id);
// NotificacionNuevoProyectoLey(lista);
}
}
}
if (oErrores.Count == 0)
{
return(Json(new { successfully = 1 }));
}
else
{
return(Json(new { successfully = 0, errores = oErrores }));
}
}
catch (Exception ex)
{
logger.Error(ex);
if (ex.Data.Contains("RepositoryMessage"))
{
logger.Error(ex.Data["RepositoryMessage"].ToString());
}
return(Json(new { successfully = -1, message = "Ha ocurrido un error. Detalle error: " + ex.Message }));
}
}
else
{
return(Json("No files selected."));
}
}
