private static orderdetails ReaderDataOrderTotalAmount(MySqlDataReader reader) { orderdetails objorderdetails = new orderdetails(); objorderdetails.TOTAL = Utility.IsValidInt(reader["TOTAL"]); return(objorderdetails); }
public static string Saveorderdetails(orderdetails objorderdetails, MySqlConnection conn = null, MySqlTransaction trans = null) { string returnMessage = ""; //string sORDERID = ""; //sORDERID = objorderdetails.ORDERID.ToString(); //var templstorderdetails = Getorderdetails("ORDERID='" + sORDERID + "'", conn); try { bool isConnArgNull = (conn != null) ? false : true; MySqlConnection connection = (conn != null) ? conn : PrimaryConnection(); //MySqlConnection connection = new MySqlConnection("server=32.148.68.125;user id = testusr; password=Testusr123!@#; database=testdatabase"); tryOpenConnection(connection); using (MySqlCommand command = new MySqlCommand()) { string sql; sql = @"INSERT INTO ORDERDETAILS(ORDERID,ITEMID,QUANTITY) VALUES (@ORDERID,@ITEMID,@QUANTITY)"; if (trans != null) { command.Transaction = trans; } command.Connection = connection; command.CommandType = CommandType.Text; command.CommandText = sql; command.Parameters.AddWithValue("@ORDERID", objorderdetails.ORDERID); command.Parameters.AddWithValue("@ITEMID", objorderdetails.ITEMID); command.Parameters.AddWithValue("@QUANTITY", objorderdetails.QUANTITY); int affectedRows = command.ExecuteNonQuery(); if (affectedRows > 0) { returnMessage = "OK"; } else { returnMessage = Constants.MSG_ERR_DBSAVE.Text; } } if (isConnArgNull == true) { connection.Dispose(); } } catch (Exception ex) { } return(returnMessage); }
private static orderdetails ReaderDataorderdetails(MySqlDataReader reader) { orderdetails objorderdetails = new orderdetails(); objorderdetails.ORDERID = Utility.IsValidInt(reader["ORDERID"]); objorderdetails.ITEMID = Utility.IsValidInt(reader["ITEMID"]); objorderdetails.QUANTITY = Utility.IsValidInt(reader["QUANTITY"]); return(objorderdetails); }
private static orderdetails ReaderDataOrderDetailsItem(MySqlDataReader reader) { orderdetails objorderdetails = new orderdetails(); objorderdetails.ITEMNAME = Utility.IsValidString(reader["ITEMNAME"]); objorderdetails.PRICE = Utility.IsValidInt(reader["PRICE"]); objorderdetails.QUANTITY = Utility.IsValidInt(reader["QUANTITY"]); objorderdetails.AMOUNTSUBTOTAL = Utility.IsValidInt(reader["SUBTOTAL"]); return(objorderdetails); }
public static int getTotalAmount(string OrderId, MySqlConnection conn = null) { int Amount; orderdetails obj = new orderdetails(); obj = orderdetailsManager.getTotalAmount(OrderId, conn); Amount = obj.TOTAL; return(Amount); }
public static List <orderdetails> Getorderdetails(string whereclause, MySqlConnection conn = null) { orderdetails objorderdetails = new orderdetails(); List <orderdetails> lstorderdetails = new List <orderdetails>(); try { bool isConnArgNull = (conn != null) ? false : true; MySqlConnection connection = (conn != null) ? conn : PrimaryConnection(); tryOpenConnection(connection); string sql = "select * from orderdetails "; if (!string.IsNullOrEmpty(whereclause)) { sql += " where " + whereclause; } using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = sql; using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { objorderdetails = ReaderDataorderdetails(reader); lstorderdetails.Add(objorderdetails); } } else { } } } if (isConnArgNull == true) { connection.Dispose(); } } catch { } return(lstorderdetails); }
public static List <orderdetails> GetOrderDetailsItem(string ORDERID, MySqlConnection conn = null) { orderdetails objorderdetails = null; List <orderdetails> lstorderdetails = new List <orderdetails>(); try { bool isConnArgNull = (conn != null) ? false : true; MySqlConnection connection = (conn != null) ? conn : PrimaryConnection(); tryOpenConnection(connection); string sql = "SELECT D.ORDERID, F.ITEMNAME, F.PRICE, SUM(D.QUANTITY) AS QUANTITY, SUM(D.QUANTITY * F.PRICE) AS SUBTOTAL FROM orderdetails D INNER JOIN fooditem F ON D.ITEMID = F.ITEMID WHERE (D.ORDERID= " + (ORDERID) + ") GROUP BY D.ORDERID, F.ITEMNAME"; //if (!string.IsNullOrEmpty(whereclause)) // sql += " where " + whereclause; using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = sql; using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { objorderdetails = ReaderDataOrderDetailsItem(reader); lstorderdetails.Add(objorderdetails); } } else { } } } if (isConnArgNull == true) { connection.Dispose(); } } catch (Exception ex) { } return(lstorderdetails); }