public ActionResult SelectSocietate(FormCollection model) { string conStr = Session["conStr"].ToString(); // ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; Utilizator u = (Utilizator)Session["CURENT_USER"]; SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(Convert.ToInt32(u.ID), conStr); SocietateAsigurare[] sas = (SocietateAsigurare[])sar.GetAll().Result; if (!ModelState.IsValid) { return(View(sas)); } /* -- modelul cu lista -- * if(model["item.ID"] != null) * { * Session["ID_SOCIETATE"] = model["item.ID"]; * SocietateAsigurare sa = (SocietateAsigurare)sar.Find(Convert.ToInt32(model["item.ID"])).Result; * Session["SOCIETATE_ASIGURARE"] = sa; * return RedirectToAction("Index", "Home"); * } */ if (model["Societate"] != null && model["Societate"] != "") { Session["ID_SOCIETATE"] = model["Societate"]; SocietateAsigurare sa = (SocietateAsigurare)sar.Find(Convert.ToInt32(model["Societate"])).Result; Session["SOCIETATE_ASIGURARE"] = sa; //return RedirectToAction("Index", "Home"); return(RedirectToAction("IndexMain", "Dashboard")); } else { ModelState.AddModelError("", "Selectati societatea!"); return(View(sas)); } }
public ImportPlataView(int CURENT_USER_ID, string conStr) { PlatiRepository pr = new PlatiRepository(CURENT_USER_ID, conStr); ImportDates = ((List <string>)pr.GetImportDates().Result).ToArray(); SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(CURENT_USER_ID, conStr); this.SocietatiRCA = (SocietateAsigurare[])sar.GetAll().Result; }
//[AuthorizeUser(ActionName = "Dashboard", Recursive = false)] public ActionResult SelectSocietate() { string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; Utilizator u = (Utilizator)Session["CURENT_USER"]; SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(Convert.ToInt32(u.ID), conStr); SocietateAsigurare[] sas = (SocietateAsigurare[])sar.GetAll().Result; return(View(sas)); }
private ActionResult LoginInternal(string returnUrl) { Utilizator u = (Utilizator)TempData["tempLogin"]; TempData.Clear(); u.IS_ONLINE = true; //Session["LAST_LOGIN"] = DateTime.Now; Session["LAST_LOGIN"] = u.CURRENT_LOGIN = DateTime.Now; //string s = "{'IS_ONLINE':true}"; u.Update(); Session["CURENT_USER"] = u; Session["CURENT_USER_ID"] = u.ID; FormsAuthentication.SetAuthCookie(u.USER_NAME, true); //NomenclatoareRepository nr = new NomenclatoareRepository(Convert.ToInt32(u.ID), conStr); NomenclatoareRepository nr = new NomenclatoareRepository(Convert.ToInt32(u.ID), Session["conStr"].ToString()); Nomenclator n = (Nomenclator)nr.Find("TIP_UTILIZATORI", Convert.ToInt32(u.ID_TIP_UTILIZATOR)).Result; Session["CURENT_USER_TYPE"] = n; Session["CURENT_USER_RIGHTS"] = (Drept[])u.GetDrepturi().Result; Session["CURENT_USER_ACTIONS"] = (SOCISA.Models.Action[])u.GetActions().Result; Session["CURENT_USER_SETTINGS"] = (Setare[])u.GetSetari().Result; Session["CURENT_USER_SOCIETATI_ADMINISTRATE"] = (SocietateAsigurare[])u.GetSocietatiAdministrate().Result; if (u.ID_SOCIETATE == null && (n != null && n.DENUMIRE.ToUpper() == "ADMINISTRATOR")) { //return Redirect(returnUrl ?? Url.Action("SelectSocietate", "UtilizatoriController")); return(RedirectToAction("SelectSocietate")); } else { Session["ID_SOCIETATE"] = u.ID_SOCIETATE; //SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(Convert.ToInt32(u.ID), conStr); SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(Convert.ToInt32(u.ID), Session["conStr"].ToString()); SocietateAsigurare sa = (SocietateAsigurare)sar.Find(Convert.ToInt32(u.ID_SOCIETATE)).Result; Session["SOCIETATE_ASIGURARE"] = sa; //return RedirectToAction("Index", "Home"); //return Redirect(returnUrl ?? Url.Action("Index", "Home")); //return Redirect(returnUrl ?? Url.Action("IndexMain", "Dashboard")); if (returnUrl != null && returnUrl != "/") { return(Redirect(returnUrl)); } else { return(RedirectToAction("IndexMain", "Dashboard")); } } }
public DosarView(int _CURENT_USER_ID, string conStr) { SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); //this.SocietatiCASCO = this.SocietatiRCA = (SocietateAsigurare[])sar.GetAll().Result; this.SocietatiAsigurare = (SocietateAsigurare[])sar.GetAll().Result; NomenclatoareRepository nr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriCaz = (Nomenclator[])nr.GetAll("tip_caz").Result; this.TipuriDosar = (Nomenclator[])nr.GetAll("tip_dosare").Result; this.StatusDosare = SOCISA.CommonFunctions.STATUS_DOSARE; this.DosareResult = null; this.Dosar = new Dosar(); Dosar.ID_SOCIETATE_CASCO = Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"]); this.dosarJson = new DosarJson(); this.FilteredRowsCount = 0; }
public JsonResult ConfirmEmailAddress(SocietateAsigurare societate) { response r = new response(); string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); SocietatiAsigurareRepository ur = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); SocietateAsigurare s = new SocietateAsigurare(_CURENT_USER_ID, conStr, Convert.ToInt32(societate.ID)); if (s.EMAIL_CONFIRMAT != societate.EMAIL_CONFIRMAT) { r = ur.ConfirmEmailAddress(Convert.ToInt32(societate.ID), societate.EMAIL_CONFIRMAT, "EMAIL"); } if (s.EMAIL_NOTIFICARI_CONFIRMAT != societate.EMAIL_NOTIFICARI_CONFIRMAT) { r = ur.ConfirmEmailAddress(Convert.ToInt32(societate.ID), societate.EMAIL_NOTIFICARI_CONFIRMAT, "EMAIL_NOTIFICARI"); } return(Json(r, JsonRequestBehavior.AllowGet)); }
public JsonResult CheckHostName(string emailAddresses) { bool toReturn = true; string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(CURENT_USER_ID, conStr); string[] adrese = emailAddresses.Replace(" ", "").Split(','); if (adrese.Length > 0) { for (int i = 0; i < adrese.Length; i++) { if (!sar.CheckHostName(adrese[i])) { toReturn = false; break; } } } return(Json(toReturn, JsonRequestBehavior.AllowGet)); }
public DosarView(int _CURENT_USER_ID, int _ID_SOCIETATE, Dosar dosar, string conStr) { if (HttpContext.Current.Session["TOKEN"] == null) // nu e request din link email notificare { this.Dosar = dosar; this.dosarJson = new DosarJson(_CURENT_USER_ID, _ID_SOCIETATE, conStr); SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); //this.SocietatiCASCO = this.SocietatiRCA = (SocietateAsigurare[])sar.GetAll().Result; this.SocietatiAsigurare = (SocietateAsigurare[])sar.GetAll().Result; NomenclatoareRepository nr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriCaz = (Nomenclator[])nr.GetAll("tip_caz").Result; this.TipuriDosar = (Nomenclator[])nr.GetAll("tip_dosare").Result; this.StatusDosare = SOCISA.CommonFunctions.STATUS_DOSARE; //daca vrem sa aducem din start inregistrari !!! DosareRepository dr = new DosareRepository(_CURENT_USER_ID, conStr); string filter = String.Format(" DOSARE.ID_SOCIETATE_CASCO = {0} ", HttpContext.Current.Session["ID_SOCIETATE"]); string limit = String.Format(" LIMIT 0, {0} ", (SOCISA.CommonFunctions.ROWS_BLOCK_SIZE).ToString()); this.DosareResult = (Dosar[])dr.GetFiltered(null, null, filter, limit).Result; this.FilteredRowsCount = Convert.ToInt32(dr.CountFiltered(null, null, filter, null).Result); } else // request din link email notificare - doar un dosar { SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); //this.SocietatiCASCO = this.SocietatiRCA = (SocietateAsigurare[])sar.GetAll().Result; this.SocietatiAsigurare = (SocietateAsigurare[])sar.GetAll().Result; NomenclatoareRepository nr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriCaz = (Nomenclator[])nr.GetAll("tip_caz").Result; this.TipuriDosar = (Nomenclator[])nr.GetAll("tip_dosare").Result; this.StatusDosare = SOCISA.CommonFunctions.STATUS_DOSARE; this.Dosar = dosar; DosareResult = new Dosar[] { dosar }; this.dosarJson = new DosarJson(_CURENT_USER_ID, _ID_SOCIETATE, conStr); this.FilteredRowsCount = 1; } }
public JsonResult Edit(SocietateAsigurare societate) { response r = new response(); string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); SocietatiAsigurareRepository ur = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); SocietateAsigurare s = new SocietateAsigurare(_CURENT_USER_ID, conStr); PropertyInfo[] pis = societate.GetType().GetProperties(); foreach (PropertyInfo pi in pis) { pi.SetValue(s, pi.GetValue(societate)); } if (societate.ID == null) // insert { r = s.Insert(); } else // update { r = s.Update(); } return(Json(r, JsonRequestBehavior.AllowGet)); }
public UtilizatorView(int CURENT_USER_ID, string conStr) { SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(CURENT_USER_ID, conStr); SocietatiAsigurare = GetFromBase((SocietateAsigurare[])sar.GetCombo().Result); SocietatiAsigurareAdministrate = GetFromBase((SocietateAsigurare[])sar.GetAllAdministrate().Result); DrepturiRepository dr = new DrepturiRepository(CURENT_USER_ID, conStr); Drepturi = GetFromBase((Drept[])dr.GetAll().Result); ActionsRepository ar = new ActionsRepository(CURENT_USER_ID, conStr); Actions = GetFromBase((SOCISA.Models.Action[])ar.GetAll().Result); NomenclatoareRepository nr = new NomenclatoareRepository(CURENT_USER_ID, conStr); TipuriUtilizator = (Nomenclator[])nr.GetAll("tip_utilizatori").Result; //HttpContext.Current.Session["l"] = new Dictionary<int, Utilizator>(); UtilizatorJson = new UtilizatorJson(CURENT_USER_ID, conStr, CURENT_USER_ID); UtilizatorJson.UtilizatoriSubordonati = UtilizatorJson.GetUtilizatoriSubordonati(CURENT_USER_ID, conStr); }
public RaportTermeneView(int _CURENT_USER_ID, string conStr) { SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); this.SocietatiAsigurare = (SocietateAsigurare[])sar.GetAll().Result; }
public DosarView(int _CURENT_USER_ID, int _ID_SOCIETATE, string conStr, string predefinedFilter) { if (HttpContext.Current.Session["TOKEN"] == null) // nu e request din link email notificare { SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); //this.SocietatiCASCO = this.SocietatiRCA = (SocietateAsigurare[])sar.GetAll().Result; this.SocietatiAsigurare = (SocietateAsigurare[])sar.GetAll().Result; NomenclatoareRepository nr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriCaz = (Nomenclator[])nr.GetAll("tip_caz").Result; this.TipuriDosar = (Nomenclator[])nr.GetAll("tip_dosare").Result; this.StatusDosare = SOCISA.CommonFunctions.STATUS_DOSARE; try { //daca vrem sa aducem din start inregistrari !!! DosareRepository dr = new DosareRepository(_CURENT_USER_ID, conStr); //string filter = String.Format(" DOSARE.ID_SOCIETATE_CASCO = {0} ", HttpContext.Current.Session["ID_SOCIETATE"]); string filter = String.IsNullOrWhiteSpace(predefinedFilter) ? String.Format(" DOSARE.ID_SOCIETATE_CASCO = {0} ", HttpContext.Current.Session["ID_SOCIETATE"]) : predefinedFilter; string limit = String.Format(" LIMIT 0, {0} ", (SOCISA.CommonFunctions.ROWS_BLOCK_SIZE).ToString()); this.DosareResult = (Dosar[])dr.GetFiltered(null, null, filter, limit).Result; this.Dosar = DosareResult[0]; this.dosarJson = new DosarJson(_CURENT_USER_ID, _ID_SOCIETATE, conStr); this.FilteredRowsCount = Convert.ToInt32(dr.CountFiltered(null, null, filter, null).Result); } catch { this.DosareResult = null; this.Dosar = new Dosar(); Dosar.ID_SOCIETATE_CASCO = Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"]); this.dosarJson = new DosarJson(); this.FilteredRowsCount = 0; } } else // request din link email notificare - doar un dosar { SocietatiAsigurareRepository sar = new SocietatiAsigurareRepository(_CURENT_USER_ID, conStr); //this.SocietatiCASCO = this.SocietatiRCA = (SocietateAsigurare[])sar.GetAll().Result; this.SocietatiAsigurare = (SocietateAsigurare[])sar.GetAll().Result; NomenclatoareRepository nr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriCaz = (Nomenclator[])nr.GetAll("tip_caz").Result; this.TipuriDosar = (Nomenclator[])nr.GetAll("tip_dosare").Result; this.StatusDosare = SOCISA.CommonFunctions.STATUS_DOSARE; try { string token = HttpContext.Current.Session["TOKEN"].ToString(); int id_dosar = Convert.ToInt32(token.Substring(token.LastIndexOf('|') + 1)); Dosar d = new Dosar(_CURENT_USER_ID, conStr, id_dosar); DosareResult = new Dosar[] { d }; Dosar = d; this.dosarJson = new DosarJson(_CURENT_USER_ID, _ID_SOCIETATE, conStr); this.FilteredRowsCount = 1; } catch { DosareResult = null; Dosar = new Dosar(); Dosar.ID_SOCIETATE_CASCO = Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"]); dosarJson = new DosarJson(); FilteredRowsCount = 0; } } }