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);
}
