public ActionResult GetStateByCountryId(int CountryId) { try { State emp = new State(); DataSet ds = new DataSet(); ds = EmployeeMasterBll.GetSate(CountryId); List <State> statelist = new List <State>(); if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) { statelist.Add(new State { StateId = Convert.ToInt32(dr["StateId"]), StateName = Convert.ToString(dr["StateName"]) }); } } JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); string result = javaScriptSerializer.Serialize(statelist); return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception) { throw; } }
public ActionResult GetCityByStateId(int StateId) { try { City emp = new City(); DataSet ds = new DataSet(); ds = EmployeeMasterBll.GetCity(StateId); List <City> citylist = new List <City>(); if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) { citylist.Add(new City { CityId = Convert.ToInt32(dr["CityId"]), CityName = Convert.ToString(dr["CityName"]) }); } } JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); string result = javaScriptSerializer.Serialize(citylist); return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception) { throw; } }
public ActionResult loadEmployee() { try { // get allEmployee EmployeeMasterBll bll = new EmployeeMasterBll(); DataSet ds = bll.GetAllEmployee(); //--------- DataTable dtGrid = new DataTable(); dtGrid = ds.Tables[0]; List <Employee> Gridd = new List <Employee>(); foreach (DataRow dr in dtGrid.Rows) { Employee emp = new Employee(); emp.EmployeeId = Convert.ToInt32(dr["EmployeeId"]); emp.EmployeeName = dr["EmployeeName"].ToString(); emp.JoiningDate = Convert.ToDateTime(dr["JoiningDate"]); emp.Gender = dr["Gender"].ToString(); emp.CityName = dr["CityName"].ToString(); emp.StateName = dr["StateName"].ToString(); emp.CountryName = dr["CountryName"].ToString(); Gridd.Add(emp); } return(Json(Gridd, JsonRequestBehavior.AllowGet)); } catch (Exception) { throw; } }
public void FillCountryList(ref Employee EmpMaster) { EmpMaster.CountryList = new List <SelectListItem>(); EmpMaster.CountryList.Add(new SelectListItem() { Text = Convert.ToString("Select Country"), Value = Convert.ToString("0") }); DataSet ds = EmployeeMasterBll.GetAllDropDownData("AllCountry"); ds.Tables[0].TableName = "Country"; if (ds != null) { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { EmpMaster.CountryList.Add(new SelectListItem() { Text = Convert.ToString(item["CountryName"]), Value = Convert.ToString(item["CountryId"]) }); } } } }
public ActionResult CreateEmp(Employee itemMasterVM) { try { if (ModelState.IsValid) { var g = "none"; if (itemMasterVM.Gender == "1") { g = "Male"; } else { g = "Female"; } EmployeeMasterBll bll = new EmployeeMasterBll(); // bll.EmployeeId = itemMasterVM.EmployeeId; bll.EmployeeName = itemMasterVM.EmployeeName; DateTime date = new DateTime(); date = Convert.ToDateTime(itemMasterVM.JoiningDate); bll.JoiningDate = date; bll.Designation = itemMasterVM.Designation; bll.Gender = g; bll.Details = itemMasterVM.Details; bll.CityId = itemMasterVM.CityId; bll.StateId = itemMasterVM.StateId; bll.CountryId = itemMasterVM.CountryId; int dtResponse = 0; dtResponse = bll.SaveItem(); if (dtResponse > 0) { return(Json(new { ResponseStatus = "OK", ResponseMessage = "Employee Saved Successfully!", // ResponseData = new { produ = Convert.ToString(dtResponse.Rows[0]["ProductId"]) } })); } } else { itemMasterVM.CountryList = new List <SelectListItem>(); FillCountryList(ref itemMasterVM); return(View(itemMasterVM)); } } catch (Exception ex) { ex.Message.ToString(); } return(Json(new { ResponseStatus = "OK", ResponseMessage = "Internal Server Error" })); }