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