public CLayer.CityClassResult Save(CLayer.CityClass cityclass) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); CLayer.CityClassResult r = new CLayer.CityClassResult(); param.Add(Connection.GetParameter("pCityClassId", DataPlug.DataType._BigInt, cityclass.CityClassID)); param.Add(Connection.GetParameter("pCityClassCode", DataPlug.DataType._Varchar, cityclass.CityClassCode)); param.Add(Connection.GetParameter("pCityClassDesription", DataPlug.DataType._Varchar, cityclass.CityClassDescription)); param.Add(Connection.GetParameter("pB2B_ID", DataPlug.DataType._BigInt, cityclass.B2B_ID)); Int64 id = Convert.ToInt64(Connection.ExecuteQueryScalar("cityclass_Save", param)); string[] CountryIds = cityclass.CountryIDs.Split(','); string[] StateIds = cityclass.StateIDs.Split(','); string[] CityIds = cityclass.CityIDs.Split(','); for (int i = 0; i <= CityIds.Length - 1; i++) { List <DataPlug.Parameter> param1 = new List <DataPlug.Parameter>(); param1.Add(Connection.GetParameter("pCityClassId", DataPlug.DataType._BigInt, id)); param1.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, Convert.ToInt64(CountryIds[i]))); param1.Add(Connection.GetParameter("pStateId", DataPlug.DataType._BigInt, Convert.ToInt64(StateIds[i]))); param1.Add(Connection.GetParameter("pCityId", DataPlug.DataType._BigInt, Convert.ToInt64(CityIds[i]))); Int64 CityId = Convert.ToInt64(Connection.ExecuteQueryScalar("cityclassBasedCities_Save", param1)); } r.Result = "Success"; return(r); }
public CLayer.CityClassResult CheckCityIfExist(string cityid, int CityClassID) { CLayer.CityClassResult rslt = new CLayer.CityClassResult(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("CityId", DataPlug.DataType._Varchar, cityid)); param.Add(Connection.GetParameter("pCityClassID", DataPlug.DataType._BigInt, CityClassID)); string Reslt = Convert.ToString(Connection.ExecuteQueryScalar("ExistCityInCityClass", param)); rslt.Result = Reslt.ToString(); return(rslt); }
public ActionResult SaveDetails(int CityClassID, string CityClassCode, string CityClassDesc, string ddlCountryID, string ddlstateID, string ddlCityID) { try { long cid = 0; long.TryParse(User.Identity.GetUserId(), out cid); CLayer.CityClassResult result = new CLayer.CityClassResult(); CLayer.CityClass cityclass = new CLayer.CityClass(); cityclass.CityClassCode = CityClassCode; cityclass.CityClassDescription = CityClassDesc; cityclass.CountryIDs = ddlCountryID; cityclass.StateIDs = ddlstateID; cityclass.CityIDs = ddlCityID; cityclass.CityClassID = CityClassID; cityclass.B2B_ID = cid; //string[] CityIds = ddlCityID.Split(','); //if (CityClassID>0) //{ result = BLayer.CityClass.CheckCityIfExist(ddlCityID, CityClassID); if (result.Result == "0") { result = BLayer.CityClass.Save(cityclass); } //} //else //{ // result = BLayer.CityClass.Save(cityclass); //} return(Json(result, "application/json", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }