public IActionResult Review() { var aesUserData = User.FindFirst(ClaimTypes.UserData).Value; var UserData = JsonConvert.DeserializeObject <B2dAccount>(AesCryptHelper.aesDecryptBase64(aesUserData, Website.Instance.AesCryptKey)); var xid = UserData.COMPANY_XID; B2dCompany model = CompanyDAL.GetCompany(xid); return(View(model)); }
public static B2dCompany GetCompany(Int64 xid) { try { string sqlStmt = @"SELECT * FROM b2b.b2d_company WHERE xid=:XID"; DataSet ds = NpgsqlHelper.ExecuteDataset(Website.Instance.SqlConnectionString, CommandType.Text, sqlStmt, new NpgsqlParameter("XID", xid)); DataRow dr = ds.Tables[0].Rows[0]; var company = new B2dCompany() { XID = dr.ToInt64("xid"), STATUS = dr.ToStringEx("status"), COMP_COOP_MODE = dr.ToStringEx("comp_coop_mode"), PAYMENT_TYPE = dr.ToStringEx("payment_type"), MANAGER_ACCOUNT_XID = dr.ToInt64("manager_account_xid"), PARENT_COMP_XID = dr.ToInt64("parent_comp_xid"), COMP_NAME = dr.ToStringEx("comp_name"), COMP_URL = dr.ToStringEx("comp_url"), COMP_LICENSE = dr.ToStringEx("comp_license"), COMP_LICENSE_2 = dr.ToStringEx("comp_license_2"), COMP_LOCALE = dr.ToStringEx("comp_locale"), COMP_CURRENCY = dr.ToStringEx("comp_currency"), COMP_INVOICE = dr.ToStringEx("comp_invoice"), COMP_COUNTRY = dr.ToStringEx("comp_country"), COMP_TEL_COUNTRY_CODE = dr.ToStringEx("comp_tel_country_code"), COMP_TEL = dr.ToStringEx("comp_tel"), COMP_ADDRESS = dr.ToStringEx("comp_address"), CHARGE_MAN_FIRST = dr.ToStringEx("charge_man_first"), CHARGE_MAN_LAST = dr.ToStringEx("charge_man_last"), CREDITCARD_NO = dr.ToStringEx("creditcard_no"), CREDITCARD_VALID = dr.ToStringEx("creditcard_valid"), CREDITCARD_CVC = dr.ToStringEx("creditcard_cvc"), CONTACT_USER = dr.ToStringEx("contact_user"), CONTACT_USER_EMAIL = dr.ToStringEx("contact_user_email"), FINANCE_USER = dr.ToStringEx("finance_user"), SALES_USER = dr.ToStringEx("sales_user") }; return(company); } catch (Exception ex) { Website.Instance.logger.FatalFormat("{0}.{1}", ex.Message, ex.StackTrace); throw ex; } }
public IActionResult Profile(Int64 id) { try { var queryArgc = System.Web.HttpUtility.UrlEncode(this.Request.Query["query"].ToString()); var compRepos = HttpContext.RequestServices.GetService <CompanyRepository>(); var countryRepos = HttpContext.RequestServices.GetService <CommonRepository>(); var vouchRepos = HttpContext.RequestServices.GetService <VouchAddonRepository>(); var locale = User.FindFirst("Locale").Value; B2dCompany _company = compRepos.GetCompany(id); ViewData["VouchAddOn"] = vouchRepos.GetVoucherAddon(id); ViewData["QueryParams"] = queryArgc; ViewData["CountryAreas"] = countryRepos.GetCountryAreas(locale); ViewData["CountryLocales"] = countryRepos.GetCountryLocales(); return(View(_company)); } catch (Exception ex) { Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace); return(StatusCode(500)); } }