public List<FormValidation> GetFormData(FormValidationPara frmpara) { _petaDB.EnableAutoSelect=false; return _petaDB.Query<FormValidation>("Exec Form_Caption @FormType,@FormTabCode,@corporate,@type", new { FormType=frmpara.FormType, FormTabCode=frmpara.FormTabCode, corporate=frmpara.corporate, type=frmpara.type }).ToList(); }
public ActionResult Index(string url = "") { /* Uncomment it for already login case */ /* if (Session["CreatedBy"] != null) { return RedirectToAction("Index", "Dashboard"); } */ #region Get Form Data ViewBag.CurrentURL = Request.Url.Scheme + "://" + Request.Url.Authority; if (ViewBag.CurrentURL == "http://localhost:9359") { ViewBag.CurrentURL = "http://gt.techpure.co.uk"; ///ViewBag.CurrentURL = "http://tu.techpure.co.uk"; } frm_para.FormType = "LoginPage"; //from_code frm_para.corporate = "--None--"; frm_para.type = "Caption"; frm_para.FormTabCode = "--None--"; var form_val = _objcomman.GetFormData(frm_para); //url = "https://agent.travelzunlimited.com/crm" //string url = Request.Url.ToString(); FormValidationPara _FormValidationPara = new FormValidationPara() { type = "PageLoad", //url = "http://gt.techpure.co.uk" url = ViewBag.CurrentURL }; if (url == "") { ViewBag.RedirectUrl = "/Dashboard"; } else { ViewBag.RedirectUrl = url; } DataSet ds = ds = _objDBLogin.GetLoginData(_FormValidationPara); if (ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { ViewBag.Corporate = ds.Tables[0].Rows[0]["Corporate"]; if (ds.Tables[0].Rows[0]["Facebook"] != null) { if (ds.Tables[0].Rows[0]["Facebook"].ToString() != "--None--" && ds.Tables[0].Rows[0]["Facebook"].ToString() != "") ViewBag.Facebook = ds.Tables[0].Rows[0]["Facebook"]; else ViewBag.Facebook = ""; } else { ViewBag.Facebook = ""; } if (ds.Tables[0].Rows[0]["Twitter"] != null) { if (ds.Tables[0].Rows[0]["Twitter"].ToString() != "--None--" && ds.Tables[0].Rows[0]["Twitter"].ToString() != "") ViewBag.Twitter = ds.Tables[0].Rows[0]["Twitter"]; else ViewBag.Twitter = ""; } else { ViewBag.Twitter = ""; } if (ds.Tables[0].Rows[0]["GooglePlus"] != null) { if (ds.Tables[0].Rows[0]["GooglePlus"].ToString() != "--None--" && ds.Tables[0].Rows[0]["GooglePlus"].ToString() != "") ViewBag.GooglePlus = ds.Tables[0].Rows[0]["GooglePlus"]; else ViewBag.GooglePlus = ""; } else { ViewBag.GooglePlus = ""; } if (ds.Tables[0].Rows[0]["WebPortal"] != null) { if (ds.Tables[0].Rows[0]["WebPortal"].ToString() != "--None--" && ds.Tables[0].Rows[0]["WebPortal"].ToString() != "") ViewBag.WebPortal = ds.Tables[0].Rows[0]["WebPortal"]; else ViewBag.WebPortal = ""; } else { ViewBag.WebPortal = ""; } if (ds.Tables[0].Rows[0]["BackgroundImg"] != null) { if (ds.Tables[0].Rows[0]["BackgroundImg"].ToString() != "" && ds.Tables[0].Rows[0]["BackgroundImg"].ToString() != "--None--") Session["BackgroundImg"] = ds.Tables[0].Rows[0]["BackgroundImg"]; else Session["BackgroundImg"] = "/assets/images/login-bg.jpg"; } else { Session["BackgroundImg"] = "/assets/images/login-bg.jpg"; } if (ds.Tables[0].Rows[0]["Logo"] != null) { if (ds.Tables[0].Rows[0]["Logo"].ToString() != "" && ds.Tables[0].Rows[0]["Logo"].ToString() != "--None--") Session["Logo"] = ds.Tables[0].Rows[0]["Logo"]; else Session["Logo"] = "/assets/images/Logo-green.png"; } else { Session["Logo"] = "/assets/images/Logo-green.png"; } if (ds.Tables[0].Rows[0]["LoginFrmCaption"] != null) { if (ds.Tables[0].Rows[0]["LoginFrmCaption"].ToString() != "" && ds.Tables[0].Rows[0]["LoginFrmCaption"].ToString() != "--None--") ViewBag.LoginFrmCaption = ds.Tables[0].Rows[0]["LoginFrmCaption"]; else ViewBag.LoginFrmCaption = ""; } else { ViewBag.LoginFrmCaption = ""; } if (ds.Tables[0].Rows[0]["Favicon"] != null) { if (ds.Tables[0].Rows[0]["Favicon"].ToString() != "" && ds.Tables[0].Rows[0]["Favicon"].ToString() != "--None--") Session["Favicon"] = ds.Tables[0].Rows[0]["Favicon"]; else Session["Favicon"] = "/assets/images/favicon.ico"; } else { Session["Favicon"] = "/assets/images/favicon.ico"; } Session["Corporate"] = ds.Tables[0].Rows[0]["Corporate"]; //Session["Logo"] = ds.Tables[0].Rows[0]["Logo"]; Session["TerminalBy"] = Request.UserHostAddress.ToString(); Session["Indsutry"] = ds.Tables[0].Rows[0]["corpCompanyIndust"]; } } #endregion return View(form_val); //return View(); }
public ActionResult PageLoad(FormValidationPara _FormValidationPara) { DataSet ds = _objDBLogin.GetLoginData(_FormValidationPara); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0] != null) { Session["Corporate"] = ds.Tables[0].Rows[0]["Corporate"]; Session["Logo"] = ds.Tables[0].Rows[0]["Logo"]; Session["TerminalBy"] = Request.UserHostAddress.ToString(); Session["Indsutry"] = ds.Tables[0].Rows[0]["corpCompanyIndust"]; } } var lst = JsonConvert.SerializeObject(ds.Tables[0], Formatting.None, new JsonSerializerSettings() { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore }); return Content(lst, "application/json"); }
public string LoginUser(FormValidationPara _FormValidationPara) { Session["Corporate"] = "0"; if (Session["Corporate"].ToString() != String.Empty) { _FormValidationPara.corporate = Session["Corporate"].ToString(); } DataSet ds = _objDBLogin.GetLoginData(_FormValidationPara); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows[0]["NOS"].ToString() != "0") { _FormValidationPara.type = "Session_Values"; ds = _objDBLogin.GetSessionValue(_FormValidationPara); if (ds.Tables[0].Rows.Count > 0) { Session["UserName"] = ds.Tables[0].Rows[0]["xname"].ToString(); Session["CreatedBy"] = ds.Tables[0].Rows[0]["xcode"].ToString(); Session["UnitCorpBy"] = ds.Tables[0].Rows[0]["Unit"].ToString(); Session["BranchBy"] = ds.Tables[0].Rows[0]["branch"].ToString(); Session["Location"] = ds.Tables[0].Rows[0]["Location"].ToString(); // setmenu(); } return "1"; } else { return "0"; } } else { return "0"; } }
public DataSet GetLoginData(FormValidationPara _FormValidationPara) { try { if (_cn.State == ConnectionState.Closed) _cn.Open(); SqlCommand _cmd = new SqlCommand("SP_Login", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@Type", _FormValidationPara.type); if (_FormValidationPara.Password != null && _FormValidationPara.Password != "") _cmd.Parameters.AddWithValue("@Password", _FormValidationPara.Password); else _cmd.Parameters.AddWithValue("@Password", DBNull.Value); if (_FormValidationPara.Email != null && _FormValidationPara.Email != "") _cmd.Parameters.AddWithValue("@Email", _FormValidationPara.Email); else _cmd.Parameters.AddWithValue("@Email", DBNull.Value); if (_FormValidationPara.Password != null && _FormValidationPara.module != "") _cmd.Parameters.AddWithValue("@module", _FormValidationPara.module); else _cmd.Parameters.AddWithValue("@module", DBNull.Value); if (_FormValidationPara.control != null && _FormValidationPara.control != "") _cmd.Parameters.AddWithValue("@control", _FormValidationPara.control); else _cmd.Parameters.AddWithValue("@control", DBNull.Value); if (_FormValidationPara.corporate != null && _FormValidationPara.corporate != "") _cmd.Parameters.AddWithValue("@corporate", _FormValidationPara.corporate); else _cmd.Parameters.AddWithValue("@corporate", DBNull.Value); if (_FormValidationPara.Unit != null && _FormValidationPara.Unit != "") _cmd.Parameters.AddWithValue("@Unit", _FormValidationPara.Unit); else _cmd.Parameters.AddWithValue("@Unit", DBNull.Value); if (_FormValidationPara.Role != null && _FormValidationPara.Role != "") _cmd.Parameters.AddWithValue("@Role", _FormValidationPara.Role); else _cmd.Parameters.AddWithValue("@Role", DBNull.Value); if (_FormValidationPara.userid != 0) _cmd.Parameters.AddWithValue("@userid", _FormValidationPara.userid); else _cmd.Parameters.AddWithValue("@userid", DBNull.Value); if (_FormValidationPara.ip != null && _FormValidationPara.ip != "") _cmd.Parameters.AddWithValue("@ip", _FormValidationPara.ip); else _cmd.Parameters.AddWithValue("@ip", DBNull.Value); if (_FormValidationPara.url != null && _FormValidationPara.url != "") _cmd.Parameters.AddWithValue("@url", _FormValidationPara.url); else _cmd.Parameters.AddWithValue("@url", DBNull.Value); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); _cn.Close(); _cn.Dispose(); return _ds; } catch { throw; } finally { _cn.Close(); _cn.Dispose(); } }
public DataSet GetMenuValue(FormValidationPara _FormValidationPara) { try { using (SqlConnection sconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["gtcon"].ConnectionString)) { sconn.Open(); using (SqlCommand _cmd = new SqlCommand("SP_Login", sconn)) { _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@Type", _FormValidationPara.type); if (_FormValidationPara.Password != null && _FormValidationPara.Password != "") _cmd.Parameters.AddWithValue("@Password", _FormValidationPara.Password); else _cmd.Parameters.AddWithValue("@Password", DBNull.Value); if (_FormValidationPara.Email != null && _FormValidationPara.Email != "") _cmd.Parameters.AddWithValue("@Email", _FormValidationPara.Email); else _cmd.Parameters.AddWithValue("@Email", DBNull.Value); if (_FormValidationPara.corporate != null && _FormValidationPara.corporate != "") _cmd.Parameters.AddWithValue("@corporate", _FormValidationPara.corporate); else _cmd.Parameters.AddWithValue("@corporate", DBNull.Value); if (_FormValidationPara.userid != 0) _cmd.Parameters.AddWithValue("@userid", _FormValidationPara.userid); else _cmd.Parameters.AddWithValue("@userid", DBNull.Value); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); sconn.Close(); sconn.Dispose(); return _ds; } } } catch { throw; } finally { } }