public ActionResult SaveStatus(string OrDetailCode, string StatusProduct)
{
OuikumOrderDetail orDetial = new OuikumOrderDetail();
var svOrderPur = new OrderPurchaseService();
var svOrderStauts = new OrderStatusService();
string SQLWhere = string.Empty;
try
{
var GetorderDetail = svOrderPur.SelectData <View_OuikumOrderDetailSC>("OrDetailID,OrDetailcode,ProductID,ProductName,StatusProduct", "IsDelete = 0 AND OrDetailCode = '" + OrDetailCode + "'").First();
SQLWhere = svOrderStauts.CreateWhereAction(OrderStatusAction.ConfirmBySC, LogonCompID);
var Status = svOrderPur.SelectData <OuikumStausOrder>("NameStatus", SQLWhere, "NameStatus", 1, 0);
orDetial.OrDetailID = GetorderDetail.OrDetailID;
if (GetorderDetail.StatusProduct == "A")
{
orDetial.StatusProduct = "B";
}
else if (GetorderDetail.StatusProduct == "B")
{
orDetial.StatusProduct = "C";
}
else
{
orDetial.StatusProduct = "D";
}
orDetial.ProductID = GetorderDetail.ProductID;
orDetial.ModifiedDate = DateTime.Now;
#region Update Satatus OrderDetail
svOrderPur.UpdateStatusOrder(orDetial);
#endregion
}
catch (Exception ex)
{
return(Json(new { IsSuccess = false }));
}
return(Json(new { IsSuccess = true }));
}
public ActionResult Index(FormCollection form)
{
var svOrderlist = new OrderPurchaseService();
SelectList_PageSize();
SetPager(form);
var GetOrder = svOrderlist.SelectData <View_HistoryOrder>("*", "IsDelete = 0 and CompID = " + LogonCompID, "CreatedDate DESC", (int)ViewBag.PageIndex, (int)ViewBag.PageSize);
ViewBag.GetOrder = GetOrder;
ViewBag.TotalPage = svOrderlist.TotalPage;
ViewBag.TotalRow = svOrderlist.TotalRow;
//var products = svProduct.SelectData<view_SearchProduct>("ProductID,ProductName", "IsDelete = 0 and CompID =" + LogonCompID);
//ViewBag.Products = products;
return(PartialView("UC/ListGrid"));
}
public ActionResult Index(FormCollection form)
{
var svOrderPur = new OrderPurchaseService();
SelectList_PageSize();
SetPager(form);
var getOrderDetail = svOrderPur.SelectData <View_OuikumOrderDetailSC>("*", "StatusProduct != 'D' AND IsDelete = 0 and CompSCID = " + LogonCompID, "StatusProduct,ModifiedDate asc", (int)ViewBag.PageIndex, (int)ViewBag.PageSize);
ViewBag.OrderDetail = getOrderDetail;
ViewBag.TotalPage = svOrderPur.TotalPage;
ViewBag.TotalRow = svOrderPur.TotalRow;
//var products = svProduct.SelectData<view_SearchProduct>("ProductID,ProductName", "IsDelete = 0 and CompID =" + LogonCompID);
//ViewBag.Products = products;
return(PartialView("Grid/GridOrderPurchase"));
}
public JsonResult GetEditOrderStatus(string OrDetailID)
{
var svOrderPurchase = new OrderPurchaseService();
var svOrderStauts = new OrderStatusService();
CommonService svCommon = new CommonService();
string SQLWhere = string.Empty;
//var EnumHotFeatStatus = svCommon.SelectEnum(CommonService.EnumType.HotFeatStatus);
//var orderIsShow = svOrder.SelectData<b2bPackage>("PackageID,PackageName,Price,Duratrion", "IsDelete = 0 AND IsShow = 0 AND CheckUpdate = 1", "PackageID ASC");
var data = svOrderPurchase.SelectData <View_OuikumOrderDetailSC>("OrDetailID,OrDetailcode,ProductName,StatusProduct", "IsDelete = 0 AND OrDetailID = " + OrDetailID);
SQLWhere = svOrderStauts.CreateWhereAction(OrderStatusAction.ConfirmBySC, LogonCompID);
var Status = svOrderStauts.SelectData <OuikumStausOrder>("NameStatus", SQLWhere, "NameStatus", 1, 0);
//return Json(new { IsResult = true, Price = (String.Format("{0:##,###.00}", data.First().PackagePrice)), Duration = data.First().Duration, PackageID = data.First().PackageID, EnumHotFeatStatus = EnumHotFeatStatus, orderIsShow = orderIsShow });
return(Json(new { IsResult = true, OrDetailCode = data.First().OrDetailCode, ProductName = data.First().ProductName, StatusProduct = data.First().StatusProduct }));
}
public void CountQuotation()
{
string SQLWhere = "";
var svQuotation = new QuotationService();
var svOrderPur = new OrderPurchaseService();
SQLWhere = svQuotation.CreateWhereAction(QuotationAction.CountQuotation, LogonCompID);
SQLWhere += " AND (IsRead = 0)";
ViewBag.QuoCount = svQuotation.SelectData <b2bQuotation>("QuotationID", SQLWhere, "QuotationID", 1, 0).Count;
var SQLWhereList = svQuotation.CreateWhereAction(QuotationAction.BackEnd, LogonCompID);
ViewBag.QuoCountList = svQuotation.SelectData <b2bQuotation>("QuotationID", SQLWhereList, "QuotationID", 1, 0).Count;
SQLWhere = svOrderPur.CreateWhereAction(OrderPurchaseAction.CountOrderPurchase, LogonCompID);
ViewBag.CountOrP = svOrderPur.SelectData <OuikumOrderDetail>("OrDetailID", SQLWhere, "OrDetailID", 1, 0).Count;
}
public ActionResult Index()
{
//if (RedirectToProduction())
// return Redirect(UrlProduction);
LoadProductShowcase();
LoadHotProduct();
LoadRecently();
LoadCategory();
LoadFeatureProduct();
LoadRandomCompany();
LoadRandomBanner();
GetStatusUser();
LoadDataBidProduct();
LoadSuccessStory();
GetEnumServiceType();
//search
LoadProvinces();
LoadBiztype();
#region CheckIsLogin
if (CheckIsLogin())
{
MessageService svMessage = new MessageService();
QuotationService svQuotation = new QuotationService();
OrderPurchaseService svOrderPur = new OrderPurchaseService();
string SQLWhere = "";
string sqlwhere = svMessage.CreateWhereAction(MessageStatus.UnRead, LogonCompID);
int count = svMessage.CountData <emMessage>("MessageID", sqlwhere);
ViewBag.UnRead = count;
SQLWhere = svQuotation.CreateWhereAction(QuotationAction.CountQuotation, LogonCompID);
ViewBag.CountQuo = svQuotation.SelectData <b2bQuotation>("QuotationID", SQLWhere, "QuotationID", 1, 0).Count;
SQLWhere = svOrderPur.CreateWhereAction(OrderPurchaseAction.CountOrderPurchase, LogonCompID);
ViewBag.CountOrP = svOrderPur.SelectData <OuikumOrderDetail>("OrDetailID", SQLWhere, "OrDetailID", 1, 0).Count;
}
#endregion
ViewBag.FBAccessToken = GetAppSetting("FBPageAccessToken");
ViewBag.Page = "Home";
return(View());
}