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 DataTable GetCompanyCreditSituation(int CompanyID)
{
PIKCV.DAL.Companies obj = new PIKCV.DAL.Companies();
return(obj.GetCompanyCreditSituation(CompanyID));
}
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);
}
}
