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