public bool InsertOrder(b2bOrder Order, List <b2bOrderDetail> OrderDetails)
{
var count = CountData <b2bOrder>(" * ", " CreatedDate = GetDate() AND IsDelete = 0 ");
count = count + 1;
Order.OrderCode = AutoGenCode("OD", count);
Order.CreatedDate = DateTimeNow;
Order.ModifiedDate = DateTimeNow;
Order.CreatedBy = "sa";
Order.ModifiedBy = "sa";
using (var trans = new TransactionScope())
{
qDB.b2bOrders.InsertOnSubmit(Order); // insert order
qDB.SubmitChanges();
foreach (var it in OrderDetails)
{
it.OrderID = Order.OrderID;
it.CreatedDate = DateTimeNow;
it.ModifiedDate = DateTimeNow;
it.CreatedBy = "sa";
it.ModifiedBy = "sa";
qDB.b2bOrderDetails.InsertOnSubmit(it);
qDB.SubmitChanges();
}
trans.Complete();
IsResult = true;
}
return(IsResult);
}
public bool SaveOrderList(FormCollection form)
{
int objState = DataManager.ConvertToInteger(form["objState"]);//objState 1 คือ insert objState 2 คือ update
var svOrder = new OrderService();
var OrderList = new b2bOrder();
if (objState == 2)// update
{
OrderList = svOrder.SelectData <b2bOrder>("*", " OrderID = " + form["OrderID"] + " AND RowVersion = " + form["RowVersion"]).First();
}
#region set ค่า b2bOrder
//OrderList.CompID = DataManager.ConvertToInteger(Request.Cookies[res.Common.lblWebsite].Values["CompID"]);
//OrderList.TotalPrice = DataManager.ConvertToDecimal(form["TotalPrice"]);
//OrderList.CreatedDate = DataManager.ConvertToDateTime(form["CreatedDate"]);
OrderList.OrderStatus = form["OrderStatus"];
if (objState == 2)// update
{
OrderList.RowVersion = DataManager.ConvertToShort(OrderList.RowVersion + 1);
}
else
{
OrderList.RowFlag = 1;
OrderList.RowVersion = 1;
OrderList.CreatedBy = "sa";
OrderList.ModifiedBy = "sa";
OrderList.ModifiedDate = DateTime.Now;
OrderList.CreatedDate = DateTime.Now;
}
#endregion
#region Save b2bOrder
OrderList = svOrder.SaveData <b2bOrder>(OrderList, "OrderID");
#endregion
return(svOrder.IsResult);
}
public ActionResult EditPackageGold(string PackageID, string Price, string Duration, string OrderDetailID)
{
b2bMemberPaid mem = new b2bMemberPaid();
b2bOrder order = new b2bOrder();
b2bOrderDetail orderDe = new b2bOrderDetail();
var svOrder = new OrderService();
var svMember = new MemberService();
try
{
#region Set b2bMemberPaid
var countMem = svMember.SelectData <b2bMemberPaid>("*", " CreatedDate = GetDate() AND RowFlag > 0");
int CountMem = countMem.Count + 1;
mem.MemberPaidCode = AutoGenCode("MPC", CountMem);
mem.CompID = LogonCompID;
mem.PaymentStatus = "B";
mem.IsShow = true;
mem.IsDelete = false;
#endregion
#region Insert b2bMemberPaid
svMember.InsertMemberPaid(mem);
#endregion
#region Set b2bOrder
order.CompID = LogonCompID;
order.MemberPaidID = mem.MemberPaidID;
order.OrderStatus = "B";
order.TotalPrice = decimal.Parse(Price);
order.IsShow = true;
order.IsDelete = false;
order.RowFlag = 1;
order.IsInactive = false;
order.IsSend = false;
#endregion
var OrderDetails = new List <b2bOrderDetail>();
#region Set Model Order Detail
var countOrder = svMember.SelectData <b2bOrderDetail>("*", " CreatedDate = GetDate() AND RowFlag > 0");
int CountOrder = countOrder.Count + 1;
List <int> PackagesId = new List <int>();
foreach (string ID in PackageID.Split(','))
{
if (!string.IsNullOrEmpty(ID))
{
int intID;
bool isNum = int.TryParse(ID, out intID);
if (isNum)
{
PackagesId.Add(intID);
}
}
}
for (var i = 0; i < PackagesId.Count(); i++)
{
var GetPackage = svMember.SelectData <b2bPackage>("*", "PackageID = " + PackagesId[i]).First();
var GetOrderDetail = svMember.SelectData <b2bOrderDetail>("*", "IsDelete = 0 AND PackageID = " + PackagesId[i]).First();
var detail = new b2bOrderDetail();
detail.OrderType = 2;
detail.PackageID = PackagesId[i];
detail.RowFlag = 1;
detail.IsDelete = false;
detail.IsInactive = false;
detail.OrderDetailCode = AutoGenCode("ORT", CountOrder);
detail.PackagePrice = decimal.Parse(Price);
detail.OrderCount = (byte)(DataManager.ConvertToInteger(GetOrderDetail.OrderCount) + 1);
detail.OptionValue = GetPackage.OptionValue;
detail.OptionValueUnit = GetPackage.OptionValueUnit;
detail.Duration = DataManager.ConvertToInteger(Duration);
CountOrder++;
OrderDetails.Add(detail);
}
#endregion
#region Insert b2bOrder
svOrder.InsertOrder(order, OrderDetails);
#endregion
if (svOrder.IsResult)
{
UpdateInactive(OrderDetailID);
SendEmailOrderPackage(Price);
}
}
catch (Exception ex)
{
return(Json(new { IsSuccess = false }));
}
return(Json(new { IsSuccess = true }));
}
public ActionResult Summary(List <int> PackageID, List <int> Qty, List <bool> Package)
{
#region Using Service
var svPaymentAcc = new PaymentAccountService();
var svCompany = new CompanyService();
var svPackage = new PackageService();
var svOrder = new OrderService();
#endregion
#region Set Variable
var model = new b2bOrder();
var OrderDetails = new List <b2bOrderDetail>();
var OrderNumber = 1;
decimal OrderTotalPrice = 0;
#endregion
#region Set Model Order Detail
for (var i = 0; i < Package.Count(); i++)
{
if (Package[i] == true)
{
var GetPackage = svPackage.SelectData <b2bPackage>(" PackageID,Price ", " PackageID = " + PackageID[i]).First();
#region วน Add Package เข้า List Order Detail ตามจำนวน ที่สั่งซื้อ
for (var x = 1; x <= Qty[i]; x++)
{
var detail = new b2bOrderDetail();
detail.OrderType = 1;
detail.PackageID = PackageID[i];
detail.RowFlag = 1;
detail.IsDelete = true;
detail.OrderDetailCode = AutoGenCode(CreateOrderDetialCode((int)PackageID[i]), OrderNumber);
OrderNumber++;
OrderDetails.Add(detail);
}
#endregion
OrderTotalPrice += ((decimal)GetPackage.Price * Qty[i]);
}
}
#endregion
#region Set Model Order
model.CompID = LogonCompID;
model.OrderStatus = "C";
model.RowFlag = 1;
model.IsDelete = true;
model.TotalPrice = OrderTotalPrice;
#endregion
#region InsertOrder
svOrder.InsertOrder(model, OrderDetails);
#endregion
#region Set ViewBag
ViewBag.OrderID = model.OrderID;
var Company = svCompany.SelectData <view_Company>(" * ", " CompID = " + LogonCompID).First();
ViewBag.Company = Company;
//var PaymentAccounts = svPaymentAcc.SelectData<View_PaymentAccount>(" PaymentAccID, BankID, AccName, AccNo, BranchName, PaymentTypeID, BankName, LogoImgPath, PaymentTypeName", "");
//ViewBag.PaymentAccounts = PaymentAccounts;
CommonService svCommon = new CommonService();
ViewBag.EnumServiceType = svCommon.SelectEnum(CommonService.EnumType.SearchByServiceType);
#endregion
ViewBag.EnumServiceType = svCommon.SelectEnum(CommonService.EnumType.SearchByServiceType);
GetStatusUser();
return(View());
}
