protected void btnSaveChanges_Click(object sender, EventArgs e)
{
try
{
DataSet updateData;
Page.Validate("valSave");
if (!Page.IsValid)
{
//WUIN-1023 Commented below code because validation marks '*' vanishing after colsing this message pop up.
//msgView.SetMessage("Transactions not saved – invalid or missing data!", MessageType.Warning, PositionType.Auto);
return;
}
else
{
Array modifiedRowList = ModifiedRowsList();
Array deletedRowsList = DeletedRowsList();
if (modifiedRowList.Length == 0 && deletedRowsList.Length == 0)
{
msgView.SetMessage("No changes made to save!", MessageType.Warning, PositionType.Auto);
return;
}
transactionMaintenanceBL = new TransactionMaintenanceBL();
updateData = transactionMaintenanceBL.UpdateTransactionDetails(txtSellerSearch.Text.Trim() == string.Empty ? "" : txtSellerSearch.Text.Split('-')[0].Trim(),
txtSalesTypeSearch.Text.Trim() == string.Empty ? "" : txtSalesTypeSearch.Text.Split('-')[0].Trim(), txtReceivedDateSearch.Text.Contains('_') ? "" : txtReceivedDateSearch.Text,
txtReportedDateSearch.Text.Contains('_') ? "" : txtReportedDateSearch.Text, txtCatalogueNumber.Text == string.Empty ? "" : txtCatalogueNumber.Text.ToUpper().Trim(),
ddlCompany.SelectedValue, modifiedRowList, deletedRowsList, Convert.ToString(Session["UserCode"]), out errorId);
transactionMaintenanceBL = null;
if (errorId == 2 || updateData.Tables.Count == 0)
{
ExceptionHandler("Error in saving transactions", string.Empty);
}
else if (errorId == 0 || errorId == 1)
{
LoadGridData(updateData.Tables[0], true);
//any of transactions selected to delete are present in TRANS_PART table and are not deleted
if (errorId == 1)
{
msgView.SetMessage("One or more selected transactions to be deleted have participants and cannot be deleted. Rest are deleted.", MessageType.Warning, PositionType.Auto);
}
else
{
msgView.SetMessage("Transaction updated Successfully.!", MessageType.Warning, PositionType.Auto);
}
}
}
}
catch (Exception ex)
{
ExceptionHandler("Error in saving transactions", ex.Message);
}
}
protected void btnSaveTransactions_Click(object sender, EventArgs e)
{
try
{
Page.Validate("valGrpAddTransactions");
if (!Page.IsValid)
{
mpeAddTransactionDetailsPopup.Show();
}
else
{
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string receivedDate = txtReceivedDateAddTrans.Text.Substring(0, 2) + "/" + mfi.GetMonthName(Convert.ToInt32(txtReceivedDateAddTrans.Text.Substring(3, 2))).Substring(0, 3) + "/" + txtReceivedDateAddTrans.Text.Substring(6, 4);
string reportedDate = txtAddTransReportedDate.Text.Substring(0, 2) + "/" + mfi.GetMonthName(Convert.ToInt32(txtAddTransReportedDate.Text.Substring(3, 2))).Substring(0, 3) + "/" + txtAddTransReportedDate.Text.Substring(6, 4);
transactionMaintenanceBL = new TransactionMaintenanceBL();
transactionMaintenanceBL.AddTransactionDetails(receivedDate,
txtAddTransSalesType.Text.Trim() == string.Empty ? "" : txtAddTransSalesType.Text.Split('-')[0].Trim(), txtAddTransSales1.Text == string.Empty ? "" : txtAddTransSales1.Text,
txtAddTransReceipts.Text == string.Empty ? "" : txtAddTransReceipts.Text, txtAddTransDolExchRate.Text == string.Empty ? "" : txtAddTransDolExchRate.Text,
reportedDate, txtAddTransPrice1.Text == string.Empty ? "" : txtAddTransPrice1.Text,
txtAddTransSales2.Text == string.Empty ? "" : txtAddTransSales2.Text, txtAddTransReceipts2.Text == string.Empty ? "" : txtAddTransReceipts2.Text,
txtAddTransCurrencyCode.Text == string.Empty ? "" : txtAddTransCurrencyCode.Text.ToUpper(), txtAddTransCatNo.Text == string.Empty ? "" : txtAddTransCatNo.Text.ToUpper().Trim(),
txtAddTransPrice2.Text == string.Empty ? "" : txtAddTransPrice2.Text, txtAddTransSales3.Text == string.Empty ? "" : txtAddTransSales3.Text,
txtAddTransReceipts3.Text == string.Empty ? "" : txtAddTransReceipts3.Text, txtAddTransWhtTax.Text == string.Empty ? "" : txtAddTransWhtTax.Text,
txtAddTransTerritory.Text.Trim() == string.Empty ? "" : txtAddTransTerritory.Text.Split('-')[0].Trim(), txtAddTransPrice3.Text == string.Empty ? "" : txtAddTransPrice3.Text,
txtAddTransDestinationCountry.Text == string.Empty ? "" : txtAddTransDestinationCountry.Text,
ddlAddTransCompanyCode.SelectedValue == "-" ? hdnCompanyCode.Value : ddlAddTransCompanyCode.SelectedValue, txtAddTransOwnerShare.Text == string.Empty ? "" : txtAddTransOwnerShare.Text,
txtAddTransTotalShare.Text == string.Empty ? "" : txtAddTransTotalShare.Text, Convert.ToString(Session["UserCode"]), out errorId);
transactionMaintenanceBL = null;
if (errorId == 2)
{
ExceptionHandler("Error in saving transactions", string.Empty);
}
else if (errorId == 0)
{
msgView.SetMessage("Transaction saved successfully.!", MessageType.Warning, PositionType.Auto);
}
}
}
catch (Exception ex)
{
ExceptionHandler("Error in saving transactions", ex.Message);
}
}
private void SearchedData()
{
DataSet searchedData;
Page.Validate("valGrpSearch");
if (!Page.IsValid)
{
return;
}
else
{
transactionMaintenanceBL = new TransactionMaintenanceBL();
searchedData = transactionMaintenanceBL.GetSearchedTransactionsData(txtSellerSearch.Text.Trim() == string.Empty ? "" : txtSellerSearch.Text.Split('-')[0].Trim(), txtSalesTypeSearch.Text.Trim() == string.Empty ? "" : txtSalesTypeSearch.Text.Split('-')[0].Trim(), txtReceivedDateSearch.Text.Contains('_') ? "" : txtReceivedDateSearch.Text, txtReportedDateSearch.Text.Contains('_') ? "" : txtReportedDateSearch.Text, txtCatalogueNumber.Text == string.Empty ? "" : txtCatalogueNumber.Text.Replace("'", "").Trim().ToUpper(), ddlCompany.SelectedValue == "-" ? "" : ddlCompany.SelectedValue, out errorId);
}
transactionMaintenanceBL = null;
if (searchedData.Tables.Count != 0 && errorId != 2)
{
LoadGridData(searchedData.Tables[0], false);
}
}
private void LoadInitialData()
{
try
{
tdTrans.Visible = false;
transactionMaintenanceBL = new TransactionMaintenanceBL();
DataSet fuzzySearchData = transactionMaintenanceBL.GetInitialData(out errorId);
if (fuzzySearchData.Tables.Count != 0)
{
catNoList = fuzzySearchData.Tables[0];
currencyList = fuzzySearchData.Tables[1];
dtCountryCode = fuzzySearchData.Tables[3];
Session["TransMaintCatnoList"] = catNoList;
Session["TransMaintCurrencyList"] = currencyList;
Session["TransMaintCountryList"] = dtCountryCode;
Session["TransactionMaintCompanyCodeList"] = fuzzySearchData.Tables[2];
DataRow[] foundRows = fuzzySearchData.Tables[2].Select("primary = 'Y'");
if (foundRows.Length != 0)
{
DataTable dtPrimary = foundRows.CopyToDataTable();
hdnCompanyCode.Value = dtPrimary.Rows[0]["company_code"].ToString();
}
if (Session["FuzzySearchPriceGroupListTypeC"] == null)
{
DataSet dsList = new FuzzySearchBL().GetFuzzySearchList("GetPriceGroupListTypeC", out errorId);
Session["FuzzySearchPriceGroupListTypeC"] = dsList.Tables[0];
}
ddlAddTransCompanyCode.DataTextField = "company_name";
ddlAddTransCompanyCode.DataValueField = "company_code";
ddlAddTransCompanyCode.DataSource = fuzzySearchData.Tables[2];
ddlAddTransCompanyCode.DataBind();
ddlAddTransCompanyCode.Items.Insert(0, new ListItem("-"));
if (ddlAddTransCompanyCode.Items.FindByValue(hdnCompanyCode.Value) != null)
{
ddlAddTransCompanyCode.Items.FindByValue(hdnCompanyCode.Value).Selected = true;
}
else
{
ddlAddTransCompanyCode.SelectedIndex = 0;
}
ddlCompany.DataTextField = "company_name";
ddlCompany.DataValueField = "company_code";
ddlCompany.DataSource = fuzzySearchData.Tables[2];
ddlCompany.DataBind();
ddlCompany.Items.Insert(0, new ListItem("-"));
if (ddlCompany.Items.FindByValue(hdnCompanyCode.Value) != null)
{
ddlCompany.Items.FindByValue(hdnCompanyCode.Value).Selected = true;
}
else
{
ddlCompany.SelectedIndex = 0;
}
}
gvTransactions.DataSource = dtEmpty;
gvTransactions.DataBind();
}
catch (Exception ex)
{
ExceptionHandler("Error in load initial data.", ex.Message);
}
}
