protected IDataReader Get_Vouchar_Transactions(int voucharId) { IDataReader idr = null; iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact(); idr = bTrans.Select_Grp(voucharId, Convert.ToBoolean(isOfficial)); return(idr); }
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 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 Fix_Inv() { iDB.Communicate dbComm = new iDB.Communicate(); IDataReader idr = dbComm.SelectCMD("select transGroupID, sum(transAmount) as transAmount, max(transCreatedOn) as transCreatedOn from fin_transactions where (transDrAccount=84 or transCRAccount=84) and transAmount>0 and transSystemIndex=2 and Not transGroupID in (select transGroupID from fin_transactions where transDrAccount=84 and transType=44) group by transGroupID"); iBiz.FinPro.Transactions.Transact bTrans = new iBiz.FinPro.Transactions.Transact(); if (idr != null) { while (idr.Read()) { int transGroupID = Convert.ToInt32(idr["transGroupID"]); decimal transTotalAmount = Convert.ToDecimal(idr["transAmount"]); DateTime transCreatedOn = Convert.ToDateTime(idr["transCreatedOn"]); iBiz.FinPro.Transactions.Transact.objTransaction objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction(); objTrans.transSystemIndex = 2; objTrans.transParticipantID = 8; objTrans.transDrAccount = 84; objTrans.transNarration = "Inventory Sold from DHA Shop"; objTrans.transAmount = transTotalAmount; objTrans.transCreatedBy = 1; objTrans.transCreatedOn = transCreatedOn; objTrans.transUpdatedBy = 1; objTrans.transUpdatedOn = DateTime.Now; objTrans.transStatus = 1; objTrans.transSystemRestrict = false; objTrans.transGroupID = transGroupID; objTrans.transIsCompound = true; objTrans.transType = 44; bTrans.Add(objTrans); objTrans = new iBiz.FinPro.Transactions.Transact.objTransaction(); objTrans.transSystemIndex = 2; objTrans.transParticipantID = 8; objTrans.transCrAccount = 16; objTrans.transNarration = "Inventory Sold from DHA Shop"; objTrans.transAmount = transTotalAmount; objTrans.transCreatedBy = 1; objTrans.transCreatedOn = transCreatedOn; objTrans.transUpdatedBy = 1; objTrans.transUpdatedOn = DateTime.Now; objTrans.transStatus = 1; objTrans.transSystemRestrict = false; objTrans.transGroupID = transGroupID; objTrans.transIsCompound = true; objTrans.transType = 44; bTrans.Add(objTrans); } } }
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(); }
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); } } } }