public DataTable InsertState(State_Model state_Model) { DAL.onLocal(); DAL.Open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@name", SqlDbType.NVarChar); param[0].Value = state_Model.name; param[1] = new SqlParameter("@id", SqlDbType.Int); param[1].Value = state_Model.id; param[2] = new SqlParameter("@price", SqlDbType.Float); param[2].Value = state_Model.price; param[3] = new SqlParameter("@state", SqlDbType.Int); param[3].Value = state_Model.state; param[4] = new SqlParameter("@user", SqlDbType.Int); param[4].Value = state_Model.userid; param[5] = new SqlParameter("@date", SqlDbType.DateTime); param[5].Value = state_Model.Date; DataTable dt = DAL.SelectData("InsertState", param); DAL.Close(); return(dt); }
public DataTable locationsInsertUpdate(State_Model state_Model) { DataTable dt = new DataTable(); DAL2.onOnLine(); MySqlParameter[] param = new MySqlParameter[4]; param[0] = new MySqlParameter("@id", state_Model.id); param[1] = new MySqlParameter("@name", state_Model.name); param[2] = new MySqlParameter("@price", state_Model.price); param[3] = new MySqlParameter("@state", state_Model.state); dt = DAL2.SelectData("CALL locationsInsertUpdate( @id, @name,@price,@state );", param); return(dt); }