public Orders getFoodHistory(string userid)
{
Orders orders = new Orders();
try
{
DataSet ds = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@userid", userid);
ds = DBConnectionSQL.gettable("GetFoodHistory", param);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
orders.id = Convert.ToInt32(dr["id"]);
orders.orderBy = dr["email_id"].ToString();
orders.full_name = dr["full_name"].ToString();
orders.is_ready = Convert.ToBoolean(dr["is_ready"]);
orders.orderAt = dr["order_at"].ToString();
orders.totalPrice = Convert.ToDouble(dr["total_price"]);
orders.foodOrders = getFoodOrderDetails(orders.id);
}
}
}
catch (Exception ex)
{
throw new Exception("Error" + ex.Message);
}
return(orders);
}
public Orders getOrderByAdmin()
{
Orders orders = new Orders();
try
{
DataSet ds = new DataSet();
ds = DBConnectionSQL.gettable("GetFoodOrder", null);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
orders.id = Convert.ToInt32(dr["id"]);
orders.orderBy = dr["email_id"].ToString();
orders.full_name = dr["full_name"].ToString();
orders.orderAt = dr["order_at"].ToString();
orders.totalPrice = Convert.ToDouble(dr["total_price"]);
orders.foodOrders = getFoodOrderDetails(orders.id);
}
}
}
catch (Exception ex)
{
throw new Exception("Error" + ex.Message);
}
return(orders);
}
public AdminLogin LoginIn(AdminLogin admin)
{
DataSet ds = new DataSet();
AdminLogin objLogin = new AdminLogin();
try
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@username", admin.userName);
param[1] = new SqlParameter("@password", admin.password);
ds = DBConnectionSQL.gettable("getLoginAdmin", param);
foreach (DataRow dr in ds.Tables[0].Rows)
{
objLogin.userName = dr["user_name"].ToString();
objLogin.userFullName = dr["full_name"].ToString();
objLogin.isLogin = true;
}
}
catch (Exception)
{
objLogin.isLogin = false;
throw;
}
return(objLogin);
}
public bool deleteMenu(int id)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", id);
int a = DBConnectionSQL.executeProcedure("delete_menu", param);
if (a > 0)
{
return(true);
}
return(false);
}
public bool savemenu(List <Menu> menu)
{
SqlConnection conn = DBConnectionSQL.getConnection();
using (conn)
{
SqlTransaction tran;
tran = conn.BeginTransaction();
try
{
SqlCommand cmd;
foreach (var objAtt in menu)
{
if (objAtt._id != null)
{
cmd = new SqlCommand("update_menu", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = objAtt._id;
cmd.Parameters.Add("@menuname", SqlDbType.VarChar, 100).Value = objAtt.menuName;
cmd.Parameters.Add("@price", SqlDbType.Float).Value = objAtt.price;
cmd.Parameters.Add("@isavailable", SqlDbType.Bit).Value = objAtt.isAvailable;
cmd.Parameters.Add("@stock", SqlDbType.VarChar, 100).Value = objAtt.stock;
cmd.ExecuteNonQuery();
}
else
{
cmd = new SqlCommand("ins_menu", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@menuname", SqlDbType.VarChar, 100).Value = objAtt.menuName;
cmd.Parameters.Add("@price", SqlDbType.Float).Value = objAtt.price;
cmd.Parameters.Add("@isavailable", SqlDbType.Bit).Value = objAtt.isAvailable;
cmd.Parameters.Add("@stock", SqlDbType.VarChar, 100).Value = objAtt.stock;
cmd.ExecuteNonQuery();
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return(false);
throw new Exception("Error" + ex.Message);
}
}
return(true);
}
public bool saveUserDetails(User user)
{
SqlConnection conn = DBConnectionSQL.getConnection();
using (conn)
{
SqlTransaction tran;
tran = conn.BeginTransaction();
try
{
SqlCommand cmd;
cmd = new SqlCommand("user_register", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = user._id;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 100).Value = user.email;
cmd.Parameters.Add("@firstname", SqlDbType.VarChar, 100).Value = user.firstName;
cmd.Parameters.Add("@middlename", SqlDbType.VarChar, 100).Value = user.middleName;
cmd.Parameters.Add("@lastname", SqlDbType.VarChar, 100).Value = user.lastName;
cmd.Parameters.Add("@phonenumber", SqlDbType.VarChar, 100).Value = user.phoneNumber;
cmd.Parameters.Add("@shift", SqlDbType.VarChar, 100).Value = user.shift;
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
user._id = (int)cmd.Parameters["@id"].Value;
cmd = new SqlCommand("ins_register_user", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = user._id;
cmd.Parameters.Add("@username", SqlDbType.VarChar, 100).Value = user.userName;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 100).Value = user.password;
cmd.ExecuteNonQuery();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return(false);
throw new Exception("Error" + ex.Message);
}
return(true);
}
}
public List <FoodOrders> getFoodOrderDetails(int orderId)
{
List <FoodOrders> lst = new List <FoodOrders>();
DataSet ds = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@orderid", orderId);
ds = DBConnectionSQL.gettable("GetFoodOrder", param);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
FoodOrders objATT = new FoodOrders();
objATT.foodName = dr["menu_name,"].ToString();
objATT.quantity = dr["quantity"].ToString();
objATT.price = Convert.ToDouble(dr["price"]);
lst.Add(objATT);
}
}
return(lst);
}
public List <Menu> getMenu()
{
List <Menu> lst = new List <Menu>();
DataSet ds = new DataSet();
ds = DBConnectionSQL.gettable("GetMenu", null);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Menu objATT = new Menu();
objATT._id = Convert.ToInt32(dr["id"]);
objATT.menuName = dr["menu_name"].ToString();
objATT.price = Convert.ToDouble(dr["price"]);
objATT.stock = dr["quantity"].ToString();
objATT.isAvailable = Convert.ToBoolean(dr["is_available"]);
lst.Add(objATT);
}
}
return(lst);
}
public Orders saveFoodOrder(Orders order)
{
SqlConnection conn = DBConnectionSQL.getConnection();
using (conn)
{
SqlTransaction tran;
tran = conn.BeginTransaction();
try
{
SqlCommand cmd;
cmd = new SqlCommand("ins_orders", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@orderBy", SqlDbType.VarChar, 100).Value = order.orderBy;
cmd.Parameters.Add("@totalAmount", SqlDbType.Float).Value = order.totalPrice;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = order.id;
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
order.id = (int)cmd.Parameters["@id"].Value;
foreach (var obj in order.foodOrders)
{
cmd = new SqlCommand("ins_orders_foods", conn, tran);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@orderId", SqlDbType.Int).Value = order.id;
cmd.Parameters.Add("@foodId", SqlDbType.Int).Value = obj.foodId;
cmd.Parameters.Add("@quantity", SqlDbType.VarChar, 100).Value = obj.quantity;
cmd.Parameters.Add("@totalprice", SqlDbType.Float).Value = obj.price;
cmd.ExecuteNonQuery();
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception("Error" + ex.Message);
}
return(order);
}
}
public List <Orders> getSalesReport(SalesReport sales)
{
List <Orders> lst = new List <Orders>();
DataSet ds = new DataSet();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@fromDate", sales.fromDate);
param[1] = new SqlParameter("@toDate", sales.toDate);
ds = DBConnectionSQL.gettable("GetSalesReports", param);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Orders objATT = new Orders();
objATT.orderBy = dr["menu_name,"].ToString();
objATT.orderAt = dr["quantity"].ToString();
objATT.totalPrice = Convert.ToDouble(dr["price"]);
lst.Add(objATT);
}
}
return(lst);
}
