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.CityClass GetDetails(int id)
{
CLayer.CityClass CityClass = new CLayer.CityClass();
string countryid = "";
string countryname = "";
string stateid = "";
string satetname = "";
string cityid = "";
string cityname = "";
//DataTable dt = Connection.GetSQLTable("SELECT * FROM cityclass CC WHERE CC.CityclassID="+ id +"");
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("CityClassId", DataPlug.DataType._BigInt, id));
DataTable dt = Connection.GetTable("cityclassBasedCities_Data", param);
if (dt.Rows.Count > 0)
{
CityClass.CityClassID = Convert.ToInt64(dt.Rows[0]["CityClassID"]);
CityClass.CityClassCode = Convert.ToString(dt.Rows[0]["CityName"]);
CityClass.CityClassDescription = Convert.ToString(dt.Rows[0]["CityDescription"]);
CityClass.B2B_ID = Convert.ToInt64(dt.Rows[0]["B2b_ID"]);
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
countryid = countryid + "," + Convert.ToString(dt.Rows[i]["CountryID"]);
countryname = countryname + "," + Convert.ToString(dt.Rows[i]["CountryName"]);
stateid = stateid + "," + Convert.ToString(dt.Rows[i]["StateID"]);
satetname = satetname + "," + Convert.ToString(dt.Rows[i]["StateName"]);
cityid = cityid + "," + Convert.ToString(dt.Rows[i]["CityID"]);
cityname = cityname + "," + Convert.ToString(dt.Rows[i]["CityNames"]);
}
CityClass.CountryIDs = countryid.Substring(1, countryid.Length - 1);
CityClass.StateIDs = stateid.Substring(1, stateid.Length - 1);
CityClass.CityIDs = cityid.Substring(1, cityid.Length - 1);
CityClass.CountryNames = countryname.Substring(1, countryname.Length - 1);
CityClass.StateNames = satetname.Substring(1, satetname.Length - 1);
CityClass.CityNames = cityname.Substring(1, cityname.Length - 1);
}
return(CityClass);
}
public CLayer.CityClass GetById(int CityClassId)
{
CLayer.CityClass taxTi = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCityClassID", DataPlug.DataType._BigInt, CityClassId));
DataTable dt = Connection.GetTable("CityClassById_Get", param);
if (dt.Rows.Count > 0)
{
taxTi = new CLayer.CityClass();
taxTi.CityClassID = Connection.ToInteger(dt.Rows[0]["CityClassID"]);
taxTi.CityClassCode = Connection.ToString(dt.Rows[0]["CityClassCode"]);
taxTi.CityClassDescription = Connection.ToString(dt.Rows[0]["GradeDescription"]);
taxTi.CountryID = Connection.ToInteger(dt.Rows[0]["CountryID"]);
taxTi.StateID = Connection.ToInteger(dt.Rows[0]["StateID"]);
taxTi.CityID = Connection.ToInteger(dt.Rows[0]["CityID"]);
}
return(taxTi);
}
// GET: CorporateCityClass/Edit/5
public ActionResult Edit(int id = 0)
{
try
{
Models.CorporateCityClassModel data = new Models.CorporateCityClassModel()
{
CityClassID = 0
};
CLayer.CityClass cityclass = new CLayer.CityClass();
cityclass = BLayer.CityClass.GetDetails(id);
if (cityclass != null)
{
data = new Models.CorporateCityClassModel()
{
CityClassID = cityclass.CityClassID,
CityClassCode = cityclass.CityClassCode,
CityClassDescription = cityclass.CityClassDescription,
B2B_ID = cityclass.B2B_ID,
CountryIDs = cityclass.CountryIDs,
StateIDs = cityclass.StateIDs,
CityIDs = cityclass.CityIDs,
CountryNames = cityclass.CountryNames,
StateNames = cityclass.StateNames,
CityNames = cityclass.CityNames
}
}
;
return(PartialView("~/Views/CorporateCityClass/_Edit.cshtml", data));
//return Json(cityclass, "application/json", JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
return(Redirect("~/ErrorPage"));
}
}
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"));
}
}
public static CLayer.CityClassResult Save(CLayer.CityClass C)
{
DataLayer.CityClass cityclass = new DataLayer.CityClass();
return(cityclass.Save(C));
}
