public ActionResult ShopDataNew() { CommonData dummy = new CommonData { Name = "-Select-", Id = 0 }; IList<CommonData> CountryList = lookup.GetDropDownData("Country"); SelectList Coutries = new SelectList(CountryList, "Id", "Name"); ViewBag.Coutries = Coutries; IList<CommonData> StateList = lookup.GetDropDownData("State"); SelectList States = new SelectList(StateList, "Id", "Name"); ViewBag.States = States; IList<CommonData> DistrictList = lookup.GetDropDownData("District"); DistrictList.Insert(0, dummy); SelectList Districts = new SelectList(DistrictList, "Id", "Name"); ViewBag.Districts = Districts; IList<CommonData> TalukList = lookup.GetDropDownData("Taluk"); TalukList.Insert(0, dummy); SelectList Taluks = new SelectList(TalukList, "Id", "Name"); ViewBag.Taluks = Taluks; return View(); }
public bool InsertCommonData(CommonData cd) { int res = 0; try { var sql = "[dbo].[InsertCommonData]"; DynamicParameters param = new DynamicParameters(); param.Add("type", cd.Type); param.Add("name", cd.Name); param.Add("value", cd.Value); param.Add("descrption", cd.Descrption); cn.Open(); res = cn.Execute(sql, param, commandType: CommandType.StoredProcedure); cn.Close(); } catch (Exception ex) { } finally { cn.Close(); } return Convert.ToBoolean(res); }
private void Registerlookup() { CommonData dummy = new CommonData { Name = "-Select-", Id = 0 }; #region GenderTypeList List<CommonData> GenderTypeList = new List<CommonData>(); GenderTypeList.Add(new CommonData { Name = "Male", Value = "Male" }); GenderTypeList.Add(new CommonData { Name = "Female", Value = "Female" }); GenderTypeList.Add(new CommonData { Name = "Other", Value = "Other" }); #endregion ViewBag.GenderTypes = GenderTypeList; IList<CommonData> CityTypeList = lookup.GetDropDownData("City Type"); CityTypeList.Insert(0, dummy); SelectList CityTypes = new SelectList(CityTypeList, "Id", "Name"); ViewBag.CityTypes = CityTypes; IList<CommonData> CountryList = lookup.GetDropDownData("Country"); //CountryList.Insert(0, dummy); SelectList Coutries = new SelectList(CountryList, "Id", "Name"); ViewBag.Coutries = Coutries; IList<CommonData> StateList = lookup.GetDropDownData("State"); //StateList.Insert(0, dummy); SelectList States = new SelectList(StateList, "Id", "Name"); ViewBag.States = States; IList<CommonData> DistrictList = lookup.GetDropDownData("District"); DistrictList.Insert(0, dummy); SelectList Districts = new SelectList(DistrictList, "Id", "Name"); ViewBag.Districts = Districts; IList<CommonData> TalukList = lookup.GetDropDownData("Taluk"); TalukList.Insert(0, dummy); SelectList Taluks = new SelectList(TalukList, "Id", "Name"); ViewBag.Taluks = Taluks; IList<CommonData> CardTypeList = lookup.GetDropDownData("Card Type"); //CardList.Insert(0, dummy); SelectList CardTypes = new SelectList(CardTypeList, "Id", "Name"); ViewBag.CardTypes = CardTypes; }
public string AddCommonData() { CommonData cd = new CommonData(); bool res = false; string mes = ""; if (Request.Form["drpcommontypedialog"] != null && Request.Form["drpcommontypedialog"] != "") cd.Type = Request.Form["drpcommontypedialog"]; else cd.Type = ""; if (Request.Form["txtnamedialog"] != null && Request.Form["txtnamedialog"] != "") cd.Name = Request.Form["txtnamedialog"]; else cd.Name = ""; if (Request.Form["txtvaluedialog"] != null && Request.Form["txtvaluedialog"] != "") cd.Value = Request.Form["txtvaluedialog"]; else cd.Value = ""; if (Request.Form["txtdescrptiondialog"] != null && Request.Form["txtdescrptiondialog"] != "") cd.Descrption = Request.Form["txtdescrptiondialog"]; else cd.Descrption = ""; res = commondatadao.InsertCommonData(cd); if (res == true) { mes = "Common data saved successfuy."; } return mes; }