protected string Imbalanced_Vouchars()
{
iDB.Communicate dbComm = new iDB.Communicate();
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Transact.objTransaction objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
IDataReader idr = dbComm.SelectCMD("Select transGroupID, Sum(transAmount) as transAmount, max(transNarration) as transNarration, max(transCreatedOn) as transCreatedOn from fin_Transactions where transGroupID in (select transGroupID from fin_TransGroups) group by transGroupID");
string output = "";
if (idr != null)
{
while (idr.Read())
{
int transGroupID = Convert.ToInt32(idr["transGroupID"]);
objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
objTransG = bTransG.Select(transGroupID);
decimal crTotal = 0, drTotal = 0, OCrTotal = 0, ODrTotal = 0;
if (objTransG != null)
{
if (objTransG.Get_Transactions() != null)
{
foreach (var item in objTransG.Get_Transactions())
{
if (item.transDrAccount == null)
{
OCrTotal += item.transAmount;
}
else
{
ODrTotal += item.transAmount;
}
}
}
if (ODrTotal == OCrTotal)
{
//output += string.Format("<td>Balanced<td>");
}
else
{
if (!string.IsNullOrEmpty(output))
{
output += ",";
}
output += transGroupID.ToString();
}
}
}
}
return(output);
}
protected void lvGrid_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "approve_this")
{
int transGId = Convert.ToInt32(e.CommandArgument);
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
bTransG.MarkGroupApproved(transGId, thisUser);
}
}
protected void lbtnDeleteVouchar_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
int transGroupId = Convert.ToInt32(Request.QueryString["gid"]);
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
bTransG.Delete(transGroupId);
Response.Redirect("~/FinApp/Transactions.aspx", false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && !string.IsNullOrEmpty(Request.QueryString["id"]))
{
int voucharId = Convert.ToInt32(Request.QueryString["id"]);
iBiz.FinPro.Transactions.Groups bTransGroup = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransGroup = new iBiz.FinPro.Transactions.Groups.objGroup();
objTransGroup = bTransGroup.Select(voucharId);
if (objTransGroup != null)
{
iBiz.FinPro.UserProfile bProfile = new iBiz.FinPro.UserProfile();
iBiz.FinPro.UserProfile.objUserProfile objProfile = new iBiz.FinPro.UserProfile.objUserProfile();
objProfile = bProfile.Select(objTransGroup.transGroupCreatedBy);
string CreatedBy = "Unknown";
if (objProfile != null)
{
CreatedBy = objProfile.userFirstName + " " + objProfile.userLastName;
}
string VerfiedBy = "Unverified";
if (objTransGroup.transGroupApprovedBy != null)
{
objProfile = new iBiz.FinPro.UserProfile.objUserProfile();
objProfile = bProfile.Select(objTransGroup.transGroupApprovedBy.Value);
if (objProfile != null)
{
VerfiedBy = objProfile.userFirstName + " " + objProfile.userLastName;
}
}
iBiz.FinPro.Modules.Info bModuleInfo = new iBiz.FinPro.Modules.Info();
string reportTitle = "Vouchar";
if (objTransGroup.transGroupPrefixNo.HasValue)
{
reportTitle = bModuleInfo.singular_Title(objTransGroup.transGroupPrefixNo.Value);
}
Report raReport = new rpTransaction(voucharId, objTransGroup.transGroupPrefixString + objTransGroup.transGroupForeNumber.ToString(), true, objTransGroup.transGroupCreatedOn.ToString("MMM dd, yyyy"), objTransGroup.transGroupTitle, objTransGroup.transGroupRefId, CreatedBy, VerfiedBy, "Apprv By", "Rev by", reportTitle);
rvReport.Report = raReport;
}
}
}
protected void Payments()
{
iDB.Communicate dbComm = new iDB.Communicate();
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Transact.objTransaction objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
IDataReader idr = dbComm.SelectCMD("Select transGroupID, Sum(transAmount) as transAmount, max(transNarration) as transNarration, max(transCreatedOn) as transCreatedOn from fin_Transactions where transType=3 group by transGroupID");
if (idr != null)
{
while (idr.Read())
{
int transGroupId = Convert.ToInt32(idr["transGroupId"]);
objTransG.transGroupCreatedBy = 1;
objTransG.transGroupCreatedOn = Convert.ToDateTime(idr["transCreatedOn"]);
objTransG.transGroupForeNumber = bTransG.New_Group_Fore_Number(2, "INV", DateTime.Now);
objTransG.transGroupID = transGroupId;
objTransG.transGroupPrefixNo = 2;
objTransG.transGroupPrefixString = "INV";
objTransG.transGroupStatus = 1;
objTransG.transGroupTitle = "Invoice Created on " + objTransG.transGroupCreatedOn.ToString("MMM dd, yyyy");
objTransG.transGroupTotalAmount = Convert.ToDecimal(idr["transAmount"]);
objTransG.transTransCount = 0;
bTransG.Add(objTransG);
}
}
idr = null;
idr = dbComm.SelectCMD("SELECT * FROM [fin_Transactions] where (transType=3) and Not (transDrAccount is Null or transCrAccount is Null)");
if (idr != null)
{
while (idr.Read())
{
int transId = Convert.ToInt32(idr["transId"]);
iBiz.FinPro.Transactions.Transact.objTransaction objTempTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = bTrans.Select(transId);
objTempTrans = bTrans.Select(transId);
objTrans.transCrAccount = null;
//objTrans.transType = 2;
objTempTrans.transDrAccount = null;
//objTempTrans.transType = 2;
bTrans.Update(objTrans);
bTrans.Add(objTempTrans);
}
}
}
protected void btnSubmitForm_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// Check for Financial Year Lock <<<<<<<<<<<<<<<
iBiz.FinPro.FinYears finyear = new iBiz.FinPro.FinYears();
if (!finyear.isLock(Convert.ToDateTime(tbDate.Text)))
{
iBiz.FinPro.Transactions.Groups bTransGroup = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Transact.objTransaction objTrans;
iBiz.FinPro.Transactions.Groups.objGroup objTransGroup = new iBiz.FinPro.Transactions.Groups.objGroup();
iBiz.FinPro.Accounts bAcc = new iBiz.FinPro.Accounts();
int defaultDept = Convert.ToInt32(ddlDefautlDept.SelectedValue);
int itemsCount = 0;
decimal totalAmount = 0;
//decimal totalCredit = 0;
//decimal uTotalDebit = 0;
//decimal uTotalCredit = 0;
bool hasNoDepartment = false;
int finYear = DateTime.Now.Year;
DateTime selectedDate = DateTime.Now;
if (selectedDate.Month < 6)
{
finYear = finYear - 1;
}
DateTime financialYear = Convert.ToDateTime("07/01/" + finYear.ToString());
bTrans.Delete_Untagged(thisUser);
if (rptVoucherItems.Items.Count > 0)
{
foreach (RepeaterItem item in rptVoucherItems.Items)
{
foreach (Control ctrlItem in item.Controls)
{
if (ctrlItem is HiddenField)
{
if (ctrlItem.ClientID.ToLower().Contains("hfitemno"))
{
string itemNo, transId, drAccountId, crAccountId, deptId, description, additionalTransId, amount;
HiddenField hfINo = (HiddenField)ctrlItem;
RadComboBox ddlDebitAccounts = (RadComboBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlDebitAccounts"));
RadComboBox ddlCreditAccounts = (RadComboBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlCreditAccount"));
DropDownList ddlDepts = (DropDownList)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlDept"));
TextBox tbDescription = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "tbDescription"));
TextBox tbAmount = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "tbAmount"));
HiddenField hfTransId = (HiddenField)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "hfTransID"));
HiddenField hfAdditionalTransId = (HiddenField)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "hfAdditionalTransId"));
iBiz.FinPro.Accounts.objAccount objAcc = new iBiz.FinPro.Accounts.objAccount();
itemNo = hfINo.Value;
transId = hfTransId.Value;
drAccountId = ddlDebitAccounts.SelectedValue != null ? ddlDebitAccounts.SelectedValue : "";
crAccountId = ddlCreditAccounts.SelectedValue != null ? ddlCreditAccounts.SelectedValue : "";
deptId = ddlDepts.SelectedValue;
description = tbDescription.Text;
amount = tbAmount.Text;
additionalTransId = hfAdditionalTransId.Value;
decimal transAmount = 0;
decimal.TryParse(amount, out transAmount);
if (transAmount > 0)
{
if (transId != "0")
{
// Delete existing trans
if (iBiz.FinPro.Rights.edit_vouchar)
{
bTrans.Delete(Convert.ToInt32(transId));
}
}
if (hasNoDepartment || (Convert.ToInt32(deptId) <= 0 && defaultDept == 0))
{
hasNoDepartment = true;
}
//Check for Additional Trans
if (!string.IsNullOrEmpty(additionalTransId))
{
if (additionalTransId != "0")
{
iBiz.FinPro.Modules.AdditionalTransactions bAdditionalTrans = new iBiz.FinPro.Modules.AdditionalTransactions();
bAdditionalTrans.Do_Transactions_For_Predefined(0, Convert.ToInt32(additionalTransId), transAmount, "Description", transAmount, moduleId, financialYear, selectedDate, thisUser, Convert.ToInt32(deptId));
}
}
if (!string.IsNullOrEmpty(drAccountId))
{
if (Convert.ToInt32(drAccountId) > 0)
{
//Debit Transaction
objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans.transAmount = transAmount;
objTrans.transDrAccount = Convert.ToInt32(drAccountId);
objTrans.transCrAccount = null;
objTrans.transSystemRestrict = false;
objTrans.transCreatedBy = thisUser;
objTrans.transCreatedOn = DateTime.Now;
objTrans.transGroupID = 0;
objTrans.transIsCompound = true;
objTrans.transNarration = description;
objTrans.transStatus = 1;
objTrans.transSystemIndex = 1;
objTrans.deptId = Convert.ToInt32(deptId);
if (deptId == "0")
{
objTrans.deptId = defaultDept;
}
objTrans.transType = 1;
objTrans.transUpdatedBy = thisUser;
objTrans.transUpdatedOn = DateTime.Now;
bTrans.Add(objTrans);
itemsCount++;
}
}
if (!string.IsNullOrEmpty(crAccountId))
{
if (Convert.ToInt32(crAccountId) > 0)
{
//Credit Transaction
objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans.transAmount = transAmount;
objTrans.transDrAccount = null;
objTrans.transCrAccount = Convert.ToInt32(crAccountId);
objTrans.transSystemRestrict = false;
objTrans.transCreatedBy = thisUser;
objTrans.transCreatedOn = DateTime.Now;
objTrans.transGroupID = 0;
objTrans.transIsCompound = true;
objTrans.transNarration = description;
objTrans.transStatus = 1;
objTrans.transSystemIndex = 1;
objTrans.deptId = Convert.ToInt32(deptId);
if (deptId == "0")
{
objTrans.deptId = defaultDept;
}
objTrans.transType = 1;
objTrans.transUpdatedBy = thisUser;
objTrans.transUpdatedOn = DateTime.Now;
bTrans.Add(objTrans);
totalAmount += Convert.ToDecimal(amount);
itemsCount++;
}
}
}
else
{
// Delete existing trans
if (iBiz.FinPro.Rights.edit_vouchar)
{
bTrans.Delete(Convert.ToInt32(transId));
}
}
}
}
}
}
if (itemsCount > 0)
{
int groupID = 0;
if (true)
{
if (!hasNoDepartment)
{
string fullVoucharNo = "N/A";
objTransGroup.transGroupCreatedBy = thisUser;
objTransGroup.transGroupCreatedOn = selectedDate;
objTransGroup.transGroupForeNumber = bTransGroup.New_Group_Fore_Number(moduleId, short_Title, objTransGroup.transGroupCreatedOn);
objTransGroup.transGroupPrefixNo = moduleId;
objTransGroup.transGroupPrefixString = short_Title;
objTransGroup.transGroupStatus = 1;
objTransGroup.transGroupTitle = tbDescription.Text.Trim();
objTransGroup.transGroupTotalAmount = totalAmount;
objTransGroup.transTransCount = itemsCount;
objTransGroup.transGroupIsOfficial = 1;
objTransGroup.transGroupOfficialTotalAmount = totalAmount;
objTransGroup.transGroupRefId = tbRefId.Text;
objTransGroup.transCField1 = tbCustomValue1.Text;
objTransGroup.transCField2 = tbCustomValue2.Text;
objTransGroup.transCField3 = tbCustomValue3.Text;
objTransGroup.transCField4 = tbCustomValue4.Text;
fullVoucharNo = objTransGroup.transGroupPrefixNo.ToString() + short_Title + objTransGroup.transGroupForeNumber.ToString();
groupID = bTransGroup.Add(objTransGroup).Value;
// Upload Attachments
iBiz.FinPro.Transactions.Attachments bTransAtt = new iBiz.FinPro.Transactions.Attachments();
if (groupID > 0)
{
if (radSyncAttachments.UploadedFiles.Count > 0)
{
for (int i = 0; i < radSyncAttachments.UploadedFiles.Count; i++)
{
string guid = Guid.NewGuid().ToString();
string fileExt = radSyncAttachments.UploadedFiles[i].GetExtension();
radSyncAttachments.UploadedFiles[i].SaveAs(Server.MapPath("~/Attachments/") + guid + fileExt, true);
iBiz.FinPro.Transactions.Attachments.objAttachment objTranAtt = new iBiz.FinPro.Transactions.Attachments.objAttachment();
objTranAtt.attachmentMaskedFileName = guid + fileExt;
objTranAtt.attachmentOriginalFileName = radSyncAttachments.UploadedFiles[i].FileName;
objTranAtt.transGroupID = groupID;
bTransAtt.Add(objTranAtt);
}
}
}
bTrans.Update_Group(thisUser, 0, groupID);
bTrans.Update_Group(thisUser, -1, groupID);
rnNotify.Show("Vouchar has been Created.<br /><br />Vouchar No. is " + fullVoucharNo + "<br /><br />");
// Look for Additional Items
iBiz.FinPro.Modules.AdditionalTransactions bAT = new iBiz.FinPro.Modules.AdditionalTransactions();
ControlCollection ctrlAdditionalItems = rptVoucherItems.Controls[rptVoucherItems.Controls.Count - 1].Controls;
foreach (Control ctrlItem in ctrlAdditionalItems)
{
if (ctrlItem.ClientID.Contains("rptAdditionalItems"))
{
Repeater rptAdditionalItems = (Repeater)ctrlItem;
foreach (RepeaterItem item in rptAdditionalItems.Items)
{
foreach (Control ctrlHFID in item.Controls)
{
if (ctrlHFID is HiddenField)
{
if (ctrlHFID.ClientID.Contains("hfAdditionalTransId"))
{
HiddenField hfAdditionalItem = (HiddenField)ctrlHFID;
TextBox tbAdditionalDescription = (TextBox)Form.FindControl(hfAdditionalItem.UniqueID.Replace("hfAdditionalTransId", "tbAdditionalDescription"));
TextBox tbAdditionalAmount = (TextBox)Form.FindControl(hfAdditionalItem.UniqueID.Replace("hfAdditionalTransId", "tbAddiotionalAmount"));
decimal additionalAmount;
if (decimal.TryParse(tbAdditionalAmount.Text.Trim().Replace("%", ""), out additionalAmount))
{
bAT.Do_Transactions(groupID, Convert.ToInt32(hfAdditionalItem.Value), additionalAmount, tbAdditionalDescription.Text, totalAmount, selectedDate, thisUser);
}
}
}
}
}
}
}
}
else
{
bTrans.Delete_Untagged(thisUser);
rnNotify.Show("You must assign department to all items.");
}
}
}
else
{
//imbalanced Debit and Credit
bTrans.Delete_Untagged(thisUser);
if (itemsCount == 0)
{
bTrans.Delete_Untagged(thisUser);
rnNotify.Show("No valid transaction found.");
}
else
{
bTrans.Delete_Untagged(thisUser);
rnNotify.Show("Debit and Credit sides are not equal.");
}
}
}
}
else
{
rnNotify.Show("Financial year is locked.");
}
}
}
protected void Load_Items(bool addMore, bool doReset)
{
int moduleParameterId = 0;
if (!string.IsNullOrEmpty(ddlBranch.SelectedValue))
{
moduleParameterId = Convert.ToInt32(ddlBranch.SelectedValue);
}
if (doReset)
{
rptVoucherItems.DataSourceID = null;
rptVoucherItems.DataBind();
}
if (Request.QueryString["gid"] != null && addMore == false)
{
int groupId = Convert.ToInt32(Request.QueryString["gid"]);
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
objTransG = bTransG.Select(groupId);
if (objTransG != null)
{
//if (objTransG.transGroupIsOfficial != isOfficial)
//{
// Response.Redirect("~/", false);
//}
//tbDescription.Text = objTransG.transGroupTitle;
//radVoucharDate.SelectedDate = objTransG.transGroupCreatedOn;
//tbRefId.Text = objTransG.transGroupRefId;
//tbCustomValue1.Text = objTransG.transCField1;
//tbCustomValue2.Text = objTransG.transCField2;
//tbCustomValue3.Text = objTransG.transCField3;
//tbCustomValue4.Text = objTransG.transCField4;
rptVoucherItems.DataSource = bTrans.Select_Grp(groupId, Convert.ToBoolean(isOfficial));
rptVoucherItems.DataBind();
//hplPrintVouchar.Visible = true;
//hplPrintVouchar.NavigateUrl = hplPrintVouchar.NavigateUrl + "?id=" + objTransG.transGroupID.ToString();
//tr_lbtnUpdate.Visible = objTransG.transGroupApprovedBy.HasValue ? false : true;
//tr_lbtnDelete.Visible = objTransG.transGroupApprovedBy.HasValue ? false : true;
//lbtnAddRow.Visible = objTransG.transGroupApprovedBy.HasValue ? false : true;
//tr_TotalRow.Visible = true;
//ltrTotalCredit.Text = Comma_Amount(objTransG.Get_Total_Credit());
//ltrTotalDebit.Text = Comma_Amount(objTransG.Get_Total_Debit());
}
}
DataTable dt = new DataTable();
dt.Columns.Add("additionalTransId");
dt.Columns.Add("itemNo");
dt.Columns.Add("chkShowOff");
dt.Columns.Add("transID");
dt.Columns.Add("drAccountId");
dt.Columns.Add("crAccountId");
dt.Columns.Add("deptId");
dt.Columns.Add("description");
dt.Columns.Add("amount");
int iNo = 0;
foreach (RepeaterItem item in rptVoucherItems.Items)
{
foreach (Control ctrlItem in item.Controls)
{
if (ctrlItem is HiddenField)
{
if (ctrlItem.ClientID.ToLower().Contains("hfitemno"))
{
iNo++;
string itemNo, showOff, transId, drAccountId, crAccountId, deptId, description, amount;
HiddenField hfINo = (HiddenField)ctrlItem;
RadComboBox ddlDebitAccounts = (RadComboBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlDebitAccounts"));
RadComboBox ddlCreditAccounts = (RadComboBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlCreditAccount"));
DropDownList ddlDepts = (DropDownList)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlDept"));
TextBox tbDescription = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "tbDescription"));
TextBox tbAmount = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "tbAmount"));
HiddenField hfTransId = (HiddenField)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "hfTransID"));
itemNo = hfINo.Value;
//showOff = Convert.ToInt32(chkShowOff.Checked).ToString();
showOff = "1";
transId = hfTransId.Value;
//accountId = ddlAccounts.SelectedValue;
drAccountId = ddlDebitAccounts.SelectedValue;
crAccountId = ddlCreditAccounts.SelectedValue;
deptId = ddlDepts.SelectedValue;
description = tbDescription.Text;
amount = tbAmount.Text.Length > 0 ? tbAmount.Text.Replace(",", "") : "";
dt.Rows.Add(null, itemNo, showOff, transId, drAccountId, crAccountId, deptId, description, Comma_Amount(amount));
}
}
}
}
//get Preset Accounts
iBiz.FinPro.Modules.fin_Modules bModules = new iBiz.FinPro.Modules.fin_Modules();
IDataReader idr;
if (isOfficial == 0)
{
idr = bModules.Get_Preselected_Items(moduleId, moduleParameterId, false);
}
else
{
idr = bModules.Get_Preselected_Items(moduleId, moduleParameterId, true);
}
if (idr != null && !addMore && string.IsNullOrEmpty(Request.QueryString["gid"]))
{
while (idr.Read())
{
int additionalTransId = Convert.ToInt32(idr["additionalTransId"]);
int selectedAccountId = Convert.ToInt32(idr["autoTransAccountId"]);
string transDescription = idr["autoTransNarration"].ToString();
dt.Rows.Add(additionalTransId, iNo + 1, 1, 0, selectedAccountId, 0, transDescription, "", "");
}
}
if (addMore || rptVoucherItems.Items.Count == 0)
{
dt.Rows.Add(null, iNo + 1, 1, 0, 0, 0, "", "", "");
dt.Rows.Add(null, iNo + 2, 1, 0, 0, 0, "", "", "");
hfTotalItems.Value = Convert.ToString(iNo + 2);
}
else
{
hfTotalItems.Value = Convert.ToString(iNo);
}
rptVoucherItems.DataSource = dt;
rptVoucherItems.DataBind();
}
protected void Load_Items(bool addMore, bool doReset)
{
int moduleParameterId = 0;
if (!string.IsNullOrEmpty(ddlBranch.SelectedValue))
{
moduleParameterId = Convert.ToInt32(ddlBranch.SelectedValue);
}
if (doReset)
{
rptVoucherItems.DataSourceID = null;
rptVoucherItems.DataBind();
}
if (Request.QueryString["gid"] != null && addMore == false)
{
int groupId = Convert.ToInt32(Request.QueryString["gid"]);
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
objTransG = bTransG.Select(groupId);
if (objTransG != null)
{
rptVoucherItems.DataSource = bTrans.Select_Grp(groupId, true);
rptVoucherItems.DataBind();
}
}
DataTable dt = new DataTable();
dt.Columns.Add("itemCount");
dt.Columns.Add("invItemId");
dt.Columns.Add("invItemAccId");
dt.Columns.Add("invItemDescription");
dt.Columns.Add("invItemCost");
dt.Columns.Add("invItemQty");
dt.Columns.Add("invItemTax1Id");
dt.Columns.Add("invItemTax2Id");
dt.Columns.Add("deptId");
int iNo = 0;
foreach (RepeaterItem item in rptVoucherItems.Items)
{
foreach (Control ctrlItem in item.Controls)
{
if (ctrlItem is HiddenField)
{
if (ctrlItem.ClientID.ToLower().Contains("hfitemcount"))
{
HiddenField hfINo = (HiddenField)ctrlItem;
RadComboBox ddlCreditAccounts = (RadComboBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemCount", "ddlCreditAccount"));
TextBox tbDescription = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemCount", "tbDescription"));
TextBox tbUnitCost = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemCount", "tbUnitCost"));
TextBox tbQuantity = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemCount", "tbQty"));
DropDownList ddlTax1 = (DropDownList)Form.FindControl(hfINo.UniqueID.Replace("hfItemCount", "ddlTax1"));
DropDownList ddlTax2 = (DropDownList)Form.FindControl(hfINo.UniqueID.Replace("hfItemCount", "ddlTax2"));
DropDownList ddlDept = (DropDownList)Form.FindControl(hfINo.UniqueID.Replace("hfItemCount", "ddlDept"));
dt.Rows.Add(iNo + 1, "", ddlCreditAccounts.SelectedValue.ToString(), tbDescription.Text, tbUnitCost.Text, tbQuantity.Text, ddlTax1.SelectedValue, ddlTax2.SelectedValue, ddlDept.SelectedValue);
//dt.Rows.Add(null, itemNo, showOff, transId, drAccountId, crAccountId, deptId, description, Comma_Amount(""));
}
}
}
}
if (addMore || rptVoucherItems.Items.Count == 0)
{
dt.Rows.Add(iNo + 1, "", "", "", "", "", "", "");
dt.Rows.Add(iNo + 1, "", "", "", "", "", "", "");
hfTotalItems.Value = Convert.ToString(iNo + 2);
}
else
{
hfTotalItems.Value = Convert.ToString(iNo);
}
rptVoucherItems.DataSource = dt;
rptVoucherItems.DataBind();
}
public void Do_Transactions_For_Predefined(int transGroupID, int additionalTransID, decimal amount, string description, decimal totalAmount, int moduleId, DateTime financial_Year, DateTime transCreatedOn, int transCreatedBy, int deptId)
{
IDataReader idr = dbComm.SelectCMD(string.Format("select * from fin_AdditionalAutoTrans where autoTransIsSeparateVouchar=0 and additionalTransID={0} and autoTransIsPredefinedItem=0", additionalTransID));
Transactions.Transact bTrans = new Transactions.Transact();
Transactions.Transact.objTransaction objTrans;
if (idr != null)
{
while (idr.Read())
{
objTrans = new Transactions.Transact.objTransaction();
bool autoTransIsOfficial = Convert.ToBoolean(idr["autoTransIsOfficial"]);
string transNarration = idr["autoTransNarration"].ToString();
int accountId = Convert.ToInt32(idr["autoTransAccountId"]);
bool doDebit = Convert.ToBoolean(idr["autoTransIsDebit"]);
decimal transAmountMulti = Convert.ToDecimal(idr["autoTransAmountMultiplier"]);
if (doDebit)
{
objTrans.transDrAccount = accountId;
}
else
{
objTrans.transCrAccount = accountId;
}
if (autoTransIsOfficial)
{
objTrans.transSystemIndex = 2;
objTrans.transSystemRestrict = false;
}
else
{
objTrans.transSystemIndex = 1;
}
objTrans.transNarration = transNarration;
objTrans.transAmount = amount * transAmountMulti;
objTrans.transCreatedBy = transCreatedBy;
objTrans.transCreatedOn = transCreatedOn;
objTrans.transGroupID = transGroupID;
objTrans.transInvoiceID = transGroupID;
objTrans.transIsCompound = true;
objTrans.transParticipantID = 1;
objTrans.transRefID = "1";
objTrans.transStatus = 1;
objTrans.transType = 2;
objTrans.transUpdatedBy = transCreatedBy;
objTrans.transUpdatedOn = DateTime.Now;
objTrans.deptId = deptId;
bTrans.Add(objTrans);
}
}
IDataReader idrGroups = dbComm.SelectCMD(string.Format("select distinct(autoTransSeparateID) from fin_AdditionalAutoTrans where autoTransIsSeparateVouchar=1 and additionalTransID={0} and autoTransIsPredefinedItem=0", additionalTransID));
if (idrGroups != null)
{
while (idrGroups.Read())
{
int autoTransSeparateID = Convert.ToInt32(idrGroups["autoTransSeparateID"]);
bool hasTransactions = false;
decimal totalDrAmount = 0;
decimal totalCrAmount = 0;
int transCount = 0;
idr = dbComm.SelectCMD(string.Format("select * from fin_AdditionalAutoTrans where autoTransIsSeparateVouchar=1 and additionalTransID={0} and autoTransSeparateID={1} and autoTransIsPredefinedItem=0", additionalTransID, autoTransSeparateID));
if (idr != null)
{
while (idr.Read())
{
objTrans = new Transactions.Transact.objTransaction();
bool autoTransIsOfficial = Convert.ToBoolean(idr["autoTransIsOfficial"]);
string transNarration = idr["autoTransNarration"].ToString();
int accountId = Convert.ToInt32(idr["autoTransAccountId"]);
bool doDebit = Convert.ToBoolean(idr["autoTransIsDebit"]);
decimal transAmountMulti = Convert.ToDecimal(idr["autoTransAmountMultiplier"]);
objTrans.transAmount = amount * transAmountMulti;
if (doDebit)
{
objTrans.transDrAccount = accountId;
totalDrAmount += objTrans.transAmount;
}
else
{
objTrans.transCrAccount = accountId;
totalCrAmount += objTrans.transAmount;
}
if (autoTransIsOfficial)
{
objTrans.transSystemIndex = 2;
objTrans.transSystemRestrict = false;
}
else
{
objTrans.transSystemIndex = 1;
}
objTrans.transNarration = transNarration;
objTrans.transCreatedBy = transCreatedBy;
objTrans.transCreatedOn = transCreatedOn;
objTrans.transGroupID = -1;
objTrans.transInvoiceID = transGroupID;
objTrans.transIsCompound = true;
objTrans.transParticipantID = 1;
objTrans.transRefID = transGroupID.ToString();
objTrans.transStatus = 1;
objTrans.transType = 3;
objTrans.transUpdatedBy = transCreatedBy;
objTrans.transUpdatedOn = DateTime.Now;
objTrans.deptId = deptId;
bTrans.Add(objTrans);
hasTransactions = true;
transCount++;
}
if (hasTransactions && totalCrAmount == totalDrAmount)
{
int groupID;
string transGroupPrefixString = "AUT";
int transGroupPrefixNo = 7;
string transGroupTitle = "Auto Transaction";
iBiz.FinPro.Transactions.Groups.objGroup objTransGroup = new iBiz.FinPro.Transactions.Groups.objGroup();
iBiz.FinPro.Transactions.Groups bTransGroup = new iBiz.FinPro.Transactions.Groups();
idr = null;
idr = dbComm.SelectCMD(string.Format("select * from fin_AdditionalAutoTransGroup where atgID={0}", autoTransSeparateID));
while (idr.Read())
{
transGroupPrefixString = idr["transGroupPrefixString"].ToString();
transGroupPrefixNo = Convert.ToInt32(idr["transGroupPrefixNo"]);
transGroupTitle = idr["transGroupTitle"].ToString();
}
objTransGroup.transGroupCreatedBy = transCreatedBy;
objTransGroup.transGroupCreatedOn = transCreatedOn;
objTransGroup.transGroupForeNumber = bTransGroup.New_Group_Fore_Number(moduleId, transGroupPrefixString, objTransGroup.transGroupCreatedOn);
objTransGroup.transGroupPrefixNo = 7;
objTransGroup.transGroupPrefixString = transGroupPrefixString;
objTransGroup.transGroupStatus = 1;
objTransGroup.transGroupTitle = transGroupTitle;
objTransGroup.transGroupTotalAmount = totalCrAmount;
objTransGroup.transTransCount = transCount;
objTransGroup.transLinkedToGroup = 0;
groupID = bTransGroup.Add(objTransGroup).Value;
bTrans.Update_Group(transCreatedBy, -1, groupID);
}
}
}
}
}
protected void Vouchar_Verify()
{
iDB.Communicate dbComm = new iDB.Communicate();
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Transact.objTransaction objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
IDataReader idr = dbComm.SelectCMD("Select transGroupID, Sum(transAmount) as transAmount, max(transNarration) as transNarration, max(transCreatedOn) as transCreatedOn from fin_Transactions where transGroupID in (select transGroupID from fin_TransGroups) group by transGroupID");
string output = "<table>";
if (idr != null)
{
while (idr.Read())
{
int transGroupID = Convert.ToInt32(idr["transGroupID"]);
objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
objTransG = bTransG.Select(transGroupID);
decimal crTotal = 0, drTotal = 0, OCrTotal = 0, ODrTotal = 0;
output += "<tr><td>" + transGroupID.ToString() + "</td>";
if (objTransG != null)
{
if (objTransG.Get_Transactions(true) != null)
{
foreach (var item in objTransG.Get_Transactions(true))
{
if (item.transDrAccount == null)
{
OCrTotal += item.transAmount;
}
else
{
ODrTotal += item.transAmount;
}
}
}
if (ODrTotal == OCrTotal)
{
output += string.Format("<td>Balanced<td>");
}
else
{
output += string.Format("<td>Imbalanced<td>");
}
if (objTransG.Get_Transactions(false) != null)
{
foreach (var item in objTransG.Get_Transactions(false))
{
if (item.transDrAccount == null)
{
crTotal += item.transAmount;
}
else
{
drTotal += item.transAmount;
}
}
}
if (drTotal == crTotal)
{
output += string.Format("<td>Balanced<td>");
}
else
{
output += string.Format("<td>Imbalanced<td>");
}
}
output += "</tr>";
}
}
output += "</table>";
Response.Write(output);
}
protected void Balance_Fabric_For_Sales()
{
iDB.Communicate dbComm = new iDB.Communicate();
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Transact.objTransaction objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
IDataReader idr = dbComm.SelectCMD("Select transGroupID from fin_Transactions where transCrAccount=16 order by transGroupID desc");
if (idr != null)
{
while (idr.Read())
{
int transGroupId = Convert.ToInt32(idr["transGroupId"]);
decimal officialTotal = 0;
decimal unofficialTotal = 0;
IDataReader idrr = dbComm.SelectCMD(string.Format("select IsNull(sum(transAmount), 0) from (select distinct(transAmount) from fin_Transactions where transGroupID={0} and not transCrAccount=16 and transSystemIndex=2) as resultBox", transGroupId));
if (idrr != null)
{
while (idrr.Read())
{
officialTotal = Convert.ToDecimal(idrr[0]);
}
}
idrr = dbComm.SelectCMD(string.Format("select IsNull(sum(transAmount), 0) from (select distinct(transAmount) from fin_Transactions where transGroupID={0} and not transCrAccount=16 and transSystemIndex=1) as resultBox", transGroupId));
if (idrr != null)
{
while (idrr.Read())
{
unofficialTotal = Convert.ToDecimal(idrr[0]);
unofficialTotal += officialTotal;
}
}
idrr = dbComm.SelectCMD(string.Format("select * from fin_Transactions where transGroupID={0} and transCrAccount=16", transGroupId));
if (idrr != null)
{
while (idrr.Read())
{
int transID = Convert.ToInt32(idrr["transID"]);
objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = bTrans.Select(transID);
if (objTrans != null)
{
objTrans.transSystemIndex = 1;
objTrans.transAmount = unofficialTotal;
bTrans.Update(objTrans);
}
objTrans = bTrans.Select(transID);
if (objTrans != null)
{
iBiz.FinPro.Transactions.Transact.objTransaction objTranss = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans.transSystemIndex = 2;
objTrans.transAmount = officialTotal;
objTrans.transSystemRestrict = true;
objTranss.transParticipantID = objTrans.transParticipantID;
objTranss.transCreatedOn = objTrans.transCreatedOn;
bTrans.Add(objTrans);
if (objTranss.transParticipantID.Value == 8)
{
objTranss.transDrAccount = 84;
}
else if (objTranss.transParticipantID.Value == 13)
{
objTranss.transDrAccount = 94;
}
else
{
objTranss.transDrAccount = null;
}
objTranss.transAmount = officialTotal;
objTranss.transCrAccount = null;
objTranss.transCreatedBy = 1;
objTranss.transCreatedOn = DateTime.Now;
objTranss.transGroupID = transGroupId;
objTranss.transNarration = "Inventory Sold";
objTranss.transStatus = 1;
objTranss.transSystemIndex = 2;
objTranss.transSystemRestrict = true;
objTranss.transType = 44;
objTranss.transUpdatedBy = 1;
objTranss.transUpdatedOn = DateTime.Now;
bTrans.Add(objTranss);
}
}
}
objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
objTransG = bTransG.Select(transGroupId);
if (objTransG != null)
{
objTransG.transGroupTotalAmount = unofficialTotal;
objTransG.transGroupOfficialTotalAmount = officialTotal;
bTransG.Update(objTransG);
}
}
}
}
protected void Import_Sales()
{
iDB.Communicate dbComm = new iDB.Communicate();
iBiz.FinPro.Transactions.Groups bTransG = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Transact.objTransaction objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
IDataReader idr = dbComm.SelectCMD("Select transGroupID, Sum(transAmount) as transAmount, max(transNarration) as transNarration, max(transCreatedOn) as transCreatedOn, max(transParticipantID) as transParticipantID from fin_Transactions where (transParticipantID=8 or transParticipantID=13) group by transGroupID");
if (idr != null)
{
while (idr.Read())
{
int transGroupId = Convert.ToInt32(idr["transGroupId"]);
string branch = "";
if (idr["transParticipantID"].ToString().Trim() == "8")
{
branch = "DHA - ";
}
else
{
branch = "Gujrat - ";
}
objTransG.transGroupCreatedBy = 1;
objTransG.transGroupCreatedOn = Convert.ToDateTime(idr["transCreatedOn"]);
objTransG.transGroupForeNumber = bTransG.New_Group_Fore_Number(4, "SAL", DateTime.Now);
objTransG.transGroupID = transGroupId;
objTransG.transGroupPrefixNo = 4;
objTransG.transGroupPrefixString = "SAL";
objTransG.transGroupStatus = 1;
objTransG.transGroupTitle = branch + "Sales Made on " + objTransG.transGroupCreatedOn.ToString("MMM dd, yyyy");
objTransG.transGroupTotalAmount = Convert.ToDecimal(idr["transAmount"]);
objTransG.transTransCount = 0;
bTransG.Add(objTransG);
}
}
idr = null;
idr = dbComm.SelectCMD("SELECT * FROM [fin_Transactions] where (transParticipantID=8 or transParticipantID=13) and Not (transDrAccount is Null or transCrAccount is Null)");
if (idr != null)
{
while (idr.Read())
{
int transId = Convert.ToInt32(idr["transId"]);
iBiz.FinPro.Transactions.Transact.objTransaction objTempTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = bTrans.Select(transId);
objTempTrans = bTrans.Select(transId);
objTrans.transCrAccount = null;
objTrans.transType = 44;
objTempTrans.transDrAccount = null;
objTempTrans.transType = 44;
bTrans.Update(objTrans);
bTrans.Add(objTempTrans);
}
}
idr = null;
idr = dbComm.SelectCMD("SELECT * FROM [fin_Transactions] where (transParticipantID=8 or transParticipantID=13)");
if (idr != null)
{
while (idr.Read())
{
int transId = Convert.ToInt32(idr["transId"]);
iBiz.FinPro.Transactions.Transact.objTransaction objTempTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = bTrans.Select(transId);
objTrans.transType = 44;
bTrans.Update(objTrans);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact();
iBiz.FinPro.Transactions.Transact.objTransaction objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
iBiz.FinPro.Transactions.Transact.objTransaction objDrTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
iBiz.FinPro.Transactions.Transact.objTransaction objCrTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
iBiz.FinPro.Transactions.Groups bTGroup = new iBiz.FinPro.Transactions.Groups();
iBiz.FinPro.Transactions.Groups.objGroup objTGroup = new iBiz.FinPro.Transactions.Groups.objGroup();
iDB.Communicate dbComm = new iDB.Communicate();
IDataReader idr = dbComm.SelectCMD("SELECT * FROM [fin_Transactions] where transDrAccount=294 and transGroupId not in (select transGroupId from fin_TransGroups where transGroupPrefixString='AUT')");
if (idr != null)
{
while (idr.Read())
{
int transId = Convert.ToInt32(idr["transId"]);
objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objTrans = bTrans.Select(transId);
if (objTrans != null)
{
int transGroupId = 0;
objTGroup = new iBiz.FinPro.Transactions.Groups.objGroup();
objTGroup.transGroupTitle = "Credit Card Department Bank UBL DHA";
objTGroup.transGroupCreatedOn = objTrans.Get_Group().transGroupCreatedOn;
objTGroup.transGroupCreatedBy = 1;
objTGroup.transGroupTotalAmount = objTrans.transAmount;
objTGroup.transTransCount = 2;
objTGroup.transGroupPrefixNo = 7;
objTGroup.transGroupPrefixString = "AUT";
objTGroup.transGroupForeNumber = objTrans.transGroupID;
objTGroup.transGroupStatus = 1;
objTGroup.transLinkedToGroup = objTrans.transGroupID;
objTGroup.transGroupIsOfficial = 0;
transGroupId = bTGroup.Add(objTGroup).Value;
objDrTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objDrTrans.deptId = objTrans.deptId;
objDrTrans.transAmount = objTrans.transAmount;
objDrTrans.transAttachedFiles = "";
objDrTrans.transCrAccount = null;
objDrTrans.transCreatedBy = objTrans.transCreatedBy;
objDrTrans.transCreatedOn = objTrans.Get_Group().transGroupCreatedOn;
objDrTrans.transDrAccount = 301;
objDrTrans.transGroupID = transGroupId;
objDrTrans.transInvoiceID = 0;
objDrTrans.transIsCompound = true;
objDrTrans.transNarration = "Credit Card Sales UBL DHA";
objDrTrans.transParticipantID = 1;
objDrTrans.transRefID = "0";
objDrTrans.transStatus = 1;
objDrTrans.transSystemIndex = 2;
objDrTrans.transSystemRestrict = false;
objDrTrans.transType = 3;
objDrTrans.transUpdatedBy = 1;
objDrTrans.transUpdatedOn = objTrans.Get_Group().transGroupCreatedOn;
bTrans.Add(objDrTrans);
objCrTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objCrTrans.deptId = objTrans.deptId;
objCrTrans.transAmount = objTrans.transAmount;
objCrTrans.transAttachedFiles = "";
objCrTrans.transCrAccount = 294;
objCrTrans.transCreatedBy = objTrans.transCreatedBy;
objCrTrans.transCreatedOn = objTrans.Get_Group().transGroupCreatedOn;
objCrTrans.transDrAccount = null;
objCrTrans.transGroupID = transGroupId;
objCrTrans.transInvoiceID = 0;
objCrTrans.transIsCompound = true;
objCrTrans.transNarration = "Credit Card Sales UBL DHA";
objCrTrans.transParticipantID = 1;
objCrTrans.transRefID = "0";
objCrTrans.transStatus = 1;
objCrTrans.transSystemIndex = 2;
objCrTrans.transSystemRestrict = false;
objCrTrans.transType = 3;
objCrTrans.transUpdatedBy = 1;
objCrTrans.transUpdatedOn = objTrans.Get_Group().transGroupCreatedOn;
bTrans.Add(objCrTrans);
}
}
}
idr = dbComm.SelectCMD("SELECT * FROM [fin_Transactions] where transDrAccount=296 and transGroupId not in (select transGroupId from fin_TransGroups where transGroupPrefixString='AUT')");
if (idr != null)
{
while (idr.Read())
{
int transId = Convert.ToInt32(idr["transId"]);
objTrans = bTrans.Select(transId);
if (objTrans != null)
{
int transGroupId = 0;
objTGroup = new iBiz.FinPro.Transactions.Groups.objGroup();
objTGroup.transGroupTitle = "Credit Card Department Bank UBL Gujrat";
objTGroup.transGroupCreatedOn = objTrans.Get_Group().transGroupCreatedOn;
objTGroup.transGroupCreatedBy = 1;
objTGroup.transGroupTotalAmount = objTrans.transAmount;
objTGroup.transTransCount = 2;
objTGroup.transGroupPrefixNo = 7;
objTGroup.transGroupPrefixString = "AUT";
objTGroup.transGroupForeNumber = objTrans.transGroupID;
objTGroup.transGroupStatus = 1;
objTGroup.transLinkedToGroup = objTrans.transGroupID;
objTGroup.transGroupIsOfficial = 0;
transGroupId = bTGroup.Add(objTGroup).Value;
objDrTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objDrTrans.deptId = objTrans.deptId;
objDrTrans.transAmount = objTrans.transAmount;
objDrTrans.transAttachedFiles = "";
objDrTrans.transCrAccount = null;
objDrTrans.transCreatedBy = objTrans.transCreatedBy;
objDrTrans.transCreatedOn = objTrans.Get_Group().transGroupCreatedOn;
objDrTrans.transDrAccount = 303;
objDrTrans.transGroupID = transGroupId;
objDrTrans.transInvoiceID = 0;
objDrTrans.transIsCompound = true;
objDrTrans.transNarration = "Credit Card Sales UBL Gujrat";
objDrTrans.transParticipantID = 1;
objDrTrans.transRefID = "0";
objDrTrans.transStatus = 1;
objDrTrans.transSystemIndex = 2;
objDrTrans.transSystemRestrict = false;
objDrTrans.transType = 3;
objDrTrans.transUpdatedBy = 1;
objDrTrans.transUpdatedOn = objTrans.Get_Group().transGroupCreatedOn;
bTrans.Add(objDrTrans);
objCrTrans = new iBiz.FinPro.Transactions.Transact.objTransaction();
objCrTrans.deptId = objTrans.deptId;
objCrTrans.transAmount = objTrans.transAmount;
objCrTrans.transAttachedFiles = "";
objCrTrans.transCrAccount = 296;
objCrTrans.transCreatedBy = objTrans.transCreatedBy;
objCrTrans.transCreatedOn = objTrans.Get_Group().transGroupCreatedOn;
objCrTrans.transDrAccount = null;
objCrTrans.transGroupID = transGroupId;
objCrTrans.transInvoiceID = 0;
objCrTrans.transIsCompound = true;
objCrTrans.transNarration = "Credit Card Sales UBL DHA";
objCrTrans.transParticipantID = 1;
objCrTrans.transRefID = "0";
objCrTrans.transStatus = 1;
objCrTrans.transSystemIndex = 2;
objCrTrans.transSystemRestrict = false;
objCrTrans.transType = 3;
objCrTrans.transUpdatedBy = 1;
objCrTrans.transUpdatedOn = objTrans.Get_Group().transGroupCreatedOn;
bTrans.Add(objCrTrans);
}
}
}
}
