public OrderlistController()
{
svBizType = new BizTypeService();
svMember = new MemberService();
svAddress = new AddressService();
svCompany = new CompanyService();
svProduct = new ProductService();
svShipment = new ShipmentService();
svOrderPur = new OrderPurchaseService();
}
public void MyB2BStatus(int CompID)
{
var svProduct = new ProductService();
var svBuylead = new BuyleadService();
var svMessage = new MessageService();
var svQuotation = new QuotationService();
var svOrderPur = new OrderPurchaseService();
string sqlwhere = string.Empty;
//string sqlwhere = svProduct.CreateWhereAction(ProductAction.All, CompID);
var count = 0;
//var sqlwherein = "";
// switch (res.Common.lblWebsite)
// {
// case "B2BThai": sqlwherein = " AND CategoryType IN (1,2)"; break;
// case "AntCart": sqlwherein = " AND CategoryType IN (3)"; break;
// case "myOtopThai": sqlwherein = " AND CategoryType IN (5)"; break;
// case "AppstoreThai": sqlwherein = " AND CategoryType IN (6)"; break;
// default: sqlwherein = ""; break;
// }sqlwhere += sqlwherein;
sqlwhere = svProduct.CreateWhereAction(ProductAction.All, CompID);
count = svProduct.CountData <view_SearchProduct>("ProductID", sqlwhere);
ViewBag.CountProduct = count;
sqlwhere = svProduct.CreateWhereAction(ProductAction.All, CompID) + " AND RowFlag = 3";
count = svProduct.CountData <view_SearchProduct>("ProductID", sqlwhere);
ViewBag.CountProductReject = count;
sqlwhere = svProduct.CreateWhereAction(ProductAction.All, CompID) + " AND RowFlag IN (2)";
count = svProduct.CountData <view_SearchProduct>("ProductID", sqlwhere);
ViewBag.CountProductWait = count;
sqlwhere = svProduct.CreateWhereAction(ProductAction.All, CompID) + " AND RowFlag IN (4,5)";
count = svProduct.CountData <view_SearchProduct>("ProductID", sqlwhere);
ViewBag.CountProductApprove = count;
//sqlwhere = svBuylead.CreateWhereAction(BuyleadAction.All, CompID);
//count = svProduct.CountData<b2bBuylead>("BuyleadID", sqlwhere);
//ViewBag.CountBuylead = count;
//sqlwhere = svBuylead.CreateWhereAction(BuyleadAction.All, CompID) + " AND RowFlag = 3 ";
//count = svBuylead.CountData<b2bBuylead>("BuyleadID", sqlwhere);
//ViewBag.CountBuyleadReject = count;
//sqlwhere = svMessage.CreateWhereAction(MessageStatus.Inbox, CompID);
//count = svMessage.CountData<emMessage>("MessageID", sqlwhere);
//ViewBag.Inbox = count;
sqlwhere = svMessage.CreateWhereAction(MessageStatus.UnRead, CompID);
count = svMessage.CountData <emMessage>("MessageID", sqlwhere);
ViewBag.UnRead = count;
}
// GET: MyB2B/OrderPurchase
public ActionResult Index()
{
var svOrderPur = new OrderPurchaseService();
RememberURL();
if (!CheckIsLogin())
{
return(Redirect(res.Pageviews.PvMemberSignIn));
}
else
{
GetStatusUser();
return(View());
}
}
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());
}
public CartController()
{
svCart = new CartService();
svProduct = new ProductService();
svCompany = new CompanyService();
svAddress = new AddressService();
svMember = new MemberService();
svShipment = new ShipmentService();
svCommon = new CommonService();
svOrderPur = new OrderPurchaseService();
svWeb = new WebService();
AppName = res.Common.lblWebsite;
RememberAppName = string.Concat("Remember", AppName);
svAuthentication = new AuthenticationService();
emailManager = new EmailManager(res.Config.SMTP_Server, res.Config.SMTP_UserName, res.Config.SMTP_Password, Convert.ToBoolean(res.Config.SMTP_IsAuthentication));
mail = new Mail();
}
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 }));
}
