protected void populateRFQList() { String RespEntityId = Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString(); ActionLibrary.SalesActions._dispPotentials dP = new SalesActions._dispPotentials(); ArrayList potList = dP.getAllPotentials(RespEntityId, User.Identity.Name); for (int i = 0; i < potList.Count; i++) { PotentialRecords potRec = (PotentialRecords)potList[i]; if (potRec.getPotStat().Equals(BackEndObjects.RFQShortlisted.POTENTIAL_ACTIVE_STAT_CLOSED_WON)) { ListItem ltRFQ = new ListItem(); ltRFQ.Text = potRec.getRFQName(); ltRFQ.Value = potRec.getRFQId(); BackEndObjects.Invoice invObj = BackEndObjects.Invoice.getInvoicebyRfIdDB(potRec.getRFQId()); if (invObj != null && invObj.getInvoiceId() != null && !invObj.getInvoiceId().Equals("")) { ltRFQ.Attributes.Add("style", "background-color:Green;"); } DropDownList1.Items.Add(ltRFQ); } } }
protected void Button_Create_Inv_Click(object sender, EventArgs e) { BackEndObjects.Invoice invObj = new BackEndObjects.Invoice(); invObj.setInvoiceId(new Id().getNewId(BackEndObjects.Id.ID_TYPE_INV_ID_STRING)); invObj.setRespEntityId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); invObj.setInvComments(TextBox_TnC.Text); invObj.setInvoiceDate(TextBox_Inv_Date.Text); invObj.setDeliveryStatus(BackEndObjects.DeliveryStat.DELIV_STAT_UNDELIVERED); invObj.setInvoiceType(BackEndObjects.InvoiceType.INVOICE_TYPE_TAX_INVOICE); invObj.setPaymentStatus(BackEndObjects.PaymentStat.PAYMENT_STAT_INCOMPLETE); invObj.setPolicyNo(TextBox_Policy_No.Text); invObj.setRFQId(Request.QueryString.GetValues("rfId")[0]); invObj.setShipVia(TextBox_Ship_Via.Text); invObj.setTaxableAmnt(float.Parse(TextBox_Taxable_Amount.Text)); invObj.setTotalAmount(float.Parse(Label_Total_Amount_Value.Text)); //For invoice in auto-created mode, the invoice no and invoice id will be same invObj.setInvoiceNo(invObj.getInvoiceId()); invObj.setCreationMode(BackEndObjects.Invoice.INVOICE_CREATION_MODE_AUTO); ArrayList invTaxComp = new ArrayList(); foreach (GridViewRow gVR in GridView_Inv_Tax_Comp.Rows) { BackEndObjects.InvoiceComponents invCompObj = new BackEndObjects.InvoiceComponents(); invCompObj.setInvoice_Id(invObj.getInvoiceId()); invCompObj.setSection_type(BackEndObjects.InvoiceComponents.INVOICE_SECTION_TYPE_TAX); invCompObj.setSection_type_name(((Label)gVR.Cells[0].FindControl("Label_Name")).Text); invCompObj.setSection_value(((TextBox)gVR.Cells[0].FindControl("TextBox_Value")).Text); invTaxComp.Add(invCompObj); } try { BackEndObjects.Invoice.insertInvoiceDB(invObj); BackEndObjects.InvoiceComponents.insertInvoiceComponentListDB(invTaxComp); Label_INV_Creation_Stat.Visible = true; Label_INV_Creation_Stat.ForeColor = System.Drawing.Color.Green; Label_INV_Creation_Stat.Text = "Invoice Created Successfully"; Label_INV_No.Text = invObj.getInvoiceId(); Button_Create_Inv.Enabled = false; } catch (Exception ex) { Label_INV_Creation_Stat.Visible = true; Label_INV_Creation_Stat.ForeColor = System.Drawing.Color.Red; Label_INV_Creation_Stat.Text = "Invoice Creation Failed"; } }
protected void fillOutoingInvGrid(ArrayList invList) { String[] contactEntId = Request.QueryString.GetValues("contactId"); if (invList == null || invList.Count == 0) { invList = BackEndObjects.Invoice.getAllInvoicesbyRespEntId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); } DataTable dt = new DataTable(); dt.Columns.Add("rfqId"); dt.Columns.Add("InvId"); dt.Columns.Add("InvNo"); dt.Columns.Add("totalAmnt"); dt.Columns.Add("InvDate"); dt.Columns.Add("pmntStat"); dt.Columns.Add("totalPending"); DateUtility dU = new DateUtility(); int counter = 0; for (int i = 0; i < invList.Count; i++) { BackEndObjects.Invoice invObj = (BackEndObjects.Invoice)invList[i]; //Filter out invoices whicha re meant for this contact only BackEndObjects.RFQDetails rfqObj = BackEndObjects.RFQDetails.getRFQDetailsbyIdDB(invObj.getRFQId()); if (rfqObj != null && rfqObj.getEntityId() != null && rfqObj.getEntityId().Equals(contactEntId[0])) { float totalPendingAmnt = 0; float totalClearedAmnt = 0; Dictionary <String, Payment> pmntDict = BackEndObjects.Payment.getPaymentDetailsforInvoiceDB(invObj.getInvoiceId()); foreach (KeyValuePair <String, Payment> kvp in pmntDict) { BackEndObjects.Payment pmntObj = kvp.Value; totalClearedAmnt += pmntObj.getClearingStat().Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_CLEAR) ? pmntObj.getAmount() : 0; } totalPendingAmnt = invObj.getTotalAmount() - totalClearedAmnt; dt.Rows.Add(); dt.Rows[counter]["rfqId"] = invObj.getRFQId(); dt.Rows[counter]["InvId"] = invObj.getInvoiceId(); dt.Rows[counter]["InvNo"] = invObj.getInvoiceNo() != null && !invObj.getInvoiceNo().Equals("") ? invObj.getInvoiceNo() : invObj.getInvoiceId(); dt.Rows[counter]["totalAmnt"] = invObj.getTotalAmount(); dt.Rows[counter]["InvDate"] = dU.getConvertedDate(invObj.getInvoiceDate().Substring(0, invObj.getInvoiceDate().IndexOf(" "))); dt.Rows[counter]["pmntStat"] = invObj.getPaymentStatus(); dt.Rows[counter]["totalPending"] = totalPendingAmnt; counter++; } } GridView_Outgoing_Invoices.Visible = true; GridView_Outgoing_Invoices.DataSource = dt; GridView_Outgoing_Invoices.DataBind(); GridView_Outgoing_Invoices.SelectedIndex = -1; Session[SessionFactory.ALL_CONTACT_ALL_DEAL_OUTGOING_INV_GRID] = dt; Session[SessionFactory.ALL_CONTACT_ALL_DEAL_OUTGOING_INV_ARRAYLIST] = invList; }