public static void insert_menu_category(menu_category_model menu)
{
My_Connection conn = new My_Connection();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@name", menu.menu_category_name);
p[1] = new SqlParameter("@status", menu.menu_category_status);
conn.insert("sp_menu_category_insert", p);
}
public static void update(menu_category_model menu)
{
My_Connection conn = new My_Connection();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@menu_category_id", menu.menu_category_id);
p[1] = new SqlParameter("@menu_category_name", menu.menu_category_name);
p[2] = new SqlParameter("@menu_category_status", menu.menu_category_status);
conn.update("sp_menu_category_update", p);
}
public static List <menu_category_model> select_all()
{
List <menu_category_model> li = new List <menu_category_model>();
My_Connection conn = new My_Connection();
DataSet ds = conn.select_all("sp_menu_category_select_all");
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
menu_category_model menu = new menu_category_model();
menu.menu_category_id = int.Parse(dr["menu_category_id"].ToString());
menu.menu_category_name = dr["menu_category_name"].ToString();
menu.menu_category_status = Boolean.Parse(dr["menu_category_status"].ToString());
li.Add(menu);
}
return(li);
}
public static menu_category_model select_id(int menu_category_id)
{
My_Connection conn = new My_Connection();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@menu_category_id", menu_category_id);
DataSet ds = conn.select_id("sp_menu_category_select_id", p);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
menu_category_model menu = new menu_category_model();
menu.menu_category_id = int.Parse(dr["menu_category_id"].ToString());
menu.menu_category_name = dr["menu_category_name"].ToString();
menu.menu_category_status = Boolean.Parse(dr["menu_category_status"].ToString());
return(menu);
}
}
