//public void CreateReceiveReceipt(string payedAmount, string payType, string issueDate, string bankName, Guid customerID, EntityDbHelper dbHelper)
//{
// // Create ReceiveReceipt
// var financialYearID = new FinancialYearBL().GetUserActiveFinancialYearID();
// var financialGroupID = dbHelper.FetchMultiple("cmn.FinancialGroup", "IsDefault = 1", null, null, null, null).Entities[0].GetFieldValue<Guid>("ID");
// var lastReceiptNumber = cmn.Instance.GetFieldMaxIntValue("ReceiptNumber", "rp_ReceiveReceipts", string.Format("FinancialYear = '{0}'", financialYearID));
// var receiveReceipt = dbHelper.CreateNewEntity("rp.ReceiveReceipt");
// receiveReceipt.SetFieldValue("FinancialYear", financialYearID);
// receiveReceipt.SetFieldValue("FinancialGroup", financialGroupID);
// receiveReceipt.SetFieldValue("Payer", customerID);
// receiveReceipt.SetFieldValue("ReceiptDate", issueDate);
// receiveReceipt.SetFieldValue("TotalAmount", payedAmount);
// receiveReceipt.SetFieldValue("Description", "رسید دریافت از طریق وب سرویس ترازنگار");
// receiveReceipt.SetFieldValue("ReceiptNumber", lastReceiptNumber + 1);
// dbHelper.ApplyChanges(receiveReceipt);
// // Create ReceiveReceiptItems
// var receiveReceiptItem = dbHelper.CreateNewEntity("rp.ReceiveReceiptItem");
// receiveReceiptItem.SetFieldValue("ReceiveReceipt", receiveReceipt.GetFieldValue<Guid>("ID"));
// var receiveType = dbHelper.FetchSingle("rp.ReceiveType", string.Format("Name = '{0}'", payType), null);
// if (payType == "Havale")
// {
// if (receiveType != null)
// {
// var receiveTypeID = receiveType.GetFieldValue<Guid>("ID");
// receiveReceiptItem.SetFieldValue("ReceiveType", receiveTypeID);
// var financialOpKind = dbHelper.FetchSingle("sacc.FinancialOpKind", "Name = 'VarizBeSaderat'", null);
// if (financialOpKind != null)
// {
// var financialOpKindID = financialOpKind.GetFieldValue<Guid>("ID");
// receiveReceiptItem.SetFieldValue("FinancialOpKind", financialOpKindID);
// var naghdeDaryafti = dbHelper.CreateNewEntity("rp.NaghdeDaryafti");
// receiveReceiptItem.SetFieldValue("FinancialItem_Naghd", naghdeDaryafti.GetFieldValue<Guid>("ID"));
// var cash = dbHelper.FetchMultiple("sacc.Cash", null, null, null, null, null);
// naghdeDaryafti.SetFieldValue("Payer", customerID);
// naghdeDaryafti.SetFieldValue("Amount", payedAmount);
// naghdeDaryafti.SetFieldValue("Cash", cash.Entities[0].GetFieldValue<Guid>("ID"));
// naghdeDaryafti.SetFieldValue("Description", "دریافت نقدی از طریق وب سرویس");
// dbHelper.ApplyChanges(naghdeDaryafti);
// dbHelper.ApplyChanges(receiveReceiptItem);
// }
// }
// }
// else if (payType == "Naghd")
// {
// if (receiveType != null)
// {
// var receiveTypeID = receiveType.GetFieldValue<Guid>("ID");
// receiveReceiptItem.SetFieldValue("ReceiveType", receiveTypeID);
// var financialOpKind = dbHelper.FetchSingle("sacc.FinancialOpKind", "Name = 'DaryaftNaghdi'", null);
// if (financialOpKind != null)
// {
// var financialOpKindID = financialOpKind.GetFieldValue<Guid>("ID");
// receiveReceiptItem.SetFieldValue("FinancialOpKind", financialOpKindID);
// var naghdeDaryafti = dbHelper.CreateNewEntity("rp.NaghdeDaryafti");
// receiveReceiptItem.SetFieldValue("FinancialItem_Naghd", naghdeDaryafti.GetFieldValue<Guid>("ID"));
// var cash = dbHelper.FetchMultiple("sacc.Cash", null, null, null, null, null);
// naghdeDaryafti.SetFieldValue("Payer", customerID);
// naghdeDaryafti.SetFieldValue("Amount", payedAmount);
// naghdeDaryafti.SetFieldValue("Cash", cash.Entities[0].GetFieldValue<Guid>("ID"));
// naghdeDaryafti.SetFieldValue("Description", "دریافت نقدی از طریق وب سرویس");
// dbHelper.ApplyChanges(naghdeDaryafti);
// dbHelper.ApplyChanges(receiveReceiptItem);
// }
// }
// }
//}
public void CreateAccDoc(Entity accDocEntity, decimal payedAmount, string issueDate, EntityDbHelper dbHelper)
{
var balanceStatusID = OptionSetHelper.GetOptionSetItemID("acc.BalanceStatus", "Balance");
var docStatusID = OptionSetHelper.GetOptionSetItemID("acc.DocStatus", "NotChecked");
var docKindID = new DocKindBL().GetDocKindID("ComposeDoc");
var financialYearID = new FinancialYearBL().GetUserActiveFinancialYearID();
var financialGroupID = dbHelper.FetchMultiple("cmn.FinancialGroup", "IsDefault = 1", null, null, null, null).Entities[0].GetFieldValue <Guid>("ID");
accDocEntity.SetFieldValue("IssueDate", issueDate);
accDocEntity.SetFieldValue("FinancialYear", financialYearID);
accDocEntity.SetFieldValue("FinancialGroup", financialGroupID);
accDocEntity.SetFieldValue("DocKind", docKindID);
accDocEntity.SetFieldValue("IsAutoGenerated", false);
accDocEntity.SetFieldValue("BalanceStatus", balanceStatusID);
accDocEntity.SetFieldValue("DocStatus", docStatusID);
accDocEntity.SetFieldValue("RemainingAmount", payedAmount);
accDocEntity.SetFieldValue("IsActive", 1);
accDocEntity.SetFieldValue("Description", "سند تولید شده از طریق وب سرویس");
dbHelper.ApplyChanges(accDocEntity);
}
public Guid?GetTodayAccDoc(string docKindName, Guid financialDocTypeID, DateTime issueDate, Guid organizationUnitID)
{
var dbHelper = CoreComponent.Instance.MainDbHelper;
var docKindID = new DocKindBL().GetDocKindID(docKindName);
var accDocs = dbHelper.FetchMultiple("acc.accDoc",
string.Format("FinancialYear = '{0}' and DocKind = '{1}' and FinancialDocType = '{2}' and IssueDate = '{3}' and OrganizationUnit = '{4}'",
new FinancialYearBL().GetUserActiveFinancialYearID(), docKindID, financialDocTypeID, issueDate.ToString().Split(' ')[0], organizationUnitID),
"DocNo", null, null, null).Entities;
if (accDocs.Count > 1)
{
throw new AfwException("بیش از یک سند حسابداری برای این عملیات در روز جاری ثبت شده است.");
}
else if (accDocs.Count == 0)
{
return(null);
}
else
{
return(accDocs[0].GetFieldValue <Guid?>("ID"));
}
}