public static DataRow GetOrderTypesDetails(int OrderTypeID) { try { PIKCV.DAL.OrderTypes obj = new PIKCV.DAL.OrderTypes(); obj.Where.OrderTypeID.Value = OrderTypeID; obj.Query.Load(); return(obj.DefaultView.ToTable().Rows[0]); } catch (Exception) { return(null); } }
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); } }