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