public ActionResult Edit(int id)
{
try
{
ViewBag.Saved = false;
StayBazar.Areas.Admin.Models.StateModel mbt = new StateModel()
{
StateId = 0
};
CLayer.State pt = BLayer.State.Get(id);
if (pt != null)
{
mbt = new StateModel()
{
StateId = pt.StateId,
Name = pt.Name,
CountryId = pt.CountryId,
GSTStateCode = pt.GSTStateCode
}
}
;
return(PartialView("_Edit", mbt));
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
return(Redirect("~/Admin/ErrorPage"));
}
}
public CLayer.State Get(int stateId)
{
CLayer.State state = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._Int, stateId));
DataTable dt = Connection.GetTable("state_Get", param);
if (dt.Rows.Count > 0)
{
state = new CLayer.State();
state.StateId = Connection.ToInteger(dt.Rows[0]["StateId"]);
state.Name = Connection.ToString(dt.Rows[0]["Name"]);
state.CountryId = Connection.ToInteger(dt.Rows[0]["CountryId"]);
state.GSTStateCode = Connection.ToString(dt.Rows[0]["GSTStateCode"]);
}
else
{
state = new CLayer.State();
state.StateId = 0;
state.Name = "";
state.CountryId = 0;
state.GSTStateCode = "";
}
return(state);
}
public ActionResult Edit(StayBazar.Areas.Admin.Models.StateModel data)
{
try
{
if (ModelState.IsValid)
{
CLayer.State pt = new CLayer.State()
{
StateId = data.StateId,
Name = data.Name,
CountryId = data.CountryId,
GSTStateCode = data.GSTStateCode
};
BLayer.State.Save(pt);
ViewBag.Saved = true;
}
else
{
ViewBag.Saved = false;
}
return(RedirectToAction("Index", new { id = data.CountryId }));
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
return(Redirect("~/Admin/ErrorPage"));
}
}
public int Save(CLayer.State state)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._Int, state.StateId));
param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, state.Name));
param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._Int, state.CountryId));
param.Add(Connection.GetParameter("pGSTStateCode", DataPlug.DataType._Varchar, state.GSTStateCode));
object result = Connection.ExecuteQueryScalar("state_Save", param);
return(Connection.ToInteger(result));
}
public CLayer.State GetStateID(string cityname, long CountryID)
{
CLayer.State state = null;
string sql = "SELECT StateId,Name FROM state WHERE countryid=" + CountryID + " AND NAME='" + cityname + "'";
DataTable dt = Connection.GetSQLTable(sql);
List <CLayer.Property> result = new List <CLayer.Property>();
if (dt.Rows.Count > 0)
{
state = new CLayer.State();
state.StateId = Connection.ToInteger(dt.Rows[0]["StateId"]);
state.Name = Connection.ToString(dt.Rows[0]["Name"]);
//state.CountryId = Connection.ToInteger(dt.Rows[0]["CountryId"]);
//state.GSTStateCode = Connection.ToString(dt.Rows[0]["GSTStateCode"]);
}
else
{
state = new CLayer.State();
state.StateId = 0;
state.Name = "";
}
return(state);
}
public int UpdateGDSState(int CountryID, string State = "Others")
{
int result = 0;
string sql = "SELECT COUNT(*) FROM state WHERE CountryID='" + CountryID + "' and Name='" + State + "'";
object obj = Connection.ExecuteSQLQueryScalar(sql);
if (Connection.ToInteger(obj) < 1)
{
CLayer.State objState = new CLayer.State();
objState.CountryId = CountryID;
objState.Name = State;
objState.StateId = 0;
objState.GSTStateCode = State;
result = Save(objState);
}
else
{
sql = "SELECT stateid FROM state WHERE CountryID='" + CountryID + "' and Name='" + State + "'";
obj = Connection.ExecuteSQLQueryScalar(sql);
result = Connection.ToInteger(obj);
}
return(result);
}
public static int Save(CLayer.State data)
{
DataLayer.State state = new DataLayer.State();
data.Validate();
return(state.Save(data));
}
