public orderObj salve(orderObj _data)
{
try
{
orderModel _model = new orderModel();
if (_data.orderId == 0)
{
_data = _model.insert(_data);
}
else
{
_data = _model.update(_data);
}
return(_data);
}
catch (HttpResponseException httpEx)
{
throw httpEx;
}
catch (Exception ex)
{
Log.Error("Falha ao salvar a comanda " + "\r\n" + ex.Message + "\r\n" + ex.Source + "\r\n" + ex.StackTrace);
HttpResponseMessage response = new HttpResponseMessage(System.Net.HttpStatusCode.InternalServerError);
response.ReasonPhrase = "Falha ao salvar a comanda";
throw new HttpResponseException(response);
}
}
public IHttpActionResult Return_item([FromUri] int item_id, [FromUri] int qty, [FromUri] int oid)
{
order o = new orderModel().GetAll().Where(x => x.id == oid).ToList()[0];
order_items oi = new order_itemsModel().GetAll().Where(x => x.oid == o.id && x.item_id == item_id).ToList()[0];
oi.qty = oi.qty - qty;
oi.total = oi.total - oi.item.retail_price * qty;
oi.profit = oi.profit - (oi.item.retail_price - oi.item.original_price) * qty;
//oi.disc = oi.disc - oi.item.discount_price * qty;
new order_itemsModel().Update(oi);
o.total_amount = o.total_amount - (oi.item.retail_price * qty);
o.total_profit = o.total_profit - (oi.item.retail_price - oi.item.original_price) * qty;
new orderModel().Update(o);
order_return or = new order_return();
or.oid = oid;
or.dt = DateTime.Now;
or.user_id = User.Identity.GetUserId();
int id = new order_returnModel().Create(or);
order_return_items ori = new order_return_items();
ori.orid = id;
ori.item_id = item_id;
ori.qty = qty;
new order_return_itemModel().Create(ori);
item i = new itemModel().GetAll().Where(x => x.id == item_id).ToList()[0];
i.qty = i.qty + qty;
new itemModel().Update(i);
return(Ok());
}
public static int DeleteOrder(int orderId)
{
orderModel data = new orderModel
{
orderId = orderId
};
string sql = @"delete from [Order] where orderId = @orderId;";
return(SqlDataAccess.SaveData(sql, data));
}
public static List <orderModel> LoadOrder(string status)
{
orderModel data = new orderModel
{
status = status,
};
string sql = @"select orderId,partId,projectName,lastMaterialDate,shipDate,quantity,status,priority
from [Order] where status = @status;";
return(SqlDataAccess.LoadData <orderModel>(sql, data));
}
public static int setOrderSchedule(int orderId, string status)
{
orderModel data = new orderModel
{
orderId = orderId,
status = status
};
string sql = @"update [Order] set status=@status where orderId=@orderId;";
return(SqlDataAccess.SaveData(sql, data));
}
public static int updateOrder(int orderId, int partId, string projectName, DateTime lastMaterialDate, DateTime shipDate, int quantity, string status, int priority)
{
orderModel data = new orderModel
{
orderId = orderId,
partId = partId,
projectName = projectName,
lastMaterialDate = lastMaterialDate,
shipDate = shipDate,
quantity = quantity,
status = status,
priority = priority
};
string sql = @"update [Order] set partId=@partId,projectName=@projectName,lastMaterialDate=@lastMaterialDate,shipDate=@shipDate,quantity=@quantity, status=@status,priority=@priority where orderId=@orderId ;";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateOrder(int orderId, int partId, string projectName, DateTime lastMaterialDate,
DateTime shipDate, int quantity)
{
orderModel data = new orderModel
{
orderId = orderId,
partId = partId,
projectName = projectName,
lastMaterialDate = lastMaterialDate,
shipDate = shipDate,
quantity = quantity
};
string sql = @"insert into [Order] (orderId,partId,projectName,lastMaterialDate,shipDate,quantity)
values (@orderId,@partId,@projectName,CONVERT(datetime,@lastMaterialDate,104),CONVERT(datetime,@shipDate,104),@quantity);";
return(SqlDataAccess.SaveData(sql, data));
}
public List <orderListObj> getAllOrder(orderObj _data)
{
List <orderListObj> _listProduct = new List <orderListObj>();
try
{
orderModel _model = new orderModel();
_listProduct = _model.selectAll(_data);
return(_listProduct);
}
catch (HttpResponseException httpEx)
{
throw httpEx;
}
catch (Exception ex)
{
Log.Error("Falha na listagem das comandas " + "\r\n" + ex.Message + "\r\n" + ex.Source + "\r\n" + ex.StackTrace);
HttpResponseMessage response = new HttpResponseMessage(System.Net.HttpStatusCode.InternalServerError);
response.ReasonPhrase = "Falha na listagem das comandas";
throw new HttpResponseException(response);
}
}
public static orderModel orderMappingFunction(this SqlDataReader reader, bool isList = false)
{
var order = new orderModel();
try
{
if (!isList)
{
if (!reader.HasRows)
{
return(null);
}
reader.Read();
}
//fdID, fdNoEntryOrder, fdDepo, fdJenisOrder, fdNoOrder,
//fdRevisi, fdTanggalOrder, fdTanggalKirim, fdKodeLangganan, fdAlamatKirim,
//fdKodeSF, fdKodeGudang, fdKodeGudangTujuan, fdMataUang, fdNoReferensi,
//fdTglReferensi, fdRemarkPO, fdOrderTambahan, fdTransport, fdTerm_Days,
//fdTerm, fdDestinationPortID, fdShippingMark, fdIsFixed, fdStatus,
//fdReasonNotApprove, fdDisetujuiOleh, fdTglDisetujui, fdKodeEkspedisi, fdNoOrderSFA,
//fdTglSFA, fdStatusRecord, fdCreateUserID, fdCreateTS, fdUpdateUserID,
//fdUpdateTS, fdNoEntryLama
if (reader.IsColumnExists("fdID"))
{
order.fdID = SqlHelper.GetNullableBigInt(reader, "fdID");
}
if (reader.IsColumnExists("fdNoEntryOrder"))
{
order.fdNoEntryOrder = SqlHelper.GetNullableBigInt(reader, "fdNoEntryOrder");
}
if (reader.IsColumnExists("fdDepo"))
{
order.fdDepo = SqlHelper.GetNullableString(reader, "fdDepo");
}
if (reader.IsColumnExists("fdJenisOrder"))
{
order.fdJenisOrder = SqlHelper.GetNullableString(reader, "fdJenisOrder");
}
if (reader.IsColumnExists("fdNoOrder"))
{
order.fdNoOrder = SqlHelper.GetNullableString(reader, "fdNoOrder");
}
//fdRevisi, fdTanggalOrder, fdTanggalKirim, fdKodeLangganan, fdAlamatKirim,
if (reader.IsColumnExists("fdRevisi"))
{
order.fdRevisi = SqlHelper.GetNullableInt(reader, "fdRevisi");
}
if (reader.IsColumnExists("fdTanggalOrder"))
{
order.fdTanggalOrder = SqlHelper.GetNullableDatetime(reader, "fdTanggalOrder");
}
if (reader.IsColumnExists("fdTanggalKirim"))
{
order.fdTanggalKirim = SqlHelper.GetNullableDatetime(reader, "fdTanggalKirim");
}
if (reader.IsColumnExists("fdKodeLangganan"))
{
order.fdKodeLangganan = SqlHelper.GetNullableBigInt(reader, "fdKodeLangganan");
}
if (reader.IsColumnExists("fdNamaOutlet"))
{
order.fdNamaLangganan = SqlHelper.GetNullableString(reader, "fdNamaOutlet");
}
if (reader.IsColumnExists("fdAlamatKirim"))
{
order.fdAlamatKirim = SqlHelper.GetNullableString(reader, "fdAlamatKirim");
}
//fdKodeSF, fdKodeGudang, fdKodeGudangTujuan, fdMataUang, fdNoReferensi,
if (reader.IsColumnExists("fdKodeSF"))
{
order.fdKodeSF = SqlHelper.GetNullableBigInt(reader, "fdKodeSF");
}
if (reader.IsColumnExists("fdNama"))
{
order.fdNamaSF = SqlHelper.GetNullableString(reader, "fdNama");
}
if (reader.IsColumnExists("fdKodeGudang"))
{
order.fdKodeGudang = SqlHelper.GetNullableString(reader, "fdKodeGudang");
}
if (reader.IsColumnExists("fdKodeGudangTujuan"))
{
order.fdKodeGudangTujuan = SqlHelper.GetNullableString(reader, "fdKodeGudangTujuan");
}
if (reader.IsColumnExists("fdMataUang"))
{
order.fdMataUang = SqlHelper.GetNullableString(reader, "fdMataUang");
}
if (reader.IsColumnExists("fdNoReferensi"))
{
order.fdNoReferensi = SqlHelper.GetNullableString(reader, "fdNoReferensi");
}
//fdTglReferensi, fdRemarkPO, fdOrderTambahan, fdTransport, fdTerm_Days,
if (reader.IsColumnExists("fdTglReferensi"))
{
order.fdTglReferensi = SqlHelper.GetNullableDatetime(reader, "fdTglReferensi");
}
if (reader.IsColumnExists("fdRemarkPO"))
{
order.fdRemarkPO = SqlHelper.GetNullableString(reader, "fdRemarkPO");
}
if (reader.IsColumnExists("fdOrderTambahan"))
{
order.fdOrderTambahan = SqlHelper.GetNullableInt(reader, "fdOrderTambahan");
}
if (reader.IsColumnExists("fdTransport"))
{
order.fdTransport = SqlHelper.GetNullableString(reader, "fdTransport");
}
if (reader.IsColumnExists("fdTerm_Days"))
{
order.fdTerm_Days = SqlHelper.GetNullableInt(reader, "fdTerm_Days");
}
//fdTerm, fdDestinationPortID, fdShippingMark, fdIsFixed, fdStatus,
if (reader.IsColumnExists("fdTerm"))
{
order.fdTerm = SqlHelper.GetNullableString(reader, "fdTerm");
}
if (reader.IsColumnExists("fdDestinationPortID"))
{
order.fdDestinationPortID = SqlHelper.GetNullableString(reader, "fdDestinationPortID");
}
if (reader.IsColumnExists("fdShippingMark"))
{
order.fdShippingMark = SqlHelper.GetNullableString(reader, "fdShippingMark");
}
if (reader.IsColumnExists("fdIsFixed"))
{
order.fdIsFixed = SqlHelper.GetNullableString(reader, "fdIsFixed");
}
if (reader.IsColumnExists("fdStatus"))
{
order.fdStatus = SqlHelper.GetNullableInt(reader, "fdStatus");
}
if (reader.IsColumnExists("fdNamaStatus"))
{
order.fdNamaStatus = SqlHelper.GetNullableString(reader, "fdNamaStatus");
}
//fdReasonNotApprove, fdDisetujuiOleh, fdTglDisetujui, fdKodeEkspedisi, fdNoOrderSFA,
if (reader.IsColumnExists("fdReasonNotApprove"))
{
order.fdReasonNotApprove = SqlHelper.GetNullableInt(reader, "fdReasonNotApprove");
}
if (reader.IsColumnExists("fdDisetujuiOleh"))
{
order.fdDisetujuiOleh = SqlHelper.GetNullableString(reader, "fdDisetujuiOleh");
}
if (reader.IsColumnExists("fdTglDisetujui"))
{
order.fdTglDisetujui = SqlHelper.GetNullableDatetime(reader, "fdTglDisetujui");
}
if (reader.IsColumnExists("fdKodeEkspedisi"))
{
order.fdKodeEkspedisi = SqlHelper.GetNullableString(reader, "fdKodeEkspedisi");
}
if (reader.IsColumnExists("fdNoOrderSFA"))
{
order.fdNoOrderSFA = SqlHelper.GetNullableString(reader, "fdNoOrderSFA");
}
//fdTglSFA, fdStatusRecord, fdCreateUserID, fdCreateTS, fdUpdateUserID,
if (reader.IsColumnExists("fdTglSFA"))
{
order.fdTglSFA = SqlHelper.GetNullableString(reader, "fdTglSFA");
}
if (reader.IsColumnExists("fdStatusRecord"))
{
order.fdStatusRecord = SqlHelper.GetNullableInt(reader, "fdStatusRecord");
}
if (reader.IsColumnExists("fdCreateUserID"))
{
order.fdCreateUserID = SqlHelper.GetNullableString(reader, "fdCreateUserID");
}
if (reader.IsColumnExists("fdCreateTS"))
{
order.fdCreateTS = SqlHelper.GetNullableDatetime(reader, "fdCreateTS");
}
if (reader.IsColumnExists("fdUpdateUserID"))
{
order.fdUpdateUserID = SqlHelper.GetNullableString(reader, "fdUpdateUserID");
}
//fdUpdateTS, fdNoEntryLama
if (reader.IsColumnExists("fdUpdateTS"))
{
order.fdUpdateTS = SqlHelper.GetNullableDatetime(reader, "fdUpdateTS");
}
if (reader.IsColumnExists("fdNoEntryLama"))
{
order.fdNoEntryLama = SqlHelper.GetNullableString(reader, "fdNoEntryLama");
}
}
catch (Exception ex)
{
throw ex;
}
return(order);
}
public ActionResult Order(customerModel obj, HttpPostedFileBase file1, HttpPostedFileBase file2, HttpPostedFileBase file3, double amount)
{
String query = "SELECT * from Cart where UserId = " + UserController.id;
SqlConnection con = new SqlConnection(constring);
String query2 = "SELECT COUNT(*) from Cart where UserId = " + UserController.id;
SqlCommand command1 = new SqlCommand(query2, con);
con.Open();
int cnt = Convert.ToInt32(command1.ExecuteScalar());
var ob = new orderModel[cnt];
var ob1 = new orderModel();
int i;
for (i = 0; i < cnt; i++)
{
ob[i] = new orderModel();
}
con.Close();
SqlCommand command2 = new SqlCommand(query, con);
con.Open();
i = 0;
SqlDataReader read = command2.ExecuteReader();
while (read.Read())
{
ob[i].userid = read["UserId"].ToString();
ob[i].productname = read["Product_Name"].ToString();
ob[i].category = read["Category"].ToString();
ob[i].price = Convert.ToDouble(read["Price"]);
ob[i].quantity = Convert.ToInt32(read["quantity"]);
i++;
}
con.Close();
String q = "INSERT into OrderItem(OrderId,CustomerId,ProductName,Category,Price,Quantity) "
+ "values(@orderid,@userid,@productname,@category,@price,@quantity)";
System.Guid orderid = System.Guid.NewGuid();
for (int j = 0; j < i; j++)
{
SqlCommand cmd = new SqlCommand(q, con);
con.Open();
cmd.Parameters.AddWithValue("@orderid", orderid.ToString());
cmd.Parameters.AddWithValue("@productname", ob[j].productname);
cmd.Parameters.AddWithValue("@userid", ob[j].userid);
cmd.Parameters.AddWithValue("@category", ob[j].category);
cmd.Parameters.AddWithValue("@price", ob[j].price);
cmd.Parameters.AddWithValue("@quantity", ob[j].quantity);
cmd.ExecuteNonQuery();
con.Close();
}
String query3 = "INSERT into CustomerTable(CustomerId,Name,Address,Email,Phone,OrderId,Prescription1,Prescription2,Prescription3) " +
"values(@customerid,@name,@address,@email,@phone,@orderid,@prescription1,@prescription2,@prescription3)";
SqlCommand command3 = new SqlCommand(query3, con);
con.Open();
command3.Parameters.AddWithValue("@customerid", obj.id);
command3.Parameters.AddWithValue("@name", obj.name);
command3.Parameters.AddWithValue("@address", obj.address);
command3.Parameters.AddWithValue("@email", obj.email);
command3.Parameters.AddWithValue("@phone", obj.phone);
command3.Parameters.AddWithValue("@orderid", orderid.ToString());
if (file1 != null && file1.ContentLength > 0)
{
string filename = Path.GetFileName(file1.FileName);
string imgpath = Path.Combine(Server.MapPath("/orderimages/"), filename);
file1.SaveAs(imgpath);
command3.Parameters.AddWithValue("@prescription1", "/orderimages/" + file1.FileName);
}
else
{
command3.Parameters.AddWithValue("@prescription1", DBNull.Value);
}
if (file2 != null && file2.ContentLength > 0)
{
string filename = Path.GetFileName(file2.FileName);
string imgpath = Path.Combine(Server.MapPath("/orderimages/"), filename);
file2.SaveAs(imgpath);
command3.Parameters.AddWithValue("@prescription2", "/orderimages/" + file2.FileName);
}
else
{
command3.Parameters.AddWithValue("@prescription2", DBNull.Value);
}
if (file3 != null && file3.ContentLength > 0)
{
string filename = Path.GetFileName(file3.FileName);
string imgpath = Path.Combine(Server.MapPath("/orderimages/"), filename);
file3.SaveAs(imgpath);
command3.Parameters.AddWithValue("@prescription3", "/orderimages/" + file3.FileName);
}
else
{
command3.Parameters.AddWithValue("@prescription3", DBNull.Value);
}
command3.ExecuteNonQuery();
con.Close();
double deliverycharge = 60.0;
String query5 = "INSERT into Payment(CustomerId,OrderId,Amount,DeliveryCharge) " +
"values(@customerid,@orderid,@amount,@deliverycharge)";
SqlCommand command5 = new SqlCommand(query5, con);
con.Open();
command5.Parameters.AddWithValue("@customerid", obj.id);
command5.Parameters.AddWithValue("@orderid", orderid.ToString());
command5.Parameters.AddWithValue("@amount", amount);
command5.Parameters.AddWithValue("@deliverycharge", deliverycharge);
command5.ExecuteNonQuery();
con.Close();
String query4 = "Delete from Cart where UserId = " + UserController.id;
con.Open();
SqlCommand command4 = new SqlCommand(query4, con);
command4.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Index", "Customer"));
}
/// <summary>
/// Sends a movement command to a robot
/// </summary>
/// <param name="order">The order to send</param>
/// <param name="port">The port the robot is listening on</param>
/// <returns>The response from the bot</returns>
public static string sendMoveCommand(orderModel order, int port = 8080)
{
return(sendDataToRobot(order.botNumber, order.ToString(), port));
}
