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); } }
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 bool InsertInterview(int CompanyID, int CompanyAdvisorID, DateTime InterviewDate, DateTime InterviewEndTime, PIKCV.COM.EnumDB.MemberTypes InterviewerTypeCode, string InterviewPlace, DateTime InterviewStartTime, int PositionID, int UpdatedBy, ArrayList arrSelectedUsers, string CompanyAdvisorName) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); try { PIKCV.DAL.Interviews objInterview = new PIKCV.DAL.Interviews(); PIKCV.DAL.Messages objMessage = new PIKCV.DAL.Messages(); PIKCV.DAL.User objUser = new PIKCV.DAL.User(); PIKCV.DAL.Companies objCompany = new PIKCV.DAL.Companies(); string MessageBody = ""; Tran.BeginTransaction(); for (int i = 0; i < arrSelectedUsers.Count; i++) { objInterview.AddNew(); objInterview.CompanyAdvisorID = CompanyAdvisorID; objInterview.CreateDate = DateTime.Now; objInterview.InterviewDate = InterviewDate; objInterview.InterviewEndTime = InterviewEndTime; objInterview.InterviewerID = CompanyID; objInterview.InterviewerTypeCode = (int)InterviewerTypeCode; objInterview.InterviewNotes = PIKCV.COM.Util.ReturnEmptyString(String.Empty); objInterview.InterviewPlace = InterviewPlace; objInterview.InterviewRating = 0; objInterview.InterviewStartTime = InterviewStartTime; objInterview.InterviewStatusID = 1; objInterview.JobID = 0; objInterview.PositionID = PositionID; objInterview.ModifyDate = DateTime.Now; objInterview.UpdatedBy = UpdatedBy; objInterview.UserID = Convert.ToInt32(arrSelectedUsers[i]); objInterview.Save(); objUser.LoadByPrimaryKey(Convert.ToInt32(arrSelectedUsers[i])); objCompany.LoadByPrimaryKey(CompanyID); MessageBody = objCompany.CompanyName + " þirketi tarafýndan mülakata çaðrýldýnýz" + "<br><br>Tarih: " + InterviewDate.ToShortDateString() + "<br><br>Saat: " + InterviewStartTime.Hour.ToString() + ":" + InterviewStartTime.Minute.ToString() + "-" + InterviewEndTime.Hour.ToString() + ":" + InterviewEndTime.Minute.ToString() + "<br><br>Yer: " + InterviewPlace + "<br><br>Danýþman: " + CompanyAdvisorName; objMessage.AddNew(); objMessage.CreateDate = DateTime.Now; objMessage.IsDeleted = false; objMessage.IsRead = false; objMessage.JobID = 0; objMessage.MessageOwnerID = Convert.ToInt32(arrSelectedUsers[i]); objMessage.MessageOwnerTypeCode = (int)PIKCV.COM.EnumDB.MemberTypes.Employee; objMessage.MessageTitle = "Mülakat Daveti"; objMessage.MessageBody = MessageBody; objMessage.MessageTypeCode = (int)PIKCV.COM.EnumDB.MessageTypeCode.Interview; objMessage.SenderID = CompanyID; objMessage.SenderTypeCode = (int)PIKCV.COM.EnumDB.MemberTypes.Company; objMessage.Save(); } Tran.CommitTransaction(); return(true); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(false); } }
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); } }