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"));
}
}
