protected void GridView_Invoice_Pmnt_RowUpdating(object sender, GridViewUpdateEventArgs e) { int dataItemIndex = GridView_Invoice_Pmnt.Rows[e.RowIndex].DataItemIndex; DataTable dt = (DataTable)Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID]; String invId = Request.QueryString.GetValues("invId")[0]; String pmntId = ((Label)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("Label_Pmnt_Id")).Text; String tranNo = ((TextBox)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("TextBox_Tran_No_Edit")).Text; float amnt = float.TryParse(((TextBox)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("TextBox_Amnt_Edit")).Text, out amnt)? float.Parse(((TextBox)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("TextBox_Amnt_Edit")).Text):0; float previousAmnt = float.Parse(dt.Rows[dataItemIndex]["Amount"].ToString()); String pmntType = ((DropDownList)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_Pmnt_Type_Edit")).SelectedValue; String clearingStat = ((DropDownList)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("DropDownList_Clearing_Stat_Edit")).SelectedValue; String clearingStatNote = ((TextBox)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("TextBox_Clearing_Stat_Note_Edit")).Text; String pmntDate = ((TextBox)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("TextBox_Pmnt_Date")).Text; Dictionary <String, String> whereCls = new Dictionary <string, string>(); whereCls.Add(BackEndObjects.Payment.PAYMENT_COL_PAYMENT_ID, pmntId); Dictionary <String, String> targetVals = new Dictionary <string, string>(); targetVals.Add(BackEndObjects.Payment.PAYMENT_COL_AMOUNT, amnt.ToString()); targetVals.Add(BackEndObjects.Payment.PAYMENT_COL_CLEARING_STAT, clearingStat); targetVals.Add(BackEndObjects.Payment.PAYMENT_COL_CLEARING_STAT_NOTE, clearingStatNote); targetVals.Add(BackEndObjects.Payment.PAYMENT_COL_PAYMENT_TYPE, pmntType); targetVals.Add(BackEndObjects.Payment.PAYMENT_COL_PMNT_DATE, new DateUtility().getDeConvertedDate(pmntDate)); targetVals.Add(BackEndObjects.Payment.PAYMENT_COL_TRAN_NO, tranNo); BackEndObjects.Payment.updatePaymentDetailsDB(targetVals, whereCls, DBConn.Connections.OPERATION_UPDATE); GridView_Invoice_Pmnt.EditIndex = -1; dt.Rows[dataItemIndex]["Tran_No"] = tranNo; dt.Rows[dataItemIndex]["Pmnt_Type"] = pmntType; dt.Rows[dataItemIndex]["Amount"] = amnt; dt.Rows[dataItemIndex]["Clearing_Stat"] = clearingStat; dt.Rows[dataItemIndex]["Clearing_Stat_Note"] = clearingStatNote; dt.Rows[dataItemIndex]["Pmnt_Date"] = pmntDate; GridView_Invoice_Pmnt.DataSource = dt; GridView_Invoice_Pmnt.DataBind(); Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID] = dt; if (clearingStat.Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_CLEAR)) { Label_Total_Cleared.Text = (float.Parse(Label_Total_Cleared.Text) + (amnt - previousAmnt)).ToString(); } if (clearingStat.Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_PENDING)) { Label_Total_Uncleared.Text = (float.Parse(Label_Total_Uncleared.Text) + (amnt - previousAmnt)).ToString(); } Label_Total_Pmnt_Made.Text = (float.Parse(Label_Total_Pmnt_Made.Text) + (amnt - previousAmnt)).ToString(); //fillPmntGrid(); }
protected void GridView_Invoice_Pmnt_RowDeleting(object sender, GridViewDeleteEventArgs e) { String pmntId = ((Label)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("Label_Pmnt_Id")).Text; String amount = ((Label)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("Label_Amnt")).Text; String clearingStat = ((Label)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("Label_Clearing_Stat")).Text; String tranNo = ((Label)GridView_Invoice_Pmnt.Rows[e.RowIndex].Cells[0].FindControl("Label_Tran_No")).Text; Dictionary <String, String> whereCls = new Dictionary <string, string>(); Dictionary <String, String> targetVals = new Dictionary <string, string>(); whereCls.Add(BackEndObjects.Payment.PAYMENT_COL_PAYMENT_ID, pmntId); BackEndObjects.Payment.updatePaymentDetailsDB(targetVals, whereCls, DBConn.Connections.OPERATION_DELETE); DataTable dt = (DataTable)Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID]; int index = GridView_Invoice_Pmnt.Rows[e.RowIndex].DataItemIndex; dt.Rows[index].Delete(); GridView_Invoice_Pmnt.DataSource = dt; GridView_Invoice_Pmnt.DataBind(); GridView_Invoice_Pmnt.SelectedIndex = -1; if (clearingStat.Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_CLEAR)) { Label_Total_Cleared.Text = (float.Parse(Label_Total_Cleared.Text) - float.Parse(amount)).ToString(); } if (clearingStat.Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_PENDING)) { Label_Total_Uncleared.Text = (float.Parse(Label_Total_Uncleared.Text) - float.Parse(amount)).ToString(); } Label_Total_Pmnt_Made.Text = (float.Parse(Label_Total_Pmnt_Made.Text) - float.Parse(amount)).ToString(); Dictionary <String, String> existingTranDict = (Dictionary <string, string>)Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID_EXISTING_TRAN_NO]; existingTranDict.Remove(tranNo); Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID_EXISTING_TRAN_NO] = existingTranDict; }
/// <summary> /// Returns the existing transaction number list /// </summary> /// <returns></returns> protected Dictionary <String, String> fillPmntGrid() { DataTable dt = new DataTable(); dt.Columns.Add("Pmnt_Id"); dt.Columns.Add("Tran_No"); dt.Columns.Add("Pmnt_Type"); dt.Columns.Add("Amount"); dt.Columns.Add("Clearing_Stat"); dt.Columns.Add("Clearing_Stat_Note"); dt.Columns.Add("Pmnt_Date"); dt.Columns.Add("updatedBy"); String invId = Request.QueryString.GetValues("invId")[0]; Dictionary <String, Payment> pmntDict = BackEndObjects.Payment.getPaymentDetailsforInvoiceDB(invId); Dictionary <String, String> tranDict = new Dictionary <String, String>(); DateUtility dU = new DateUtility(); int counter = 0; float totalPmnt = 0; float totalCleared = 0; float totalUnCleared = 0; foreach (KeyValuePair <String, Payment> kvp in pmntDict) { dt.Rows.Add(); Payment pmntObj = kvp.Value; dt.Rows[counter]["Pmnt_Id"] = pmntObj.getPaymentId(); dt.Rows[counter]["Tran_No"] = pmntObj.getTranNo(); dt.Rows[counter]["Pmnt_Type"] = pmntObj.getPaymentType(); dt.Rows[counter]["Amount"] = pmntObj.getAmount(); dt.Rows[counter]["Clearing_Stat"] = pmntObj.getClearingStat(); dt.Rows[counter]["Clearing_Stat_Note"] = pmntObj.getClearingStatNote(); dt.Rows[counter]["Pmnt_Date"] = dU.getConvertedDate(pmntObj.getPmntDate()); String enttId = pmntObj.getEntityid(); String entName = ""; entName = BackEndObjects.Contacts.getContactDetailsforContactEntityDB(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString(), enttId).getContactName(); if (entName == null || entName.Equals("")) { entName = MainBusinessEntity.getMainBusinessEntitybyIdwithLessDetailsDB(enttId).getEntityName(); } dt.Rows[counter]["updatedBy"] = entName; totalPmnt += pmntObj.getAmount(); totalCleared = pmntObj.getClearingStat().Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_CLEAR) ? totalCleared + pmntObj.getAmount() : totalCleared; totalUnCleared = pmntObj.getClearingStat().Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_PENDING) ? totalUnCleared + pmntObj.getAmount() : totalUnCleared; if (!tranDict.ContainsKey(pmntObj.getTranNo())) { tranDict.Add(pmntObj.getTranNo(), pmntObj.getTranNo()); } counter++; } dt.DefaultView.Sort = "Pmnt_Date" + " " + "DESC"; GridView_Invoice_Pmnt.Visible = true; GridView_Invoice_Pmnt.DataSource = dt.DefaultView.ToTable(); GridView_Invoice_Pmnt.DataBind(); GridView_Invoice_Pmnt.Columns[2].Visible = false; Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID] = dt; Label_Total_Pmnt_Made.Text = totalPmnt.ToString(); Label_Total_Cleared.Text = totalCleared.ToString(); Label_Total_Cleared.ForeColor = System.Drawing.Color.Green; Label_Total_Uncleared.Text = totalUnCleared.ToString(); Label_Total_Uncleared.ForeColor = System.Drawing.Color.Red; return(tranDict); }
protected void GridView_Invoice_Pmnt_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView_Invoice_Pmnt.EditIndex = -1; GridView_Invoice_Pmnt.DataSource = (DataTable)Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID]; GridView_Invoice_Pmnt.DataBind(); }
protected void GridView_Invoice_Pmnt_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView_Invoice_Pmnt.PageIndex = e.NewPageIndex; GridView_Invoice_Pmnt.DataSource = (DataTable)Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID]; GridView_Invoice_Pmnt.DataBind(); }
protected void Button_Create_Pmnt_Click(object sender, EventArgs e) { Dictionary <String, String> existingTranDict = (Dictionary <String, String>)Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID_EXISTING_TRAN_NO]; if (existingTranDict.ContainsKey(TextBox_Tran_No.Text.Trim())) { Label_Pmnt_Create_Stat.Visible = true; Label_Pmnt_Create_Stat.Text = "Transaction Number already exists."; Label_Pmnt_Create_Stat.ForeColor = System.Drawing.Color.Red; } else { BackEndObjects.Payment pmntObj = new BackEndObjects.Payment(); String rfId = Request.QueryString.GetValues("rfId")[0]; String invId = Request.QueryString.GetValues("invId")[0]; pmntObj.setPaymentId(new BackEndObjects.Id().getNewId(BackEndObjects.Id.ID_TYPE_PMNT_ID_STRING)); pmntObj.setClearingStat(DropDownList_Clearing_Stat.SelectedValue); pmntObj.setPmntDate(TextBox_Pmnt_Date.Text); pmntObj.setEntityId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString()); pmntObj.setInvoiceId(invId); pmntObj.setPaymentType(DropDownList_Pmnt_Type.SelectedValue); pmntObj.setRFQId(rfId); pmntObj.setTranNo(TextBox_Tran_No.Text); pmntObj.setUsrId(User.Identity.Name); pmntObj.setAmount(float.Parse(TextBox_Tran_Amnt.Text)); pmntObj.setClearingStatNote(TextBox_Clearing_Stat_Note.Text); try { BackEndObjects.Payment.insertPaymentDetailsDB(pmntObj); Label_Pmnt_Create_Stat.Visible = true; Label_Pmnt_Create_Stat.ForeColor = System.Drawing.Color.Green; Label_Pmnt_Create_Stat.Text = "Payment Details Inserted Successfully"; DataTable dt = (DataTable)Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID]; dt.Rows.Add(); int rowIndex = dt.Rows.Count - 1; dt.Rows[rowIndex]["Pmnt_Id"] = pmntObj.getPaymentId(); dt.Rows[rowIndex]["Tran_No"] = pmntObj.getTranNo(); dt.Rows[rowIndex]["Pmnt_Type"] = pmntObj.getPaymentType(); dt.Rows[rowIndex]["Amount"] = pmntObj.getAmount(); dt.Rows[rowIndex]["Clearing_Stat"] = pmntObj.getClearingStat(); dt.Rows[rowIndex]["Clearing_Stat_Note"] = pmntObj.getClearingStatNote(); dt.Rows[rowIndex]["Pmnt_Date"] = pmntObj.getPmntDate(); GridView_Invoice_Pmnt.DataSource = dt; GridView_Invoice_Pmnt.DataBind(); Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID] = dt; if (pmntObj.getClearingStat().Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_CLEAR)) { Label_Total_Cleared.Text = (float.Parse(Label_Total_Cleared.Text) + pmntObj.getAmount()).ToString(); } if (pmntObj.getClearingStat().Equals(BackEndObjects.Payment.PAYMENT_CLEARING_STAT_PENDING)) { Label_Total_Uncleared.Text = (float.Parse(Label_Total_Uncleared.Text) + pmntObj.getAmount()).ToString(); } Label_Total_Pmnt_Made.Text = (float.Parse(Label_Total_Pmnt_Made.Text) + pmntObj.getAmount()).ToString(); //fillPmntGrid(); existingTranDict.Add(pmntObj.getTranNo(), pmntObj.getTranNo()); Session[SessionFactory.ALL_INVOICE_PAYMENT_GRID_EXISTING_TRAN_NO] = existingTranDict; } catch (Exception ex) { Label_Pmnt_Create_Stat.Visible = true; Label_Pmnt_Create_Stat.ForeColor = System.Drawing.Color.Red; Label_Pmnt_Create_Stat.Text = "Payment Details Creation Failed"; } } }