public DataTable GetCreditOrderDetail(int CreditOrderID) { PIKCV.DAL.CreditOrders obj = new PIKCV.DAL.CreditOrders(); obj.Where.CreditOrderID.Value = CreditOrderID; obj.Query.Load(); return(obj.DefaultView.Table); }
public int InsertCreditOrders(int CompanyID, int CreditPackageID, int CreditQuantity, double ItemPrice, int OtherPackageQuantity , double OtherPackagePrice, PIKCV.COM.EnumDB.OrderTypeCode OrderTypeCode, PIKCV.COM.EnumDB.PaymentType PaymentType, bool IsOtherPackage) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); Tran.BeginTransaction(); int TakenCredit = 0; try { if (PaymentType == PIKCV.COM.EnumDB.PaymentType.Loan) { double TotalMoney = 0; if (CreditPackageID > 0) { TotalMoney = CreditQuantity * ItemPrice; TakenCredit = CreditQuantity; } else { TotalMoney = OtherPackageQuantity * OtherPackagePrice; TakenCredit = OtherPackageQuantity; } PIKCV.DAL.Companies objCompany = new PIKCV.DAL.Companies(); objCompany.LoadByPrimaryKey(CompanyID); objCompany.MaxLoan = objCompany.MaxLoan - TotalMoney; objCompany.Credits = objCompany.Credits + TakenCredit; objCompany.Save(); } PIKCV.DAL.CreditOrders objCreditOrders = new PIKCV.DAL.CreditOrders(); objCreditOrders.AddNew(); objCreditOrders.CompanyID = CompanyID; objCreditOrders.CreditPackageID = CreditPackageID; objCreditOrders.Quantity = CreditQuantity; objCreditOrders.ItemPrice = ItemPrice; objCreditOrders.OtherPackageQuantity = OtherPackageQuantity; objCreditOrders.OtherPackagePrice = OtherPackagePrice; objCreditOrders.OrderDate = DateTime.Now; objCreditOrders.OrderCode = Util.CreateRandomNumber(12); objCreditOrders.OrderTypeID = (int)OrderTypeCode; objCreditOrders.PaymentType = (int)PaymentType; objCreditOrders.Save(); PIKCV.DAL.Orders objOrder = new PIKCV.DAL.Orders(); objOrder.AddNew(); objOrder.CompanyID = CompanyID; if (PaymentType == PIKCV.COM.EnumDB.PaymentType.Transfer) { objOrder.IsConfirmed = false; objOrder.ProcessTypeCode = (int)PIKCV.COM.EnumDB.OrderProcessTypeCode.non_invoiced; } else { objOrder.IsConfirmed = true; objOrder.ProcessTypeCode = (int)PIKCV.COM.EnumDB.OrderProcessTypeCode.unpaid; } objOrder.OrderDate = DateTime.Now; objOrder.OrderTypeID = (int)OrderTypeCode; if (IsOtherPackage) { objOrder.Price = OtherPackageQuantity * OtherPackagePrice; objOrder.TotalCreditsUsed = OtherPackageQuantity; } else { objOrder.Price = CreditQuantity * ItemPrice; objOrder.TotalCreditsUsed = CreditQuantity; } objOrder.Save(); Tran.CommitTransaction(); return(objCreditOrders.CreditOrderID); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(0); } }