public bool InsertMemberPaid(b2bMemberPaid model)
{
#region set default
model.RowFlag = 1;
model.RowVersion = 1;
model.CreatedBy = "sa";
model.ModifiedBy = "sa";
model.ModifiedDate = DateTimeNow;
model.CreatedDate = DateTimeNow;
#endregion
qDB.b2bMemberPaids.InsertOnSubmit(model);
qDB.SubmitChanges();
IsResult = true;
return(IsResult);
}
public bool InsertPayment(b2bMemberPaid MemberPaid)
{
var count = CountData <b2bMemberPaid>(" * ", " CreatedDate = GetDate() ANDIsDelete = 0 ");
count = count + 1;
MemberPaid.MemberPaidCode = AutoGenCode("MP", count);
MemberPaid.CreatedDate = DateTimeNow;
MemberPaid.ModifiedDate = DateTimeNow;
MemberPaid.CreatedBy = "sa";
MemberPaid.ModifiedBy = "sa";
using (var trans = new TransactionScope())
{
qDB.b2bMemberPaids.InsertOnSubmit(MemberPaid);
qDB.SubmitChanges();
trans.Complete();
IsResult = true;
}
return(IsResult);
}
public bool UpdatePayment(b2bMemberPaid MemberPaid)
{
using (var trans = new TransactionScope())
{
UpdateByCondition <b2bMemberPaid>(@"BankID = '" + MemberPaid.BankID + "', "
+ "BranchName = '" + MemberPaid.BranchName
+ "',PayerAccName = '" + MemberPaid.PayerAccName
+ "',PayerAccNo = '" + MemberPaid.PayerAccNo
+ "',PaymentAccID = '" + MemberPaid.PaymentAccID
+ "',PayAmount = '" + MemberPaid.PayAmount
+ "',PaymentDate = '"
+ MemberPaid.PaymentDate.Value.ToString("yyyy-MM-dd")
+ "',PaymentTime = '" + MemberPaid.PaymentTime
+ "',SlipImgPath = '" + MemberPaid.SlipImgPath
+ "',PaymentStatus = '" + MemberPaid.PaymentStatus
+ "'", "MemberPaidID = " + MemberPaid.MemberPaidID);
trans.Complete();
IsResult = true;
}
return(IsResult);
}
public ActionResult Confirm(bool?Check, int OrderID, int BankID, string BranchName, string PayerAccName, string PayerAccNo, int PaymentAccID
, decimal PayAmount, string PaymentDate, string PaymentTime, string SlipImgPath, int?MemberPaidID)
{
GetStatusUser();
var svOrder = new OrderService();
var svComp = new CompanyService();
var model = new b2bMemberPaid();
Ouikum.Common.AddressService svAddress = new Ouikum.Common.AddressService();
var companies = svComp.SelectData <b2bCompany>(" * ", "CompID = " + LogonCompID).First();
var orders = svOrder.SelectData <b2bOrder>(" * ", "OrderID = " + OrderID).First();
#region Set Model
model.PayerName = companies.CompName;
model.BillRecieverName = companies.CompName;
model.PayerAddrLine1 = companies.CompAddrLine1;
model.BillAddrLine1 = companies.CompAddrLine1;
model.PayerDistrictID = companies.CompDistrictID;
model.BillDistrictID = companies.CompDistrictID;
model.PayerProvinceID = companies.CompProvinceID;
model.BillProvinceID = companies.CompProvinceID;
model.PayerPostalCode = companies.CompPostalCode;
model.BillPostalCode = companies.CompPostalCode;
model.PayerPhone = companies.CompPhone;
model.BillPhone = companies.CompPhone;
model.PayerFax = companies.CompFax;
model.BillFax = companies.CompFax;
model.PayerEmail = companies.ContactEmail;
model.BillEmail = companies.ContactEmail;
model.PayerMobile = companies.CompMobile;
model.BillMobile = companies.CompMobile;
model.BankID = BankID;
model.BranchName = BranchName;
model.PayerAccName = PayerAccName;
model.PayerAccNo = PayerAccNo;
model.PaymentAccID = PaymentAccID;
model.PayAmount = PayAmount;
model.PaymentTime = DataManager.ConvertToTimeSpan(PaymentTime);
model.SlipImgPath = SlipImgPath;
model.CompID = LogonCompID;
if (Check == false)
{
model.PaymentStatus = "R";
}
else
{
model.PaymentStatus = "N";
}
model.RowFlag = 1;
model.IsDelete = false;
model.IsShow = true;
#endregion
if (MemberPaidID > 0)
{
model.MemberPaidID = (int)MemberPaidID;
model.PaymentDate = ConvertStringToDateTime(PaymentDate, false);
svOrder.UpdatePayment(model);
}
else
{
model.PaymentDate = ConvertStringToDateTime(PaymentDate).AddYears(543);
model.RowVersion = 1;
svOrder.InsertPayment(model);
}
#region SaveSlipImg
//if (model.SlipImgPath != SlipImgPath)
//{
imgManager = new FileHelper();
imgManager.DirPath = "Companies/Slip/" + model.CompID;
imgManager.DirTempPath = "Temp/Companies/Slip/" + model.CompID;
imgManager.ImageName = SlipImgPath;
imgManager.FullHeight = 0;
imgManager.FullWidth = 0;
imgManager.ThumbHeight = 150;
imgManager.ThumbWidth = 150;
imgManager.SaveImageFromTemp();
//}
#endregion
var Provinces = svAddress.GetProvince().ToList();
var Districts = svAddress.GetDistrict().Where(m => m.ProvinceID == companies.CompProvinceID).ToList();
var Count = svOrder.CountData <b2bOrder>(" * ", "IsDelete = 0 AND OrderStatus = 'N' AND CompID = " + LogonCompID);
ViewBag.Count = Count;
ViewBag.companies = companies;
ViewBag.orders = orders;
ViewBag.District = Districts;
ViewBag.Province = Provinces;
ViewBag.MemberPaid = model;
return(View());
}
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 }));
}
