//Add CityArea
public int AddCityArea(Master_CityArea ca)
{
int i;
bool isnotValid = false;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string q = "select count(*) from Master_CityArea where AreaCode=@AreaCode";
SqlCommand com = new SqlCommand(q, con);
com.Parameters.AddWithValue("@AreaCode", ca.AreaCode);
isnotValid = (int)com.ExecuteScalar() > 0;
if (isnotValid)
{
i = 0;
return(i);
}
}
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string q = "insert into Master_CityArea(AreaCode,AreaName,CityCode) values(@AreaCode,@AreaName,@CityCode)";
SqlCommand com = new SqlCommand(q, con);
com.Parameters.AddWithValue("@AreaCode", ca.AreaCode);
com.Parameters.AddWithValue("@AreaName", ca.AreaName);
com.Parameters.AddWithValue("@CityCode", ca.CityCode);
i = com.ExecuteNonQuery();
}
return(i);
}
//update cityarea
public int Updatecityarea(Master_CityArea a)
{
int i;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string q = "update Master_CityArea set AreaName=@AreaName where AreaCode=@AreaCode";
SqlCommand com = new SqlCommand(q, con);
com.Parameters.AddWithValue("@AreaCode", a.AreaCode);
com.Parameters.AddWithValue("@AreaName", a.AreaName);
i = com.ExecuteNonQuery();
}
return(i);
}
public JsonResult Updatecityarea(Master_CityArea c)
{
return(Json(db.Updatecityarea(c), JsonRequestBehavior.AllowGet));
}
public JsonResult Addcityarea(Master_CityArea ca)
{
return(Json(db.AddCityArea(ca), JsonRequestBehavior.AllowGet));
}