private OrderSession SaveSessionOrder(POSAirPortClassesDataContext _posDB, OrderHeader order, df_header_onl new_order)
{
// order_session db save
var new_session_order = new order_session();
new_session_order.session_guid = Guid.NewGuid();
new_session_order.sale_agent_code = order.NewOrder.AgentCode;
new_session_order.sale_order_no = order.NewOrder.OrderNo;
new_session_order.sale_order_status = "Create";
new_session_order.sale_invoice_no = order.NewOrder.InvoiceNo;
new_session_order.sale_platform = "online";
var obj_key = new OrderKey();
obj_key.Date = new_order.data_date.Date.ToString();
obj_key.DocNO = new_order.doc_no.ToString();
obj_key.MacNo = new_order.machine_no.Trim();
new_session_order.pos_order_key = JsonConvert.SerializeObject(obj_key);
new_session_order.pos_order_no = new_order.machine_no.Trim() + "-" + new_order.doc_no;
new_session_order.pos_order_status = new_order.LastStatus;
new_session_order.pos_invice_no = new_order.machine_no.Trim() + "-" + new_order.runno;
new_session_order.create_date = DateTime.Now;
new_session_order.modified_date = DateTime.Now;
_omDB.order_sessions.InsertOnSubmit(new_session_order);
_omDB.SubmitChanges();
// order_tran db save
var new_tren_order = new order_transaction();
new_tren_order.create_date = DateTime.Now;
new_tren_order.session_id = new_session_order.id;
new_tren_order.datail = "Create Sale Order Online [" + new_session_order.sale_order_no + "] <---> POS Order [" + new_session_order.pos_order_no + "]";
_omDB.order_transactions.InsertOnSubmit(new_tren_order);
_omDB.SubmitChanges();
SaveLogInterface(_posDB, order, new_session_order);
return(new OrderSession(new_session_order));
}
public OrderSession SaveOrderOnline(POSAirPortClassesDataContext _posDB, OrderHeader order)
{
if (string.IsNullOrWhiteSpace(order.Billing.PassportNo))
{
throw new ArgumentException("message", nameof(order.Billing.PassportNo));
}
var connObj = _omDB.config_connections.FirstOrDefault(x => x.cn_code == order.Flight.AirportCode);
if (connObj == null)
{
throw new ArgumentException("message", nameof(order.Flight.AirportCode));
}
var last_number = _posDB.runno_machines.FirstOrDefault(x => x.machine_no.Trim() == connObj.ref_machine_no.Trim());
if (last_number == null)
{
throw new ArgumentException("message", nameof(last_number));
}
var order_header = _posDB.df_header_onls.FirstOrDefault(x => x.OnlineNo == order.NewOrder.OrderNo);
if (order_header != null)
{
throw new ArgumentException("order is duplicate.", nameof(order_header.OnlineNo));
}
var order_result = new OrderSession();
//var option = new TransactionOptions();
//option.IsolationLevel = IsolationLevel.ReadCommitted;
//option.Timeout = TimeSpan.FromMinutes(2);
//using (TransactionScope tran = new TransactionScope(TransactionScopeOption.Required, option))
//{
try
{
new char();
// pos airport save
char sale_status = Char.Parse("R");
if (order.Flight.Terminal == "D")
{
sale_status = Char.Parse("D");
}
var docno = RunningNumber(_posDB, last_number, "taxabb");
var runno = RunningNumber(_posDB, last_number, "revdoc");
last_number.taxabb = docno;
last_number.reciept = runno;
_posDB.SubmitChanges();
CultureInfo ci = CultureInfo.InvariantCulture;
// new df_header_onl
df_header_onl new_order = new df_header_onl
{
branch_no = connObj.cn_branch_no,
data_date = DateTime.Now.Date,
area_code = connObj.ref_area_no,
loc_code = connObj.ref_loc_no,
machine_no = connObj.ref_machine_no,
doc_no = docno.ToString("00000"),
shift_no = 1,
cust_type = "",
flight_code = order.Flight.FlightCode,
flight_date = order.Flight.Date,
flight_time = order.Flight.Time.Time24,
country_code = order.Billing.CountryCode,
cust_name = order.Billing.FirstName + " " + order.Billing.LastName,
passport_no = order.Billing.PassportNo,
member_id = order.NewOrder.MemberID,
shopping_card = "",
cashier_code = "online",
sale_code = "online",
update_date_sale = null,
add_datetime = DateTime.Now,
update_datetime = DateTime.Now,
user_add = "online",
user_update = "online",
//time_stamp = "",
void_status = false,
cancel_to_doc = "",
cancel_to_date = null,
cancel_to_mac = "",
runno = runno.ToString("00000"),
data_time = DateTime.Now.ToString("HH:mm", ci),
trans_date = DateTime.Now.Date,
//rec_no = 0,
tour_barcode = "",
tour_code = "",
machine_tax = connObj.ref_machine_tax,
rcv_data_date = null,
rcv_loc_code = "",
rcv_machine_no = "",
rcv_doc_no = "",
rcv_datetime = null,
sale_status = sale_status,
DiscAuthUser = "",
CardTypeCode = "",
EmBossID = "",
CardTypeID = "",
PersonalID = "",
Gender = new char(),
//BirthDate = "",
//PassportExpire = "",
//rcv_status = "",
LVHeaderKey = 0,
DeliveryType = new char(),
DeliveryAuth = "",
//ReferDate = DateTime.Now.Date,
//ReferMac = "online",
//ReferDoc = order.NewOrder.OrderNo,
//RCCode = "",
AlipaySession = 0,
WeChatSession = 0,
Promoter = "",
DFA = "",
OnlineNo = order.NewOrder.OrderNo,
TerminalCode = order.Flight.Terminal,
LastStatus = "002".ToString()
};
_posDB.df_header_onls.InsertOnSubmit(new_order);
_posDB.SubmitChanges();
// new df_tran_onl and new pdiscount_onl
var item_code_list = order.Items.Select(x => x.MaterialCode).ToList();
var master_article = _posDB.vArticleMCs.Where(x => item_code_list.Contains(x.ArticleCode)).ToList();
var line_disc_no = 0;
foreach (var item in order.Items.Select((value, index) => new { Value = value, Index = index }))
{
var item_code = master_article.FirstOrDefault(x => x.ArticleCode == item.Value.MaterialCode);
df_trans_onl new_item = new df_trans_onl()
{
branch_no = new_order.branch_no.Trim(),
data_date = DateTime.Now.Date,
area_code = new_order.area_code.Trim(),
loc_code = new_order.loc_code,
machine_no = new_order.machine_no.Trim(),
doc_no = docno.ToString("00000"),
line_no = item.Index + 1,
item_code = item_code.GTIN,
bar_code = "",
mat_code = item.Value.MaterialCode,
quantity = item.Value.Quantity,
selling_price = item.Value.SellingPrice,
curr_code = "",
amount = item.Value.Amount,
discount = item.Value.Discount,
net = item.Value.Net,
vat = 0,
vat_code = "2",
vat_rate = 0,
disc_code = "",
disc_rate = item.Value.DiscountRate,
promo_code = item.Value.PromoCode,
staff_code = new_order.sale_code,
staff_comm_rate = 0,
cancel_status = false,
add_datetime = DateTime.Now,
update_datetime = DateTime.Now,
user_add = new_order.sale_code,
user_update = new_order.sale_code,
//time_stamp = "",
line_cancel = false,
discount2 = item.Value.SPDiscount,
disc_rate2 = item.Value.SPDiscountRate,
net2 = item.Value.TotalNet,
vat2 = 0
};
_posDB.df_trans_onls.InsertOnSubmit(new_item);
_posDB.SubmitChanges();
if (item.Value.Discount > 0)
{
line_disc_no = line_disc_no + 1;
df_pdiscount_onl new_pdiscount = new df_pdiscount_onl()
{
branch_no = new_order.branch_no.Trim(),
data_date = DateTime.Now.Date,
machine_no = new_order.machine_no.Trim(),
doc_no = docno.ToString("00000"),
plu_line_no = new_item.line_no,
disc_line_no = line_disc_no,
disc_rate = (decimal)new_item.disc_rate,
disc_per = (decimal)new_item.disc_rate > 0 ? (decimal)new_item.discount : 0,
disc_amount = (decimal)new_item.disc_rate <= 0 ? (decimal)new_item.discount : 0,
promo_code = item.Value.PromoCode,
bybill_flag = false,
bybill_runno = 1,
disc_type = 1,
del_flag = null,
cancel_status = false,
add_datetime = DateTime.Now,
update_datetime = DateTime.Now,
user_add = new_item.user_add,
user_update = new_item.user_update,
//time_stamp = "",
QRCode = new Guid("00000000-0000-0000-0000-000000000000"),
method_code = "",
subsidize = 0
};
_posDB.df_pdiscount_onls.InsertOnSubmit(new_pdiscount);
_posDB.SubmitChanges();
}
if (item.Value.SPDiscount > 0)
{
line_disc_no = line_disc_no + 1;
df_pdiscount_onl new_pdiscount = new df_pdiscount_onl()
{
branch_no = new_order.branch_no,
data_date = DateTime.Now.Date,
machine_no = new_order.machine_no,
doc_no = docno.ToString("00000"),
plu_line_no = new_item.line_no,
disc_line_no = line_disc_no,
disc_rate = (decimal)item.Value.SPDiscountRate,
disc_per = (decimal)item.Value.SPDiscountRate > 0 ? (decimal)item.Value.SPDiscount : 0,
disc_amount = (decimal)item.Value.SPDiscount <= 0 ? (decimal)item.Value.SPDiscount : 0,
promo_code = item.Value.SPPromoCode,
bybill_flag = true,
bybill_runno = 2,
disc_type = 2,
del_flag = null,
add_datetime = DateTime.Now,
update_datetime = DateTime.Now,
user_add = new_item.user_add,
user_update = new_item.user_update,
//time_stamp = "",
//QRCode = "",
//method_code = "",
//subsidize = ""
};
_posDB.df_pdiscount_onls.InsertOnSubmit(new_pdiscount);
_posDB.SubmitChanges();
}
}
// new df_payment_onl
var master_paymath = _posDB.df_paymeths.ToList();
foreach (var payment in order.Payments.Select((value, index) => new { Value = value, Index = index }))
{
decimal amt_curr = 0;
var paymath = master_paymath.FirstOrDefault(x => x.method_code.Trim() == payment.Value.Code.Trim());
if (paymath != null)
{
if (paymath.check_voucher || paymath.is_cashcard)
{
amt_curr = 0;
}
else
{
amt_curr = payment.Value.Amount * 1;
}
}
df_payment_onl new_payment = new df_payment_onl()
{
branch_no = new_order.branch_no.Trim(),
data_date = DateTime.Now.Date,
machine_no = new_order.machine_no.Trim(),
doc_no = docno.ToString("00000"),
line_no = payment.Index + 1,
method_code = payment.Value.Code.Trim(),
payment_date = DateTime.Now,
amount = payment.Value.Amount,
amount_round = 0,
amount_curr = amt_curr,
curr_code = "THB",
curr_rate = 1,
cashier_code = new_order.cashier_code.Trim(),
posid = new_order.machine_no.Trim(),
cred_card_no = "",
cred_card_name = "",
expiry_date = null,
approve_code = "",
del_flag = null,
add_datetime = DateTime.Now,
update_datetime = DateTime.Now,
user_add = new_order.user_add,
user_update = new_order.user_update,
//time_stamp = "",
amount2 = payment.Value.Amount,
amount_curr2 = amt_curr,
BankOfEDC = "",
AliBarcode = "",
AliMerchantID = "",
AliTransID = "",
AlipayCancel = false
};
_posDB.df_payment_onls.InsertOnSubmit(new_payment);
_posDB.SubmitChanges();
}
// order_session db save
order_result = SaveSessionOrder(_posDB, order, new_order);
//tran.Complete();
}
catch (Exception ex)
{
//tran.Dispose();
throw ex;
}
//}
return(order_result);
}
