//Add State
public int Add(Mater_State s)
{
int i;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string q = "insert into Mater_State(StateCode,StateName,StateInitial,CountryCode) values(@StateCode,@StateName,@StateInitial,@CountryCode)";
SqlCommand com = new SqlCommand(q, con);
com.Parameters.AddWithValue("@StateCode", s.StateCode);
com.Parameters.AddWithValue("@StateName", s.StateName);
com.Parameters.AddWithValue("@StateInitial", s.StateInitial);
com.Parameters.AddWithValue("@CountryCode", s.CountryCode);
i = com.ExecuteNonQuery();
}
return(i);
}
//update state
public int Updatestate(Mater_State s)
{
int i;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
string q = "update Mater_State set StateName=@StateName,StateInitial=@StateInitial where StateCode=@StateCode";
SqlCommand com = new SqlCommand(q, con);
com.Parameters.AddWithValue("@StateCode", s.StateCode);
com.Parameters.AddWithValue("@StateName", s.StateName);
com.Parameters.AddWithValue("@StateInitial", s.StateInitial);
i = com.ExecuteNonQuery();
}
return(i);
}
public JsonResult Updatestate(Mater_State s)
{
return(Json(db.Updatestate(s), JsonRequestBehavior.AllowGet));
}
