public bool UpdateOrderStatus(alamaat_Order order)
{
using (objMyLq = new alamaatDBDataContext())
{
try
{
var objcontent = objMyLq.alamaat_Orders.FirstOrDefault(p => p.id == order.id);
objcontent.orderstatus = order.orderstatus;
objMyLq.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
protected void UpdateOrder(object sender, GridCommandEventArgs e)
{
GridEditableItem editItem = (GridEditableItem)e.Item;
//RadComboBox comboObjectName = (RadComboBox)editItem["Status"].Controls[0];
// GridEditManager editMan = editItem.EditManager;
// GridDropDownListColumnEditor editor = editMan.GetColumnEditor("Status") as GridDropDownListColumnEditor;
RadComboBox combo = (RadComboBox)editItem.FindControl("ComboStatus");
if (null != combo)
{
CheckBox chkemail = (CheckBox)editItem.FindControl("chkEmail");
if (null != chkemail)
{
var item = combo.SelectedValue;
ordercontent = new Orders();
// string id = editItem.KeyValues.Replace('id:\','').Replace("{","").Replace("}","").ToString();
string id = (e.Item as GridEditFormItem).GetDataKeyValue("id").ToString();
alamaat_Order order = ordercontent.GetOrderbyid(id);
if (order != null)
{
if (chkemail.Checked == true)
{
string status = "";
order.orderstatus = combo.SelectedValue.ToString();
ordercontent.UpdateOrderStatus(order);
}
else
{
order.orderstatus = combo.SelectedValue.ToString();
ordercontent.UpdateOrderStatus(order);
}
}
}
}
// string Object = comboObjectName.SelectedValue;
//RadComboBox comboCounterName = (RadComboBox)editItem["lblName"].ontrols[0];
//string Counter = comboCounterName.SelectedValue;
}
public bool InsertOrder(OrderInterface order, List <OrderItems> Items)
{
using (objMyLq = new alamaatDBDataContext())
{
try
{
alamaat_Order neworder = new alamaat_Order();
neworder.id = Guid.NewGuid();
DateTime date = DateTime.Now;
//neworder.order_number = "A" + date.ToShortDateString() + date.ToShortTimeString();
neworder.order_number = order.OrderNumber;
neworder.subtotal = order.SubTotal;
neworder.discount = order.Discount;
neworder.tax = order.Tax;
neworder.total = order.Total;
neworder.orderstatus = "Pending";
neworder.created = DateTime.Now;
neworder.lastmodified = DateTime.Now;
neworder.shipment = order.Shipment;
neworder.shippingtotal = order.Total;
neworder.lastedit = order.Lastedit;
neworder.shipfirstname = order.Shipfirstname;
neworder.shiplastname = order.Shiplastname;
neworder.shipmiddlename = order.Shipmiddlename;
neworder.shipcompanyname = order.Shipcompany;
neworder.shipaddress = order.ShipAddress;
neworder.shippostalcode = order.ShipPostalcode;
neworder.shipcity = order.ShipCity;
neworder.shipcountry = order.ShipCountry;
neworder.shipphone = order.ShipPhone;
neworder.shipmobilephone = order.ShipMobilephone;
neworder.shipfax = order.Shipfax;
neworder.billfirstname = order.Billfirstname;
neworder.billlastname = order.Billlastname;
neworder.billmiddlename = order.Billmiddlename;
neworder.billemail = order.Billemail;
neworder.billcompanyname = order.Billcompany;
neworder.billaddress = order.BillAddress;
neworder.billpostalcode = order.BillPostalcode;
neworder.billcity = order.BillCity;
neworder.billcountry = order.BillCountry;
neworder.billphone = order.BillPhone;
neworder.billmobilephone = order.BillMobilephone;
neworder.billfax = order.Billfax;
objMyLq.alamaat_Orders.InsertOnSubmit(neworder);
foreach (var item in Items)
{
Order_product ordItem = new Order_product();
ordItem.id = item.ID;
ordItem.order_id = neworder.id;
ordItem.name = item.Name;
ordItem.status = "Pending";
ordItem.price = item.Price;
ordItem.quantity = item.Quantity;
ordItem.discount = item.Discount;
ordItem.total = item.Total;
ordItem.product_id = item.Productid;
objMyLq.Order_products.InsertOnSubmit(ordItem);
}
objMyLq.SubmitChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public alamaat_Order GetOrderbyid(string id)
{
alamaat_Order order = objMyLq.alamaat_Orders.Where(ku => ku.id.ToString().Equals(id)).FirstOrDefault();
return(order);
}
