public dynamic Displaymissedorders([FromBody] orderdetails od)
{
string plantid = od.plantid;
int metricid = od.metricid;
int week = od.week;
switch (metricid)
{
case 1:
break;
case 5:
var reason = _context.Metricbasedreasoncodeview.Where(p => p.MetricId == metricid).Select(q => new
{
q.ReasonCode,
q.ReasonCodeId
}).ToArray();
var orderdetails = (from shopflor in _context.ShopFloorComformance
join resoncode in _context.ReasonCodes
on shopflor.ReasonCodeId equals resoncode.ReasonCodeId into joinreason
from _reasoncode in joinreason.DefaultIfEmpty()
where shopflor.PlantId == plantid && shopflor.Week == week && shopflor.Flag == "Miss"
//&& _reasoncode.Flag == 1
select new
{
_reasoncode.ReasonCode,
shopflor.ReasonCodeId,
shopflor.Resource,
shopflor.PlantName,
shopflor.PlantId,
shopflor.ProcessOrder,
shopflor.OrderQuantity,
shopflor.MaterialId,
shopflor.MaterialName,
shopflor.OrderQuantityUnit,
shopflor.Flag,
shopflor.FinishDateConfirmed,
shopflor.FinishDateScheduled,
shopflor.ReasonCornerFlag
}).ToArray();
// return new Array[] { orders, reason, reasoncode };
return(new Array[] { orderdetails, reason });
break;
}
return(null);
}
public List <orderdetails> orderdetails(string orderdetails, string restcode)
{
try
{
GetConnectionString getConnectionString = new GetConnectionString();
string ConnectionString = getConnectionString.CustomizeConnectionString(restcode);
SqlConnection Conn = new SqlConnection(ConnectionString);
Conn.Open();
List <orderdetails> ordetails = new List <orderdetails>();
if (Conn.State != System.Data.ConnectionState.Open)
{
Conn.Open();
}
SqlCommand cmd = new SqlCommand("sploadcartforconformpage", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Orderid", orderdetails);
SqlDataReader _Reader = cmd.ExecuteReader();
while (_Reader.Read())
{
orderdetails objCust = new orderdetails();
objCust.Price = Convert.ToInt16(_Reader["price"]);
objCust.Quantity = Convert.ToInt16(_Reader["Quantity"]);
objCust.ProductName = _Reader["ProductName"].ToString();
//objCust.Image = _Reader["Image"];
ordetails.Add(objCust);
}
return(ordetails);
}
catch (Exception ex)
{
throw ex;
}
//finally
//{
// //if (Conn != null)
// //{
// // //if (Conn.State == ConnectionState.Open)
// // //{
// // // Conn.Close();
// // // Conn.Dispose();
// // //}
// //}
//}
//}
}
public IHttpActionResult placeorder([FromBody] villageorders order, [FromUri] string email, [FromUri] string pid)
{
var data = orderrepo.InsertOrder(order, email);
var cartdetails = prdctdetails.getproductbyid(pid).ToArray();
orderdetails orderdetail = new orderdetails();
for (var i = 0; i < cartdetails.Length; i++)
{
var detail = cartdetails[i];
orderdetail.ProductId = detail.id.ToString();
orderdetail.Quantity = detail.Quantity;
orderdetail.orderid = data;
var orderdetails = orderrepo.InsertOrderdetails(orderdetail);
}
return(Json(data));
}
public string check(string paymentmethod)
{
foodorder objOrder = new foodorder();
objOrder.ORDERDATE = DateTime.Now;
objOrder.CUSTID = GetSessionUser().CUSTID;
objOrder.PAYMENTMETHOD = paymentmethod;
int amount = 0;
foreach (var item in GetSessionCart())
{
amount += item.subtotal;
}
objOrder.AMOUNT = amount;
orderdetails objOrderDetails = new orderdetails();
MySqlConnection conn = Shared.BaseManager.PrimaryConnection();
conn.Open();
var transaction = conn.BeginTransaction();
string ret = foodorderManager.Savefoodorder(objOrder, conn, transaction);
int orderid;
if (!ret.Equals(Shared.Constants.MSG_ERR_DBSAVE.Text))
{
orderid = int.Parse(ret);
foreach (var item in GetSessionCart())
{
if (!ret.Equals(Shared.Constants.MSG_ERR_DBSAVE.Text))
{
objOrderDetails.ORDERID = orderid;
objOrderDetails.ITEMID = item.ITEMID;
objOrderDetails.QUANTITY = item.QUANTITY;
ret = orderdetailsManager.Saveorderdetails(objOrderDetails, conn, transaction);
}
}
if (paymentmethod == "Wallet")
{
wallet objwallet = new wallet();
List <wallet> lstwallet = walletManager.Getwallet("CustomerID='" + GetSessionUser().CUSTID + "'");
if (lstwallet.First().BALANCE > amount)
{
objwallet.WALLETID = lstwallet.First().WALLETID;
objwallet.CUSTOMERID = GetSessionUser().CUSTID;
objwallet.BALANCE = lstwallet.First().BALANCE - amount;
ret = walletManager.Savewallet(objwallet, conn, transaction);
}
else
{
ret = "insufficient amount in wallet";
transaction.Rollback();
conn.Close();
conn.Dispose();
return(ret);
}
}
else if (paymentmethod == "MasterCard")
{
}
if (ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text))
{
payment objpayment = new payment();
objpayment.ORDERID = orderid;
objpayment.PAYMENTDATE = DateTime.Now;
ret = paymentManager.Savepayment(objpayment, conn, transaction);
}
if (ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text))
{
transaction.Commit();
conn.Close();
conn.Dispose();
return(Shared.Constants.MSG_SUCCESS.Text);
}
}
transaction.Rollback();
conn.Close();
conn.Dispose();
return(Shared.Constants.MSG_ERR_SERVER.Text);
}
public void View1(orderdetails obj)
{
string ret = orderdetailsManager.Saveorderdetails(obj);
}
