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