public int ChangeJobStatus(int CompanyID, int JobID, PIKCV.COM.EnumDB.JobStatus NewJobStatus, int CreditsToDecrease, int JobListType, DateTime EndDate, PIKCV.COM.EnumDB.JobStatus CurrentJobStatus) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); try { Tran.BeginTransaction(); PIKCV.DAL.Jobs obj = new PIKCV.DAL.Jobs(); obj.LoadByPrimaryKey(JobID); if ((CurrentJobStatus == PIKCV.COM.EnumDB.JobStatus.Draft) || (EndDate < DateTime.Now)) { PIKCV.DAL.Orders objOrders = new PIKCV.DAL.Orders(); objOrders.AddNew(); objOrders.CompanyID = CompanyID; objOrders.OrderDate = DateTime.Now; objOrders.OrderTypeID = JobListType; objOrders.ProcessTypeCode = (int)PIKCV.COM.EnumDB.OrderProcessTypeCode.paid; objOrders.IsConfirmed = true; objOrders.Price = 0; objOrders.TotalCreditsUsed = CreditsToDecrease; objOrders.Save(); int LastOrderID = objOrders.OrderID; PIKCV.DAL.OrderLineItems objOL = new PIKCV.DAL.OrderLineItems(); objOL.AddNew(); objOL.CreditUsed = CreditsToDecrease; objOL.JobID = JobID; objOL.OrderID = LastOrderID; objOL.Price = 0; objOL.UserID = 0; objOL.Save(); PIKCV.DAL.Companies objCompany = new PIKCV.DAL.Companies(); objCompany.LoadByPrimaryKey(CompanyID); objCompany.Credits = objCompany.Credits - CreditsToDecrease; objCompany.Save(); obj.StartDate = DateTime.Now; obj.EndDate = DateTime.Now.AddDays(30); } obj.JobStatus = (int)NewJobStatus; obj.Save(); Tran.CommitTransaction(); return(obj.JobID); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(0); } }
//Insert CompanyOwnedUser public int InsertOrder(int CompanyID, int OrderTypeID, int ProcessType, int TotalCreditUsed, float Price, bool IsConfirmed, ref PIKCV.DAO.TransactionMgr Tran) { try { PIKCV.DAL.Orders objOrder = new PIKCV.DAL.Orders(); objOrder.AddNew(); objOrder.CompanyID = CompanyID; objOrder.OrderTypeID = OrderTypeID; objOrder.ProcessTypeCode = ProcessType; objOrder.TotalCreditsUsed = TotalCreditUsed; objOrder.Price = Price; objOrder.IsConfirmed = IsConfirmed; objOrder.OrderDate = DateTime.Now; objOrder.Save(); return(objOrder.OrderID); } catch (Exception) { //Tran.RollbackTransaction(); //PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(0); } }
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); } }
public int SaveApproval(int CompanyID, int JobID, int JobStatus, bool IsCompanyNameHidden, ref int NewCredit) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); try { Tran.BeginTransaction(); PIKCV.DAL.Jobs obj = new PIKCV.DAL.Jobs(); obj.LoadByPrimaryKey(JobID); if (JobStatus != (int)PIKCV.COM.EnumDB.JobStatus.Draft) { //ilanýn pik kredisini þirketten düþelim PIKCV.DAL.OrderTypes objOrderType = new PIKCV.DAL.OrderTypes(); objOrderType.LoadByPrimaryKey(obj.JobListType); int CreditsSpend = 0; PIKCV.COM.EnumDB.EmployeeTypes EmployeeTypes = (PIKCV.COM.EnumDB.EmployeeTypes)(obj.UserTypeID); switch (EmployeeTypes) { case PIKCV.COM.EnumDB.EmployeeTypes.Pikpool: CreditsSpend = objOrderType.PikPoolCredit; break; case PIKCV.COM.EnumDB.EmployeeTypes.Goodpik: CreditsSpend = objOrderType.GoodPikCredit; break; } PIKCV.DAL.Companies objCompany = new PIKCV.DAL.Companies(); objCompany.LoadByPrimaryKey(CompanyID); NewCredit = objCompany.Credits - CreditsSpend; objCompany.Credits = NewCredit; objCompany.Save(); PIKCV.DAL.Orders objOrders = new PIKCV.DAL.Orders(); objOrders.AddNew(); objOrders.CompanyID = CompanyID; objOrders.OrderDate = DateTime.Now; objOrders.OrderTypeID = obj.JobListType; objOrders.ProcessTypeCode = (int)PIKCV.COM.EnumDB.OrderProcessTypeCode.paid; objOrders.IsConfirmed = true; objOrders.Price = 0; objOrders.TotalCreditsUsed = CreditsSpend; objOrders.Save(); int LastOrderID = objOrders.OrderID; PIKCV.DAL.OrderLineItems objOL = new PIKCV.DAL.OrderLineItems(); objOL.AddNew(); objOL.CreditUsed = CreditsSpend; objOL.JobID = JobID; objOL.OrderID = LastOrderID; objOL.Price = 0; objOL.UserID = 0; objOL.Save(); //ilanýn pik kredisi düþürüldü þimdi ilaný kaydedelim } obj.JobStatus = JobStatus; obj.IsCompanyNameHidden = IsCompanyNameHidden; obj.ModifyDate = DateTime.Now; obj.Save(); Tran.CommitTransaction(); return(obj.JobID); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(0); } }