private void button4_Click(object sender, EventArgs e) { try { if (ValidateChildren(ValidationConstraints.Enabled)) { Modify = false; clsCollection aCol = new clsCollection(); var tmpSelected = lstCollections.SelectedValue; aCol = TextToCollection(Convert.ToInt32(tmpSelected)); aCol.UpdateGICollection(); DeactivateTexts(); eleCol.GetElementsCollection(cboFilter.SelectedIndex); eleCol.FilterElements(txtSearch.Text.Trim().ToUpper()); lstCol.AllCollections(); LinkListCollections(); lstCollections.SelectedValue = tmpSelected; MessageBox.Show("La collection a été mise à jour correctement", "Exclamation", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void mtbDeleteOR_Click(object sender, EventArgs e) { if (mtbDeleteOR.Tag.ToString() == "ViewDelete") { gbORDELETE.Visible = true; mtbDeleteOR.Tag = "DeleteOR"; mtbDeleteOR.Text = "Confirm Delete"; } if (mtbDeleteOR.Tag.ToString() == "DeleteOR") { if (!string.IsNullOrEmpty(tbORNoDelete.Text) && int.Parse(tbORNoDelete.Text) > 0) { try { // transfer Data for Future reference clsCollection collection = new clsCollection(int.Parse(tbORNoDelete.Text)); Dictionary <string, string> collectionData = collection.collectionData; string[][] collectionItems = collection.getCollectionItem(int.Parse(tbORNoDelete.Text)); string collectionItemsSummary = ""; for (int i = 0; i < collectionItems.Count(); i++) { collectionItemsSummary += collectionItems[i][0].ToString() + " : " + collectionItems[i][2].ToString() + " , "; } string collectionDetails = " { " + " OPNumber : " + collectionData["OPNumber"] + "," + " Date_Paid : " + collectionData["Date_Paid"] + "," + " Payor : " + collectionData["Payor"] + "," + " Amount : " + collectionData["OPNumber"] + "," + " PaymentType : " + collectionData["PaymentType"] + "," + " CollectionDetails : { " + " " + collectionItemsSummary + " } }"; string insertQuery = "INSERT INTO collection_deleted(ORNumber,Collection_Details) VALUES(" + int.Parse(tbORNoDelete.Text) + ",'" + collectionDetails + "' )"; if (new clsDB().Con().ExecuteSql(insertQuery)) { string query = "DELETE FROM Collections WHERE ORNumber = " + tbORNoDelete.Text; if (new clsDB().Con().ExecuteSql(query)) { query = "DELETE FROM Collection_Details WHERE ORNumber = " + tbORNoDelete.Text; if (new clsDB().Con().ExecuteSql(query)) { mtbDeleteOR.Text = "Delete OR"; mtbDeleteOR.Tag = "ViewDelete"; gbDetails.Visible = false; MessageBox.Show("Delete Successful"); } } } } catch (Exception ex) { MessageBox.Show("Invalid ORNo - Error Message : " + ex.Message); } } } }
public frmLogin(frmHome.MsgHandler s) { clsCollection col = new clsCollection(); col.summaryOfCollection(3); InitializeComponent(); Selected = s; }
private clsCollection TextToCollection(int SelectedValue) { clsCollection aTem = new clsCollection(); aTem.GICollectionID = SelectedValue; aTem.GICollectionStatus = Convert.ToInt32(cboStatus.SelectedValue); aTem.GICollectionComment = txtComment.Text; return(aTem); }
private bool ItemFind() { QuickSearch quickSearch = null; bool result = false; try { if (!itemIsFindind) { itemIsFindind = true; quickSearch = MyApp.CreateQuickSearch(QuickSearchViews.QSV_Item, MyApp.SystemSettings.StartUpInfo.CacheQuickSearchItem); clsCollection qsParams = new clsCollection(); qsParams.add(MyApp.SystemSettings.QuickSearchDefaults.WarehouseID, "@WarehouseID"); qsParams.add(MyApp.SystemSettings.QuickSearchDefaults.PriceLineID, "@PriceLineID"); qsParams.add(MyApp.SystemSettings.QuickSearchDefaults.LanguageID, "@LanguageID"); qsParams.add(MyApp.SystemSettings.QuickSearchDefaults.DisplayDiscontinued, "@Discontinued"); if (MyApp.SystemSettings.StartUpInfo.UseItemSearchAlterCurrency) { qsParams.add(MyApp.SystemSettings.AlternativeCurrency.SaleExchange, "@ctxBaseCurrency"); } else { qsParams.add(MyApp.SystemSettings.QuickSearchDefaults.EuroConversionRate, "@ctxBaseCurrency"); } quickSearch.Parameters = qsParams; if (quickSearch.SelectValue()) { result = true; var itemId = quickSearch.ValueSelectedString(); //MyApp.ItemGet(itemId); } itemIsFindind = false; } } catch (Exception ex) { itemIsFindind = false; MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } finally { } quickSearch = null; return(result); }
private void CollectionTotext(clsCollection Col) { try { txtStatusSX.Text = clsSilex.CollectionStatus(Col.CollectionID); txtCode.Text = Col.GetCollectionCode(); txtComment.Text = Col.GICollectionComment; txtModifiedD.Text = Convert.ToString(Col.ModifiedDate); txtModifiedU.Text = clsUser.GetUserName(Col.ModifiedByUserID); cboStatus.SelectedIndex = Col.GICollectionStatus < 2 ? Col.GICollectionStatus : -1; txtName.Text = Col.GetCollectionName(); txtDesc.Text = Col.GetCollectionDesc(); txtDivision.Text = Col.GetDivisionCode(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { bool hasPayment = false; if (float.Parse(tbAmount.Text) < float.Parse(lblAmountToPay.Text)) { MessageBox.Show(" Invalid Amount"); } else { string query = "SELECT SA.SeqNo, SA.StudID, SA.SemNo, SA.Particular, SA.Amount, ISNULL(SA.Payment,0), ISNULL(SA.Balance,0),OP.Amount FROM Student_Account as SA JOIN tbl_PayOrder as OP ON SA.StudID = OP.StudID WHERE OP.OPNo = "; int recordCount = new clsDB().Con().countRecord(query + orderOfPaymentNo); string[][] data = new string[recordCount][]; // if it is for Student Account if (recordCount > 0) { new clsDB().Con().SelectData(query + orderOfPaymentNo, data); StudentAccount sa = new StudentAccount(); Dictionary <string, string> studentAccountData = sa.getData(data); int tuitionSeqNo = int.Parse(studentAccountData["tuitionSeqNo"]); float mFee = float.Parse(studentAccountData["mFee"]); int StudID = int.Parse(studentAccountData["StudID"]); int semNo = int.Parse(studentAccountData["SemNo"]); if (StudentAccount.updatePayment(sa.seqNo, tuitionSeqNo, float.Parse(tbAmount.Text), StudID, mFee, semNo)) { hasPayment = true; } else { MessageBox.Show("There was an error!"); } } // if for Misc Fees and other payments else { hasPayment = true; } } // Final Procedure if (hasPayment) { string checkAmount = null, checkDate = null, checkNo = null, bankName = null, PaymentType = null; OPData.TryGetValue("CheckAmount", out checkAmount); OPData.TryGetValue("CheckNo", out checkNo); OPData.TryGetValue("CheckDate", out checkDate); OPData.TryGetValue("BankName", out bankName); OPData.TryGetValue("PaymentType", out PaymentType); clsCollection col = new clsCollection(orderOfPaymentNo, int.Parse(OrderOfPayment.getLastORNo()), dtORDate.Value.ToShortDateString(), float.Parse(tbAmount.Text), OPData["Payor"].Replace("'", "''"), checkNo, bankName, checkDate, float.Parse(checkAmount), int.Parse(PaymentType)); if (OP.updateOP(int.Parse(tbORNo.Text), orderOfPaymentNo)) { if (col.create()) { OP.paidOP(orderOfPaymentNo); col.addCollectionItem(); string[][] particularsAmount = OP.getOrderOfPaymentItem(orderOfPaymentNo); OPData["collectionDate"] = dtORDate.Value.ToShortDateString(); int currOrNumber = int.Parse(OrderOfPayment.getLastORNo()) - 1; OPData["ORNumber"] = "" + currOrNumber; ePrinting print = new ePrinting(OPData, particularsAmount); // temporary fix for OTHER Payment if (OPData["Purpose"] == "Other Fees") { print.isOtherPayment = true; } print.ePrint("OR"); Close(); } } } }
// NOTA: QuickSearch NÃO É SUPORTADO EM .NET public static QuickSearch CreateQuickSearch(EntityTypeEnum entityType) { var systemSettings = APIEngine.SystemSettings; QuickSearchViews qsvQuickSearchID = QuickSearchViews.QSV_None; clsCollection paramValues = null; QuickSearch quickSearch = null; if (quickSearch != null) { if (quickSearch.isFinding) { return(quickSearch); } } switch (entityType) { case EntityTypeEnum.itZone: qsvQuickSearchID = QuickSearchViews.QSV_Zone; break; case EntityTypeEnum.itPayment: qsvQuickSearchID = QuickSearchViews.QSV_Payment; break; case EntityTypeEnum.itTender: qsvQuickSearchID = QuickSearchViews.QSV_TenderNames; break; case EntityTypeEnum.itSalesman: qsvQuickSearchID = QuickSearchViews.QSV_Salesman; break; case EntityTypeEnum.itCustomer: qsvQuickSearchID = QuickSearchViews.QSV_Customer; break; case EntityTypeEnum.itFamily: qsvQuickSearchID = QuickSearchViews.QSV_Family; break; case EntityTypeEnum.itWarehouse: qsvQuickSearchID = QuickSearchViews.QSV_Warehouse; break; case EntityTypeEnum.itItem: qsvQuickSearchID = QuickSearchViews.QSV_Item; paramValues = new clsCollection(); paramValues.add(systemSettings.QuickSearchDefaults.WarehouseID, "@WarehouseID"); paramValues.add(systemSettings.QuickSearchDefaults.PriceLineID, "@PriceLineID"); paramValues.add(systemSettings.QuickSearchDefaults.LanguageID, "@LanguageID"); paramValues.add(systemSettings.QuickSearchDefaults.DisplayDiscontinued, "@Discontinued"); if (systemSettings.StartUpInfo.UseItemSearchAlterCurrency) { paramValues.add(systemSettings.AlternativeCurrency.SaleExchange, "@ctxBaseCurrency"); } else { paramValues.add(systemSettings.QuickSearchDefaults.EuroConversionRate, "@ctxBaseCurrency"); } break; } quickSearch = APIEngine.CreateQuickSearch(qsvQuickSearchID, false); if (paramValues != null) { quickSearch.Parameters = paramValues; } return(quickSearch); }