private void GetOrderList()
{
List <orderlist> oRList = new List <orderlist>();
string sql = $@"SELECT i_cust as t_cust, SUM(i_damt) as t_damt, MAX(C_NAME) as t_name, MAX(C_ADDRESS) as t_address,
MAX(C_CITY) as t_city, MAX(C_TEL) as t_tel, MAX(i_user) as t_suser FROM CART LEFT OUTER JOIN CUST ON cart.i_cust = CUST.C_ID
GROUP BY cart.i_cust
ORDER BY i_cust";
var rd = LocalDb.db.QueryAsync <tmp_orderlist>(sql).Result.ToList();
if (rd != null || rd.Count() != 0)
{
foreach (tmp_orderlist tmp in rd)
{
orderlist h = new orderlist();
h.ol_cust = tmp.t_cust;
h.ol_custn = tmp.t_name;
h.ol_suser = tmp.t_suser;
h.ol_custadd = $@"{tmp.t_address.Trim()} {tmp.t_city.Trim()} {tmp.t_tel.Trim()}";
h.ol_damt = tmp.t_damt;
oRList.Add(h);
}
ItemOrderList.ItemsSource = string.Empty;
ItemOrderList.ItemsSource = oRList;
}
}
public async Task <ActionResult <orderlist> > Postorderlist(orderlist orderlist)
{
_context.orderlists.Add(orderlist);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(Getorderlist), new { id = orderlist.OrderID }, orderlist));
}
public async Task <IActionResult> Putorderlist(int id, orderlist orderlist)
{
if (id != orderlist.OrderID)
{
return(BadRequest());
}
_context.Entry(orderlist).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!orderlistExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Delete(orderlist item)
{
_orderlistRepository.Delete(item);
}
public void Update(orderlist item)
{
_orderlistRepository.Update(item);
}
public void Create(orderlist item)
{
_orderlistRepository.Add(item);
}
public void order_detail_inner(HtmlGenericControl divcollapse_inner, string order_id, string sendprice, string totalprice)
{
orderlist orlist = new orderlist();
category cat = new category();
brand brnd = new brand();
DataTable product_order = orlist.get_product_order(order_id);
products pro = new products();
HtmlGenericControl table_order = new HtmlGenericControl("table");
table_order.Attributes.Add("class", "table table-items");
HtmlGenericControl table_head = new HtmlGenericControl("thead");
HtmlGenericControl tr_table_head = new HtmlGenericControl("tr");
HtmlGenericControl th_name_tr_table_head = new HtmlGenericControl("th");
th_name_tr_table_head.Attributes.Add("colspan", "2");
th_name_tr_table_head.InnerHtml = "مشخصات محصول";
tr_table_head.Controls.Add(th_name_tr_table_head);
HtmlGenericControl th_number_tr_table_head = new HtmlGenericControl("th");
HtmlGenericControl div_th_number_tr_table_head = new HtmlGenericControl("div");
div_th_number_tr_table_head.Attributes.Add("class", "align-center");
div_th_number_tr_table_head.InnerText = "تعداد";
th_number_tr_table_head.Controls.Add(div_th_number_tr_table_head);
tr_table_head.Controls.Add(th_number_tr_table_head);
HtmlGenericControl th_unitprice_tr_table_head = new HtmlGenericControl("th");
HtmlGenericControl div_th_unitprice_tr_table_head = new HtmlGenericControl("div");
div_th_unitprice_tr_table_head.Attributes.Add("class", "align-right");
div_th_unitprice_tr_table_head.InnerText = "قیمت واحد";
th_unitprice_tr_table_head.Controls.Add(div_th_unitprice_tr_table_head);
tr_table_head.Controls.Add(th_unitprice_tr_table_head);
HtmlGenericControl th_price_tr_table_head = new HtmlGenericControl("th");
HtmlGenericControl div_th_price_tr_table_head = new HtmlGenericControl("div");
div_th_price_tr_table_head.Attributes.Add("class", "align-right");
div_th_price_tr_table_head.InnerText = "قیمت کل";
th_price_tr_table_head.Controls.Add(div_th_price_tr_table_head);
tr_table_head.Controls.Add(th_price_tr_table_head);
table_head.Controls.Add(tr_table_head);
table_order.Controls.Add(table_head);
HtmlGenericControl table_body_order = new HtmlGenericControl("tbody");
int total_price = 0;
foreach (DataRow dr in product_order.Rows)
{
string catname = cat.getcategory(dr["cat_id"].ToString()).Rows[0]["name"].ToString();
string brandname = brnd.getbrandbyid(dr["brand_id"].ToString()).Rows[0]["name"].ToString();
DataTable pic = pro.getonepic(int.Parse(dr["product_id"].ToString()));
HtmlGenericControl tr = new HtmlGenericControl("tr");
HtmlGenericControl tdimg = new HtmlGenericControl("td");
tdimg.Attributes.Add("class", "image");
HtmlGenericControl img = new HtmlGenericControl("img");
img.Attributes.Add("src", "images/Ppic/" + pic.Rows[0]["name"].ToString() + ".jpg");
img.Attributes.Add("alt", "");
img.Attributes.Add("width", "50");
img.Attributes.Add("height", "50");
tdimg.Controls.Add(img);
tr.Controls.Add(tdimg);//finish td img
HtmlGenericControl tddesc = new HtmlGenericControl("td");
tddesc.Attributes.Add("class", "desc");
tddesc.InnerText = catname + "-" + brandname + " - " + dr["name"].ToString();
tr.Controls.Add(tddesc);//finish td by class desc
HtmlGenericControl tdqty = new HtmlGenericControl("td");
tdqty.Attributes.Add("class", "qty");
HtmlGenericControl divnumber = new HtmlGenericControl("div");
divnumber.Attributes.Add("class", "numbered");
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
divnumber.Controls.Add(new LiteralControl(" "));
//HtmlInputText input = new HtmlInputText();
HtmlGenericControl input = new HtmlGenericControl("input");
input.Attributes.Add("name", "input_number" + dr["id"].ToString());
input.Attributes.Add("class", "tiny-size");
input.Attributes.Add("value", dr["count"].ToString());
input.Attributes.Add("type", "text");
input.Attributes.Add("readonly", "readonly");
input.Attributes.Add("id", "input_number" + dr["id"].ToString());
divnumber.Controls.Add(input); //finish input
tdqty.Controls.Add(divnumber);
tr.Controls.Add(tdqty); //finish td by class qty
HtmlGenericControl td_unit_price = new HtmlGenericControl("td");
td_unit_price.Attributes.Add("class", "price");
td_unit_price.InnerText = dr["price"].ToString() + " ریال ";
tr.Controls.Add(td_unit_price);//finish td price
HtmlGenericControl tdprice = new HtmlGenericControl("td");
tdprice.Attributes.Add("class", "price");
tdprice.InnerText = ((Int32)dr["price"] * (Int16)dr["count"]).ToString() + " ریال ";
tr.Controls.Add(tdprice);//finish td price
table_body_order.Controls.Add(tr);
total_price += (Int32)dr["price"] * (Int16)dr["count"];
}
HtmlGenericControl tr_send_price = new HtmlGenericControl("tr");
HtmlGenericControl td_space = new HtmlGenericControl("td");
td_space.Attributes.Add("colspan", "3");
td_space.Attributes.Add("rowspan", "3");
td_space.Controls.Add(new LiteralControl(" "));
tr_send_price.Controls.Add(td_space);
HtmlGenericControl td_stronger_lable = new HtmlGenericControl("td");
td_stronger_lable.Attributes.Add("class", "stronger");
td_stronger_lable.InnerText = "هزينه ارسال :";
tr_send_price.Controls.Add(td_stronger_lable);
HtmlGenericControl td_stronger_price = new HtmlGenericControl("td");
td_stronger_price.Attributes.Add("class", "stronger");
HtmlGenericControl div_td_stronger_price = new HtmlGenericControl("div");
div_td_stronger_price.Attributes.Add("class", "align-right");
div_td_stronger_price.InnerText = sendprice + " ریال";
td_stronger_price.Controls.Add(div_td_stronger_price);
tr_send_price.Controls.Add(td_stronger_price);
table_body_order.Controls.Add(tr_send_price);
HtmlGenericControl tr_total_price = new HtmlGenericControl("tr");
HtmlGenericControl td_stronger_lable_totalprice = new HtmlGenericControl("td");
td_stronger_lable_totalprice.Attributes.Add("class", "stronger");
td_stronger_lable_totalprice.InnerText = "جمع کل :";
tr_total_price.Controls.Add(td_stronger_lable_totalprice);
HtmlGenericControl td_stronger_totalprice = new HtmlGenericControl("td");
td_stronger_totalprice.Attributes.Add("class", "stronger");
HtmlGenericControl div_td_stronger_totalprice = new HtmlGenericControl("div");
div_td_stronger_totalprice.Attributes.Add("class", "size-16 align-right");
div_td_stronger_totalprice.InnerText = total_price + " ریال";
td_stronger_totalprice.Controls.Add(div_td_stronger_totalprice);
tr_total_price.Controls.Add(td_stronger_totalprice);
table_body_order.Controls.Add(tr_total_price);
table_order.Controls.Add(table_body_order);
divcollapse_inner.Controls.Add(table_order);
}
