public HttpResponseMessage AddItemToGuide([FromBody] OrderGuides.OrderGuide orderguide)
{
try
{
Logger.WriteLine("Adding item to Order Guide..");
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString);
using (connect)
{
SqlCommand cmd = new SqlCommand("INSERT INTO masterOrderGuide (prodCode, unit_id, group_id, qty, itemComment, sortOrder) VALUES (@prodCode, @unit_id, @group_id, @qty, @itemComment, @sortOrder)", connect);
cmd.Parameters.AddWithValue("@prodCode", orderguide.Code);
cmd.Parameters.AddWithValue("@unit_id", orderguide.Unit);
cmd.Parameters.AddWithValue("@group_id", orderguide.groupID);
cmd.Parameters.AddWithValue("@qty", orderguide.Qty);
cmd.Parameters.AddWithValue("@itemComment", orderguide.Comment);
cmd.Parameters.AddWithValue("@sortOrder", orderguide.sortOrder);
connect.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Logger.WriteLine("Exception @ AddItemToGuide() : " + ex.Message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
var message = Request.CreateResponse(HttpStatusCode.OK);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
Logger.WriteLine("Adding Item to Guide Successful. Item : " + orderguide.Code.ToString() + ", Group ID : " + orderguide.groupID.ToString());
return(message);
}
public HttpResponseMessage DeleteItemFromGuide([FromBody] OrderGuides.OrderGuide orderguide)
{
try
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString);
using (connect)
{
SqlCommand cmd = new SqlCommand("Delete From masterOrderGuide Where group_id = @groupID AND (prodCode = @prodCode AND unit_id = @unit_id)", connect);
cmd.Parameters.AddWithValue("@prodCode", orderguide.Code);
cmd.Parameters.AddWithValue("@unit_id", orderguide.Unit);
cmd.Parameters.AddWithValue("@groupID", orderguide.groupID);
connect.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Logger.WriteLine("Exception @ DeleteItemFromGuide() : " + ex.Message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
var message = Request.CreateResponse(HttpStatusCode.OK);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
Logger.WriteLine("Item Deleted from Guide. Item : " + orderguide.Code.ToString() + ", Unit : " + orderguide.Unit + " , Group ID : " + orderguide.groupID.ToString());
return(message);
}
public HttpResponseMessage GetSessionCart()
{
Logger.WriteLine("Fetching Session Cart....");
string custCode = login.GetLoggedInUser.m_sessionCustomer;
string orderNumber = login.GetLoggedInUser.m_sessionOrderNum;
int? priceLevel = login.GetLoggedInUser.m_priceLevel;
List <OrderGuides.OrderGuide> OrderGuides = new List <OrderGuides.OrderGuide>();
try
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString);
using (connect)
{
SqlCommand cmd = new SqlCommand();
if (login.GetLoggedInUser.m_showPrices > 0)
{
cmd = new SqlCommand("SELECT SessionCart.Row_ID, SessionCart.orderNum, SessionCart.custCode, SessionCart.qtySold, SessionCart.prodCode," +
"SessionCart.itemComment, SessionCart.Unit_ID, Products.Description, Products.Pk_Wt_Sz, Products.Pack, Products.Weight," +
" Products.Case_ID, Products.Each_ID, Products.Pound_ID, Products.Default_ID, " +
"Prices.Sell_Price, Prices.SellID, Products.Product_Categ FROM SessionCart INNER JOIN Products ON SessionCart.ProdCode = " +
"Products.Product_Code INNER JOIN Prices ON SessionCart.ProdCode = Prices.Product_Code " +
"AND sessionCart.Unit_ID = Prices.SellID WHERE (SessionCart.orderNum = @orderNum" +
") AND (Prices.Price_Level = @priceLevel AND Prices.Sell_Price > 0) ORDER BY SessionCart.Row_ID;", connect);
cmd.Parameters.AddWithValue("@orderNum", orderNumber);
cmd.Parameters.AddWithValue("@priceLevel", priceLevel);
}
else
{
cmd = new SqlCommand("SELECT SessionCart.Row_ID, SessionCart.orderNum, SessionCart.custCode, SessionCart.qtySold, SessionCart.prodCode," +
"SessionCart.itemComment, SessionCart.Unit_ID, Products.Description, Products.Pk_Wt_Sz, Products.Pack, Products.Weight ," +
" Products.Case_ID, Products.Each_ID, Products.Pound_ID, Products.Product_Categ, Products.Default_ID, Prices.SellID " +
" FROM SessionCart INNER JOIN Products ON SessionCart.ProdCode = Products.Product_Code INNER JOIN Prices ON SessionCart.ProdCode = Prices.Product_Code" +
" AND sessionCart.Unit_ID = Prices.SellID WHERE (SessionCart.orderNum = @orderNum) AND (Prices.Price_Level = @priceLevel AND Prices.Sell_Price > 0) ORDER BY SessionCart.Row_ID; ", connect);
cmd.Parameters.AddWithValue("@custCode", custCode);
cmd.Parameters.AddWithValue("@orderNum", orderNumber);
cmd.Parameters.AddWithValue("@priceLevel", priceLevel);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
OrderGuides.OrderGuide og = new OrderGuides.OrderGuide();
if (login.GetLoggedInUser.m_showPrices > 0)
{
og.showPrices = true;
og.sellPrice = dr["Sell_Price"].ToString();
}
else
{
og.showPrices = false;
}
og.RowID = Convert.ToInt64(dr["Row_ID"].ToString());
og.Code = dr["prodCode"].ToString().Trim();
if (dr["Product_Categ"].ToString().Contains("17-") || dr["Product_Categ"].ToString().Contains("19-"))
{
og.isManufactured = true;
og.Weight = Convert.ToDouble(dr["Weight"]);
}
else
{
og.isManufactured = false;
}
og.Comment = dr["itemComment"].ToString();
og.Qty = Convert.ToDouble(dr["qtySold"].ToString());
og.SellID = dr["SellID"].ToString();
og.Case_ID = dr["Case_ID"].ToString();
og.Each_ID = dr["Each_ID"].ToString();
og.Pound_ID = dr["Pound_ID"].ToString();
if (og.SellID == "C")
{
if (!string.IsNullOrEmpty(og.Case_ID))
{
og.Unit = og.Case_ID;
}
else
{
og.Unit = "Cs";
}
}
else if (og.SellID == "E")
{
if (!string.IsNullOrEmpty(og.Each_ID))
{
og.Unit = og.Each_ID;
}
else
{
og.Unit = "Ea";
}
}
else
{
if (!string.IsNullOrEmpty(og.Pound_ID))
{
og.Unit = og.Pound_ID;
}
else
{
og.Unit = "Lb";
}
}
og.Description = dr["Description"].ToString();
og.PackWeight = dr["Pk_Wt_Sz"].ToString();
if (og.PackWeight == "" || og.PackWeight == string.Empty)
{
og.PackWeight = dr["Pack"].ToString() + "/" + dr["Weight"].ToString();
}
OrderGuides.Add(og);
}
}
else
{
Request.CreateResponse(HttpStatusCode.OK, "Current Order is Empty.");
}
}
}
catch (Exception ex)
{
Logger.WriteLine("Exception @ GetSessionCart() : " + ex.Message);
return(Request.CreateResponse(HttpStatusCode.NotFound, ex));
}
var message = Request.CreateResponse(HttpStatusCode.OK, OrderGuides);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
Logger.WriteLine("Fetching SessionCart successful.");
return(message);
}
public HttpResponseMessage ShowMasterOrderGuide(int groupID)
{
Logger.WriteLine("Fetching master order guide content....");
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnection"].ConnectionString);
string userName = login.GetLoggedInUser.custCode;
try
{
List <OrderGuides.OrderGuide> orderguide = new List <OrderGuides.OrderGuide>();
using (connect)
{
SqlCommand cmd = new SqlCommand("MOG_showGuide", connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@groupID", groupID);
cmd.Parameters.AddWithValue("@custCode", userName);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
OrderGuides.OrderGuide od = new OrderGuides.OrderGuide();
od.groupID = groupID;
od.delColumn = "<a data-toggle='tooltip' data-placement='right' title='Delete Item From Guide' class='DelFrmGuide' href='#Delete' id ='deleteGuideBtn'><span class='glyphicon glyphicon-minus-sign'></a>";
od.Code = row["prodCode"].ToString().Trim();
if (od.Code == string.Empty || od.Code == null)
{
var msg = Request.CreateResponse(HttpStatusCode.OK, "no content");
msg.Headers.Location = new Uri(Request.RequestUri.ToString());
return(msg);
}
od.Description = row["Description"].ToString();
od.PackWeight = row["Pk_Wt_Sz"].ToString();
if (od.PackWeight == "" || od.PackWeight == string.Empty)
{
od.PackWeight = row["Pack"].ToString() + "/" + row["Weight"].ToString();
}
od.Qty = Convert.ToInt16(row["qty"].ToString());
od.Unit = row["unit_id"].ToString();
od.Comment = row["itemComment"].ToString();
od.sortOrder = Convert.ToInt32(row["sortOrder"]);
orderguide.Add(od);
}
}
}
var message = Request.CreateResponse(HttpStatusCode.OK, orderguide);
message.Headers.Location = new Uri(Request.RequestUri.ToString());
Logger.WriteLine("Fetching master order guide content successful. Group ID: " + groupID.ToString());
return(message);
}
catch (Exception ex)
{
Logger.WriteLine("Exception @ ShowMasterOrderGuide() : " + ex.Message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
