Exemplo n.º 1
0
 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);
     }
 }
Exemplo n.º 2
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);
            }
        }