//Ýþlem Raporlarý
public DataTable GetTransactionReport(int CompanyID, PIKCV.COM.EnumDB.OrderTypeCode OrderType_CV, PIKCV.COM.EnumDB.OrderTypeCode OrderType_BuyCredit, PIKCV.COM.EnumDB.OrderProcessTypeCode GetTransactionReport, bool IsConfirmed,
PIKCV.COM.EnumDB.LanguageID LanguageID, DateTime OrderStartDate, DateTime OrderEndDate)
{
DataTable dt;
try
{
PIKCV.DAL.Orders obj = new PIKCV.DAL.Orders();
dt = obj.GetTransactionReport(CompanyID, (int)OrderType_CV, (int)OrderType_BuyCredit, (int)GetTransactionReport, IsConfirmed, (int)LanguageID, OrderStartDate, OrderEndDate);
}
catch (Exception)
{
dt = null;
throw;
}
return(dt);
}
protected void rptReports_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
int m_TotalCreditUsed = int.Parse(((Literal)e.Item.FindControl("ltlCreditForCalc")).Text);
this.TotalCreditUsed += m_TotalCreditUsed;
this.TotalPrice += float.Parse(((Literal)e.Item.FindControl("ltlPriceForCalc")).Text);
PIKCV.COM.EnumDB.OrderTypeCode OrderTypeCode = (PIKCV.COM.EnumDB.OrderTypeCode)(int.Parse(((Literal)e.Item.FindControl("ltlOrderTypeForCalc")).Text));
if (OrderTypeCode == PIKCV.COM.EnumDB.OrderTypeCode.CreditBuy)
{
this.ChartBoughtCredit += m_TotalCreditUsed;
this.RemainderCredit += m_TotalCreditUsed;
}
else
{
this.ChartCreditUsed += m_TotalCreditUsed;
this.RemainderCredit -= m_TotalCreditUsed;
}
((Literal)e.Item.FindControl("ltlRemainderCredit")).Text = this.RemainderCredit.ToString();
}
}
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);
}
}
//Ýþlemler
public DataTable GetTransactions(int CompanyID, PIKCV.COM.EnumDB.OrderProcessTypeCode ProcessTypeCode, PIKCV.COM.EnumDB.LanguageID LanguageID, PIKCV.COM.EnumDB.OrderTypeCode OrderTypeCode)
{
DataTable dt;
try
{
PIKCV.DAL.Orders obj = new PIKCV.DAL.Orders();
dt = obj.GetTransactions(CompanyID, (int)ProcessTypeCode, (int)LanguageID, (int)OrderTypeCode);
}
catch (Exception)
{
dt = null;
throw;
}
return(dt);
}