protected void Load_Attachments(int groupID) { iBiz.FinPro.Transactions.Attachments bAttachments = new iBiz.FinPro.Transactions.Attachments(); IDataReader idr = bAttachments.Select_For_Vouchar(groupID); rptUploadedFiles.DataSource = idr; rptUploadedFiles.DataBind(); }
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."); } } }