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)); } }
private ActionResult InternalTokenLogin(string _token, string _url, Utilizator u) { string conStr = HttpContext.Server.MapPath("~").ToLower().IndexOf("test") > 0 ? CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySQLConnectionString_test"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()) : CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()); // separam socisa de socisa_test HttpContext.Session["TOKEN"] = _token; TempData.Clear(); string[] separator = { "|" }; string[] token = _token.Split(separator, StringSplitOptions.RemoveEmptyEntries); int id = Convert.ToInt32(token[1]); Dosar d = new Dosar(Convert.ToInt32(u.ID), conStr, id); HttpContext.Session["conStr"] = conStr; HttpContext.Session["CURENT_USER_ID"] = u.ID; HttpContext.Session["CURENT_USER"] = u; FormsAuthentication.SetAuthCookie(u.USER_NAME, true); //System.Web.Security.FormsAuthentication.SetAuthCookie("", false); NomenclatoareRepository nr = new NomenclatoareRepository(Convert.ToInt32(u.ID), conStr); Nomenclator n = (Nomenclator)nr.Find("TIP_UTILIZATORI", Convert.ToInt32(u.ID_TIP_UTILIZATOR)).Result; HttpContext.Session["CURENT_USER_TYPE"] = n; HttpContext.Session["CURENT_USER_RIGHTS"] = (Drept[])u.GetDrepturi().Result; HttpContext.Session["CURENT_USER_ACTIONS"] = (SOCISA.Models.Action[])u.GetActions().Result; HttpContext.Session["CURENT_USER_SETTINGS"] = (Setare[])u.GetSetari().Result; HttpContext.Session["CURENT_USER_SOCIETATI_ADMINISTRATE"] = (SocietateAsigurare[])u.GetSocietatiAdministrate().Result; HttpContext.Session["ID_SOCIETATE"] = d.ID_SOCIETATE_CASCO; SocietateAsigurare sa = new SocietateAsigurare(Convert.ToInt32(u.ID_SOCIETATE), conStr, Convert.ToInt32(d.ID_SOCIETATE_CASCO)); HttpContext.Session["SOCIETATE_ASIGURARE"] = sa; //return Redirect(String.Format("/Dashboard/IndexMain/{0}", Token)); return(Redirect(String.Format("{0}{1}", HttpUtility.UrlDecode(_url), _token))); }
//[AuthorizeUser(ActionName = "Nomenclatoare", Recursive = false)] public ActionResult Details(string id) { string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int uid = Convert.ToInt32(Session["CURENT_USER_ID"]); SocietateAsigurare sa = !String.IsNullOrWhiteSpace(id) ? new SocietateAsigurare(uid, conStr, Convert.ToInt32(id)) : new SocietateAsigurare(); return(PartialView("_PartialSocietateAsigurare", sa)); }
public SocietateAsigurareExtended(SocietateAsigurare baza) { PropertyInfo[] pis = baza.GetType().GetProperties(); foreach (PropertyInfo pi in pis) { pi.SetValue(this, pi.GetValue(baza)); } }
public ProcesView(int _CURENT_USER_ID, string conStr, string predefinedFilter) { NomenclatoareRepository tpr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriProcese = (Nomenclator[])tpr.GetAll("tip_procese").Result; this.Instante = (Nomenclator[])tpr.GetAll("instante").Result; this.Complete = (Nomenclator[])tpr.GetAll("complete").Result; //ContracteRepository cr = new ContracteRepository(_CURENT_USER_ID, conStr); //this.Contracte = (Contract[])cr.GetAll().Result; ProceseRepository pr = new ProceseRepository(_CURENT_USER_ID, conStr); this.TipDocumenteScanateProcese = (string[])pr.GetTipDocumenteScanatePocese().Result; //PartiRepository par = new PartiRepository(_CURENT_USER_ID, conStr); //this.Parti = (Parte[])par.GetAll().Result; this.Calitati = (Nomenclator[])tpr.GetAll("calitati").Result; //Utilizator u = new Utilizator(_CURENT_USER_ID, conStr, _CURENT_USER_ID); //this.Societate = (SocietateAsigurare)u.GetSocietatiAsigurare().Result; this.Societate = new SocietateAsigurare(_CURENT_USER_ID, conStr, Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"])); //this.CurProces = new ProcesExtended(new Proces()); //this.procesJson = new ProcesJson(); StadiiRepository sr = new StadiiRepository(_CURENT_USER_ID, conStr); this.Stadii = (StadiuCombo[])sr.GetCombo().Result; this.Procese = null; this.CurProces = new ProcesExtended(new Proces()); this.FilteredRowsCount = 0; this.procesJson = new ProcesJson(); if (predefinedFilter != "empty") { try { //daca vrem sa aducem din start inregistrari !!! string initFilter = String.Format(" ((PROCESE.ID_DOSAR IS NULL AND (PROCESE.ID_RECLAMANT={0} OR PROCESE.ID_PARAT={0} OR PROCESE.ID_TERT={0})) OR (PROCESE.ID_DOSAR IS NOT NULL AND (DOSARE.ID_SOCIETATE_CASCO={0} OR DOSARE.ID_SOCIETATE_RCA={0}))) ", Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"])); ProceseRepository prep = new ProceseRepository(_CURENT_USER_ID, conStr); string filter = String.IsNullOrWhiteSpace(predefinedFilter) ? initFilter : predefinedFilter; string limit = String.Format(" LIMIT 0, {0} ", (CommonFunctions.ROWS_BLOCK_SIZE).ToString()); /* * this.Procese = (ProcesExtended[])prep.GetFilteredExtended(null, null, filter, limit).Result; * this.CurProces = this.Procese[0]; */ this.Procese = (Proces[])prep.GetFiltered(null, null, filter, limit).Result; this.CurProces = new ProcesExtended(this.Procese[0]); this.FilteredRowsCount = Convert.ToInt32(prep.CountFiltered(null, null, filter, null).Result); this.procesJson = new ProcesJson(); } catch { this.Procese = null; this.CurProces = new ProcesExtended(new Proces()); this.FilteredRowsCount = 0; this.procesJson = new ProcesJson(); } } }
public ProcesView(int _CURENT_USER_ID, string conStr, int?_ID_DOSAR, int?_ID_PROCES) { NomenclatoareRepository tpr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriProcese = (Nomenclator[])tpr.GetAll("tip_procese").Result; this.Instante = (Nomenclator[])tpr.GetAll("instante").Result; this.Complete = (Nomenclator[])tpr.GetAll("complete").Result; //ContracteRepository cr = new ContracteRepository(_CURENT_USER_ID, conStr); //this.Contracte = (Contract[])cr.GetAll().Result; ProceseRepository pr = new ProceseRepository(_CURENT_USER_ID, conStr); this.TipDocumenteScanateProcese = (string[])pr.GetTipDocumenteScanatePocese().Result; //PartiRepository par = new PartiRepository(_CURENT_USER_ID, conStr); //this.Parti = (Parte[])par.GetAll().Result; this.Calitati = (Nomenclator[])tpr.GetAll("calitati").Result; ////Utilizator u = new Utilizator(_CURENT_USER_ID, conStr, _CURENT_USER_ID); ////this.Societate = (SocietateAsigurare)u.GetSocietatiAsigurare().Result; this.Societate = new SocietateAsigurare(_CURENT_USER_ID, conStr, Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"])); StadiiRepository sr = new StadiiRepository(_CURENT_USER_ID, conStr); this.Stadii = (StadiuCombo[])sr.GetCombo().Result; this.CurProces = new ProcesExtended(new Proces()); this.procesJson = new ProcesJson(); if (_ID_DOSAR != null && _ID_PROCES == null) { this.ID_DOSAR = Convert.ToInt32(_ID_DOSAR); this.ID_PROCES = null; Dosar d = new Dosar(_CURENT_USER_ID, conStr, Convert.ToInt32(_ID_DOSAR)); //this.Dosar = d; this.Procese = (Proces[])d.GetProcese().Result; /* * Proces[] ps = (Proces[])d.GetProcese().Result; * this.Procese = new ProcesExtended[ps.Length]; * for (int i = 0; i < ps.Length; i++) * { * this.Procese[i] = new ProcesExtended(ps[i]); * } */ this.procesJson = new ProcesJson(); this.procesJson.Calitate = d.ID_SOCIETATE_CASCO == Societate.ID ? "RECLAMANT" : "PARAT"; SocietateAsigurare cealaltaSocietate = new SocietateAsigurare(_CURENT_USER_ID, conStr, Convert.ToInt32(d.ID_SOCIETATE_CASCO == Societate.ID ? d.ID_SOCIETATE_RCA : d.ID_SOCIETATE_CASCO)); this.procesJson.Reclamant = d.ID_SOCIETATE_CASCO == Societate.ID ? Societate.DENUMIRE : cealaltaSocietate.DENUMIRE; this.procesJson.Parat = d.ID_SOCIETATE_CASCO == Societate.ID ? cealaltaSocietate.DENUMIRE : Societate.DENUMIRE; this.procesJson.Tert = ""; } if (_ID_DOSAR == null && _ID_PROCES != null) { this.ID_PROCES = Convert.ToInt32(_ID_PROCES); this.ID_DOSAR = null; this.procesJson.Reclamant = ""; this.procesJson.Parat = ""; this.procesJson.Tert = ""; } }
public ProcesView() { this.TipuriProcese = this.Instante = this.Complete = this.Calitati = (new List <Nomenclator>()).ToArray(); this.Stadii = (new List <StadiuCombo>()).ToArray(); //this.Contracte = (new List<Contract>()).ToArray(); this.TipDocumenteScanateProcese = (new List <string>()).ToArray(); //this.Parti = (new List<Parte>()).ToArray(); this.Societate = new SocietateAsigurare(); this.Procese = null; this.CurProces = new ProcesExtended(new Proces()); this.FilteredRowsCount = 0; this.procesJson = new ProcesJson(); }
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 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 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 static void CallService(bool WithoutEmails, bool WithoutMarkings, bool WithPdfs, string DenumireSocietate) { response r = new response(); try { int uid = 1; List <string> conStrs = new List <string>(); conStrs.Add(CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString(), CommonFunctions.StringCipher.RetrieveKey())); //conStrs.Add(StringCipher.Decrypt( ConfigurationManager.ConnectionStrings["MySqlConnectionString_test"].ToString(), RetrieveKey())); // -- daca vrem insert si in baza de test !!! dubleaza documentele in "scan" /* * BasicHttpBinding binding = new BasicHttpBinding(); * binding.MaxBufferPoolSize = binding.MaxBufferSize = Int32.MaxValue; * binding.MaxReceivedMessageSize = long.MaxValue; */ SubrogationServiceClient s = new SubrogationServiceClient(); /* * (s.ChannelFactory.Endpoint.Binding as BasicHttpBinding).MaxBufferPoolSize = Int32.MaxValue; * (s.ChannelFactory.Endpoint.Binding as BasicHttpBinding).MaxBufferSize = Int32.MaxValue; * (s.ChannelFactory.Endpoint.Binding as BasicHttpBinding).MaxReceivedMessageSize = Int32.MaxValue; */ s.ClientCredentials.UserName.UserName = CommonFunctions.StringCipher.Decrypt(ConfigurationManager.AppSettings["AllianzWSUser"].ToString(), CommonFunctions.StringCipher.RetrieveKey()); s.ClientCredentials.UserName.Password = CommonFunctions.StringCipher.Decrypt(ConfigurationManager.AppSettings["AllianzWSPassword"].ToString(), CommonFunctions.StringCipher.RetrieveKey()); s.InnerChannel.OperationTimeout = new TimeSpan(0, 10, 0); SubrogationInfo[] sis = s.BrowseUnreadSubrogations(DateTime.MinValue, DateTime.MinValue); int counter = 0; foreach (SubrogationInfo si in sis) { //if (counter > 2) return; foreach (string conStr in conStrs) // salvam in ambele baze ! { try { response validationResponse = new response(); SOCISA.Models.Dosar d = new SOCISA.Models.Dosar(uid, conStr); try { SocietateAsigurare sCasco = new SocietateAsigurare(uid, conStr, DenumireSocietate, true); d.ID_SOCIETATE_CASCO = sCasco.ID; } catch (Exception exp) { LogWriter.Log(exp); } try { //SocietateAsigurare sRca = new SocietateAsigurare(uid, conStr, si.SubrogationInsurerName, false); SocietateAsigurare sRca = null; int?id_soc = GetSocietateMapping(SocietatiMappings, si.SubrogationInsurerId); if (id_soc != null && id_soc != 0) { sRca = new SocietateAsigurare(uid, conStr, Convert.ToInt32(id_soc)); } if (sRca == null || sRca.ID == null) { sRca = new SocietateAsigurare(uid, conStr); sRca.DENUMIRE = sRca.DENUMIRE_SCURTA = si.SubrogationInsurerName; sRca.ADRESA = si.SubrogationInsurerCountry; r = sRca.Insert(); /* * if(r.InsertedId != null && id_soc == null) * { * DataRow newRow = SocietatiMappings.NewRow(); * newRow["ID_SCA"] = r.InsertedId; * newRow["ID_SOCIETATE"] = id_soc; * SocietatiMappings.Rows.Add(newRow); * SocietatiMappings.AcceptChanges(); * SaveSocietatiMappings(DenumireSocietate); * } */ } d.ID_SOCIETATE_RCA = sRca.ID; } catch (Exception exp) { LogWriter.Log(exp); } try { if (!String.IsNullOrWhiteSpace(si.InsuredFullName)) { Asigurat aCasco = new Asigurat(uid, conStr, si.InsuredFullName); if (aCasco == null || aCasco.ID == null) { aCasco = new Asigurat(uid, conStr); aCasco.DENUMIRE = si.InsuredFullName; r = aCasco.Insert(); } d.ID_ASIGURAT_CASCO = aCasco.ID; } } catch (Exception exp) { LogWriter.Log(exp); } try { if (!String.IsNullOrWhiteSpace(si.SubrogationGuiltyPartner)) { Asigurat aRca = new Asigurat(uid, conStr, si.SubrogationGuiltyPartner); if (aRca == null || aRca.ID == null) { aRca = new Asigurat(uid, conStr); aRca.DENUMIRE = si.SubrogationGuiltyPartner; r = aRca.Insert(); } d.ID_ASIGURAT_RCA = aRca.ID; } } catch (Exception exp) { LogWriter.Log(exp); } try { if (!String.IsNullOrWhiteSpace(si.InsuredCarPlateNo)) { Auto autoCasco = new Auto(uid, conStr, si.InsuredCarPlateNo); if (autoCasco == null || autoCasco.ID == null) { autoCasco = new Auto(uid, conStr); autoCasco.NR_AUTO = si.InsuredCarPlateNo; autoCasco.MARCA = si.InsuredCarBrandName; autoCasco.MODEL = si.InsuredCarModelName; autoCasco.SERIE_SASIU = si.InsuredCarChassisNo; r = autoCasco.Insert(); } d.ID_AUTO_CASCO = autoCasco.ID; } } catch (Exception exp) { LogWriter.Log(exp); } try { if (!String.IsNullOrWhiteSpace(si.SubrogationCarPlateNo)) { Auto autoRca = new Auto(uid, conStr, si.SubrogationCarPlateNo); if (autoRca == null || autoRca.ID == null) { autoRca = new Auto(uid, conStr); autoRca.NR_AUTO = si.SubrogationCarPlateNo; //autoRca.MARCA = si.SubrogationCarBrandName; //autoRca.MODEL = si.SubrogationCarModelName; autoRca.SERIE_SASIU = si.SubrogationCarChassisNo; r = autoRca.Insert(); } d.ID_AUTO_RCA = autoRca.ID; } } catch (Exception exp) { LogWriter.Log(exp); } try { d.CAZ = si.AmiableAssessmentNo; } catch { } try { d.DATA_CREARE = d.DATA_ULTIMEI_MODIFICARI = DateTime.Now; } catch { } try { if (si.LossDate == DateTime.MinValue) { d.DATA_EVENIMENT = null; } else { d.DATA_EVENIMENT = si.LossDate; } } catch { } try { d.DATA_NOTIFICARE = si.AssessmentDate; } catch { } //?? - la ei este Data Constatarii, nu cred ca e tot una cu Data Notificarii de la noi try { d.NR_DOSAR_CASCO = si.ClaimFileNo; } catch { } try { d.NR_POLITA_CASCO = si.InsuredPolicyNo; } catch { } try { d.NR_POLITA_RCA = si.SubrogationRcoPolicyNo; } catch { } try { d.SUMA_IBNR = d.VALOARE_DAUNA = d.VALOARE_REGRES = d.VMD = d.REZERVA_DAUNA = Convert.ToDouble(si.ClaimReserveValueRon); } catch { } try { d.LOC_ACCIDENT = String.Format("{0}{1}{2}{3}{4}{5}", si.LossCountry, String.IsNullOrWhiteSpace(si.LossCity) ? "" : ", " + si.LossCity, String.IsNullOrWhiteSpace(si.LossDistrictNo.ToString()) ? "" : ", sector " + si.LossDistrictNo.ToString(), String.IsNullOrWhiteSpace(si.LossStreet) ? "" : ", str. " + si.LossStreet, String.IsNullOrWhiteSpace(si.LossStreetNo) ? "" : ", nr. " + si.LossStreetNo, String.IsNullOrWhiteSpace(si.LossIntersection) ? "" : ", intersectie cu str. " + si.LossIntersection); } catch { } validationResponse = d.Validare(); if (validationResponse.Status) { r = d.Insert(); validationResponse.InsertedId = r.InsertedId; validationResponse.Status = true; if (r.Status && r.InsertedId != null) { d.Log(validationResponse, 1); // 1 = automatic import ClaimDocumentSummary[] cdss = s.BrowseClaimDocuments(si.ClaimId, DateTime.MinValue); foreach (ClaimDocumentSummary cds in cdss) { try { //TipDocument td = new TipDocument(uid, conStr, cds.CategoryName); TipDocument td = null; int? id_tip_doc = GetTipDocumentMapping(TipuriDocumentMappings, cds.CategoryId); if (id_tip_doc != null && id_tip_doc != 0) { td = new TipDocument(uid, conStr, Convert.ToInt32(id_tip_doc)); } DocumentScanat ds = new DocumentScanat(uid, conStr); ds.DENUMIRE_FISIER = String.IsNullOrWhiteSpace(cds.Name) ? cds.FileName : cds.Name; ds.EXTENSIE_FISIER = !String.IsNullOrWhiteSpace(cds.Extension) ? cds.Extension : !String.IsNullOrWhiteSpace(cds.Name) ? cds.Name.Substring(cds.Name.LastIndexOf('.')) : cds.FileName.Substring(cds.FileName.LastIndexOf('.')); ds.ID_TIP_DOCUMENT = Convert.ToInt32(td.ID); ds.ID_DOSAR = Convert.ToInt32(d.ID); BinaryContent bc = s.GetClaimDocumentDetails(cds.Id); ds.FILE_CONTENT = bc.BinaryData; ds.CALE_FISIER = FileManager.SaveBinaryContentToFile(bc.BinaryData, ds.EXTENSIE_FISIER); response rd = ds.Validare(); if (rd.Status) { rd = ds.Insert(); ds.Log(rd, 1); // 1 = automatic import } if (!rd.Status) // marcam dosarul ca citit (preluat) de la Allianz doar daca s-a reusit preluarea tuturor documentelor asociate { r.AddResponse(rd); } } catch (Exception exp) { LogWriter.Log(exp); r.AddResponse(new response(false, exp.ToString(), null, null, new List <Error>() { new Error(exp) })); } } if (r.Status) { if (!WithoutMarkings) { s.MarkAsReadByClaimId(si.ClaimId); } if (WithoutEmails && WithPdfs) { d.GenerateNotificarePdf(); } if (!WithoutEmails) { d.SendNotificare(EmailProfiles.AwsNotificariSES); } } } } else { r = d.InsertWithErrors(); validationResponse.Status = false; validationResponse.InsertedId = r.InsertedId; if (r.Status && r.InsertedId != null) { d.Log(validationResponse, 1); // 1 = automatic import ClaimDocumentSummary[] cdss = s.BrowseClaimDocuments(si.ClaimId, DateTime.MinValue); foreach (ClaimDocumentSummary cds in cdss) { try { //TipDocument td = new TipDocument(uid, conStr, cds.CategoryName); TipDocument td = null; int? id_tip_doc = GetTipDocumentMapping(TipuriDocumentMappings, cds.CategoryId); if (id_tip_doc != null && id_tip_doc != 0) { td = new TipDocument(uid, conStr, Convert.ToInt32(id_tip_doc)); } DocumentScanat ds = new DocumentScanat(uid, conStr); ds.DENUMIRE_FISIER = String.IsNullOrWhiteSpace(cds.Name) ? cds.FileName : cds.Name; ds.EXTENSIE_FISIER = !String.IsNullOrWhiteSpace(cds.Extension) ? cds.Extension : !String.IsNullOrWhiteSpace(cds.Name) ? cds.Name.Substring(cds.Name.LastIndexOf('.')) : cds.FileName.Substring(cds.FileName.LastIndexOf('.')); ds.ID_TIP_DOCUMENT = Convert.ToInt32(td.ID); ds.ID_DOSAR = Convert.ToInt32(d.ID); BinaryContent bc = s.GetClaimDocumentDetails(cds.Id); ds.FILE_CONTENT = bc.BinaryData; ds.CALE_FISIER = FileManager.SaveBinaryContentToFile(bc.BinaryData, ds.EXTENSIE_FISIER); response rd = ds.Validare(); if (rd.Status) { rd = ds.InsertWithErrors(); ds.Log(rd, 1); // 1 = automatic import } if (!rd.Status) // marcam dosarul ca citit (preluat) de la Allianz doar daca s-a reusit preluarea tuturor documentelor asociate { r.AddResponse(rd); } } catch (Exception exp) { LogWriter.Log(exp); r.AddResponse(new response(false, exp.ToString(), null, null, new List <Error>() { new Error(exp) })); } } if (r.Status) { if (!WithoutMarkings) { s.MarkAsReadByClaimId(si.ClaimId); } } } } } catch (Exception exp) { LogWriter.Log(exp); } counter++; } } } catch (Exception exp) { LogWriter.Log(exp); } }
public ActionResult TokenLogin(string _url, string _token) { //string Token = HttpContext.Request.Params["URL"].ToString().Substring(HttpContext.Request.Params["URL"].ToString().LastIndexOf('/') + 1); if (!String.IsNullOrWhiteSpace(_token) && _token.IndexOf('|') > -1) { if (Session["CURENT_USER_ID"] != null && Session["ID_SOCIETATE"] != null) // s-a mai accesat odata linkul (de exemplu pt. email si pt. printare documente { HttpContext.Session["TOKEN"] = _token; return(Redirect(String.Format("{0}{1}", HttpUtility.UrlDecode(_url), _token))); } else // aici trebuie sa trimitem cod pe email { if (TempData["TOKEN"] == null || String.IsNullOrWhiteSpace(TempData["TOKEN"].ToString())) { string conStr = HttpContext.Server.MapPath("~").ToLower().IndexOf("test") > 0 ? CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySQLConnectionString_test"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()) : CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()); // separam socisa de socisa_test Utilizator u = null; MySql.Data.MySqlClient.MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection(conStr); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "UTILIZATORIsp_GetByUserName"; cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("_USER_NAME", "email")); con.Open(); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (r.Read()) { int authenticatedUserId = Convert.ToInt32(r["ID"]); u = new Utilizator(Convert.ToInt32(authenticatedUserId), conStr, r); break; } r.Close(); r.Dispose(); if (con != null && con.State == System.Data.ConnectionState.Open) { con.Close(); con.Dispose(); } if (u == null) { TempData.Clear(); return(Redirect("~")); } else { TempData["TOKEN"] = _token; TempData["URL"] = _url; string[] separator = { "|" }; string[] token = _token.Split(separator, StringSplitOptions.RemoveEmptyEntries); string md5p = token[0]; int id = Convert.ToInt32(token[1]); Dosar d = new Dosar(Convert.ToInt32(u.ID), conStr, id); MD5 md5h = MD5.Create(); if (!CommonFunctions.VerifyMd5Hash(md5h, d.NR_DOSAR_CASCO, md5p)) { TempData.Clear(); return(Redirect("~")); } else { if (Convert.ToBoolean(ConfigurationManager.AppSettings["UseDoubleAutentificationForEmail"])) { SocietateAsigurare sa = (SocietateAsigurare)d.GetSocietateRca().Result; TempData["tempLogin"] = u; //string rnd = "1234"; // pt. test Random generator = new Random(); string rnd = generator.Next(0, 1000000).ToString("D6"); SendVerificationCode(EmailProfiles.AwsCereriSES, sa.EMAIL_NOTIFICARI, rnd); TempData["verificationCode"] = rnd; TempData["verificationCodeIssueTime"] = DateTime.Now; return(View("TokenLogin", new LoginJson())); //return RedirectToAction("TokenLogin", "Utilizatori"); } else { return(InternalTokenLogin(_token, _url, u)); } } } } else { TempData.Clear(); return(Redirect("~")); } } } else { return(Redirect("~")); } }
public ActionResult TokenLogin(LoginJson model, string submitCode) { if (submitCode == "Retrimite codul") { model.Code = null; //string rnd = "1234"; // pt. test Utilizator u = (Utilizator)TempData["tempLogin"]; string _token = TempData["TOKEN"].ToString(); string _url = TempData["URL"].ToString(); string[] separator = { "|" }; string[] token = _token.Split(separator, StringSplitOptions.RemoveEmptyEntries); int id = Convert.ToInt32(token[1]); string conStr = HttpContext.Server.MapPath("~").ToLower().IndexOf("test") > 0 ? CommonFunctions.StringCipher.Decrypt(System.Configuration.ConfigurationManager.ConnectionStrings["MySQLConnectionString_test"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()) : CommonFunctions.StringCipher.Decrypt(System.Configuration.ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()); // separam socisa de socisa_test Dosar d = new Dosar(Convert.ToInt32(u.ID), conStr, id); SocietateAsigurare sa = (SocietateAsigurare)d.GetSocietateRca().Result; Random generator = new Random(); string rnd = generator.Next(0, 1000000).ToString("D6"); SendVerificationCode(EmailProfiles.AwsCereriSES, sa.EMAIL_NOTIFICARI, rnd); TempData.Clear(); TempData["TOKEN"] = _token; TempData["URL"] = _url; TempData["tempLogin"] = u; TempData["verificationCode"] = rnd; TempData["verificationCodeIssueTime"] = DateTime.Now; return(View("TokenLogin", new LoginJson())); } if (TempData["TOKEN"] != null && TempData["URL"] != null && TempData["tempLogin"] != null) { if (TempData["verificationCode"] == null || String.IsNullOrWhiteSpace(TempData["verificationCode"].ToString())) { ModelState.AddModelError("", socisaV2.Resources.ErrorMessagesResx.VERIFICATION_CODE_EXPIRED); //TempData.Clear(); TempData.Keep(); return(View("TokenLogin", model)); } else { //model.Code = TempData["verificationCode"].ToString(); var passedSeconds = (DateTime.Now - (DateTime)TempData["verificationCodeIssueTime"]).TotalSeconds; if (Math.Abs((int)passedSeconds) > Convert.ToInt32(ConfigurationManager.AppSettings["VerificationCodeExpiration"])) { ModelState.AddModelError("", socisaV2.Resources.ErrorMessagesResx.VERIFICATION_CODE_EXPIRED); //TempData.Clear(); TempData.Keep(); return(View("TokenLogin", model)); } else { if (String.IsNullOrEmpty(model.Code)) { ModelState.AddModelError("", socisaV2.Resources.ErrorMessagesResx.EMPTY_CODE); return(View("TokenLogin", model)); } else { if (model.Code != TempData["verificationCode"].ToString()) { ModelState.AddModelError("", socisaV2.Resources.ErrorMessagesResx.VERIFICATION_CODE_DONT_MATCH); return(View("TokenLogin", model)); } else { return(InternalTokenLogin(TempData["TOKEN"].ToString(), TempData["URL"].ToString(), (Utilizator)TempData["tempLogin"])); } } } } } else { TempData.Clear(); return(Redirect("~")); } }
public void ExportDosareToExcel(string _sort, string _order, string _filter, string _limit) { try { JObject jObj = (JObject)JsonConvert.DeserializeObject(_filter); string filterName = jObj["filterName"].ToString(); string filterKey = jObj["filterKey"].ToString(); object[] args = JsonConvert.DeserializeObject <object[]>(jObj["args"].ToString()); _filter = PredefinedFilters.CreateFilter(filterName, filterKey, args); } catch { } string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); DosareRepository dr = new DosareRepository(_CURENT_USER_ID, conStr); //Dosar[] dosare = (Dosar[])dr.GetFiltered(null, null, String.Format(" DOSARE.DATA_SCA = '{0}' AND DOSARE.ID_SOCIETATE_CASCO = '{1}' AND DOSARE.ID_SOCIETATE_RCA = '{2}' ", CommonFunctions.ToMySqlFormatDate(d), Convert.ToInt32(Session["ID_SOCIETATE"]), Convert.ToInt32(id_soc_rca)), null).Result; Dosar[] dosare = (Dosar[])dr.GetFiltered(_sort, _order, _filter, _limit).Result; DataTable table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(dosare, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter() { DateTimeFormat = SOCISA.CommonFunctions.DATE_FORMAT }), (typeof(DataTable))); List <string> columns_to_remove = new List <string>(); foreach (DataColumn dc in table.Columns) { if ( !dc.ColumnName.ToLower().Equals("id") && !dc.ColumnName.ToLower().Contains("nr_dosar_casco") && !dc.ColumnName.ToLower().Contains("nr_sca") && !dc.ColumnName.ToLower().Contains("data_sca") && !dc.ColumnName.ToLower().Contains("nr_polita_casco") && !dc.ColumnName.ToLower().Contains("nr_auto_casco") && !dc.ColumnName.ToLower().Contains("nr_polita_rca") && !dc.ColumnName.ToLower().Contains("nr_auto_rca") && !dc.ColumnName.ToLower().Contains("data_eveniment") && !dc.ColumnName.ToLower().Contains("valoare_regres") && !dc.ColumnName.ToLower().Contains("data_avizare") ) { columns_to_remove.Add(dc.ColumnName); } } foreach (string col_name in columns_to_remove) { table.Columns.Remove(col_name); } DataColumn newdc = new DataColumn("ASIGURAT_CASCO", Type.GetType("System.String")); table.Columns.Add(newdc); newdc = new DataColumn("ASIGURATOR_RCA", Type.GetType("System.String")); table.Columns.Add(newdc); table.AcceptChanges(); foreach (DataRow drow in table.Rows) { try { Dosar dosar = new Dosar(_CURENT_USER_ID, conStr, Convert.ToInt32(drow["ID"])); Asigurat aCasco = (Asigurat)dosar.GetAsiguratCasco().Result; drow["ASIGURAT_CASCO"] = aCasco.DENUMIRE; SocietateAsigurare sRca = (SocietateAsigurare)dosar.GetSocietateRca().Result; drow["ASIGURATOR_RCA"] = sRca.DENUMIRE; } catch (Exception exp) { LogWriter.Log(exp); } } table.AcceptChanges(); using (ExcelPackage pack = new ExcelPackage()) { ExcelWorksheet ws = pack.Workbook.Worksheets.Add("Dosare"); ws.Cells["A1"].LoadFromDataTable(table, true); var ms = new System.IO.MemoryStream(); pack.SaveAs(ms); Response.BinaryWrite(ms.GetBuffer()); } }