private void BindGLAccountTypeDropDown()
{
try
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_GoodsReceivedNoteDistribution";
optionSetListUI.OptionSetName = "opt_GLAccountType";
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlopt_GLAccountType.DataSource = dtb;
ddlopt_GLAccountType.DataBind();
ddlopt_GLAccountType.DataTextField = "OptionSetLable";
ddlopt_GLAccountType.DataValueField = "OptionSetValue";
ddlopt_GLAccountType.DataBind();
}
else
{
ddlopt_GLAccountType.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "-1"));
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "BindGLAccountTypeDropDown()";
logExcpUIobj.ResourceName = "Procurement_Receive_Goods_or_Services_Receive_Goods_or_Services_GoodsReceivedNoteDistributionForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Procurement_Receive_Goods_or_Services_Receive_Goods_or_Services_GoodsReceivedNoteDistributionForm : BindGLAccountTypeDropDown] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
private void BindGLAccountTypeDropDownList()
{
try
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_NonPOBasedInvoiceDistribution";
optionSetListUI.OptionSetName = "opt_GLAccountType";
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlOpt_GLAccountType.DataSource = dtb;
ddlOpt_GLAccountType.DataBind();
ddlOpt_GLAccountType.DataTextField = "OptionSetLable";
ddlOpt_GLAccountType.DataValueField = "OptionSetValue";
ddlOpt_GLAccountType.DataBind();
}
else
{
ddlOpt_GLAccountType.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "00000000-0000-0000-0000-000000000001"));
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "BindDocumentTypeDropDownList()";
logExcpUIobj.ResourceName = "Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceDistributionForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Finance_Accounts_Payable_Non_PO_Based_Invoice_NonPOBasedInvoiceDistributionForm : BindGLAccountTypeDropDownList] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
private void Bindopt_StatusDropDownList()
{
try
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_Asset";
optionSetListUI.OptionSetName = "Opt_Status";
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlopt_Status.DataSource = dtb;
ddlopt_Status.DataBind();
ddlopt_Status.DataTextField = "OptionSetLable";
ddlopt_Status.DataValueField = "OptionSetValue";
ddlopt_Status.DataBind();
}
else
{
ddlopt_Status.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "00000000-0000-0000-0000-000000000001"));
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "Bindopt_StatusDropDownList()";
logExcpUIobj.ResourceName = "Assets_Asset_AssetForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Assets_Asset_AssetForm : Bindopt_StatusDropDownList] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
private void BindStatuDropDown()
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_Customer";
optionSetListUI.OptionSetName = "Opt_Status";
try
{
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlStatus.DataSource = dtb;
ddlStatus.DataBind();
ddlStatus.DataTextField = "OptionSetLable";
ddlStatus.DataValueField = "OptionSetValue";
ddlStatus.DataBind();
}
else
{
ddlStatus.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "00000000-0000-0000-0000-000000000001"));
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "BindStatuDropDown()";
logExcpUIobj.ResourceName = "Finance_Accounts_Payable_Customer_Supplier_Master_Creation_CustomerForm.CS";
logExcpUIobj.RecordId = "OptionSet Name " + optionSetListUI.OptionSetName;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Finance_Accounts_Payable_Customer_Supplier_Master_Creation_CustomerForm : BindStatuDropDown] An error occured in the processing of Record OptionSet Name " + optionSetListUI.OptionSetName + ". Details : [" + exp.ToString() + "]");
}
}
private void BindYearDropDownList()
{
try
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_FiscalPeriod";
optionSetListUI.OptionSetName = "Opt_Year";
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlOpt_Year.DataSource = dtb;
ddlOpt_Year.DataBind();
ddlOpt_Year.DataTextField = "OptionSetLable";
ddlOpt_Year.DataValueField = "OptionSetValue";
ddlOpt_Year.DataBind();
}
else
{
ddlOpt_Year.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "00000000-0000-0000-0000-000000000001"));
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "BindOriginDropDownList()";
logExcpUIobj.ResourceName = "Reporting_Balance_Sheet_Supplier_Masters_FiscalPeriodForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Reporting_Balance_Sheet_Supplier_Masters_FiscalPeriodForm : BindYearDropDownList] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
public int DeleteOptionSet(OptionSetListUI optionSetListUI)
{
int result = 0;
result = optionSetListDAL.DeleteOptionSet(optionSetListUI);
return(result);
}
public DataTable GetColumnByTablesList(OptionSetListUI optionSetListUI)
{
DataTable dtb = new DataTable();
dtb = optionSetListDAL.GetColumnByTablesList(optionSetListUI);
return(dtb);
}
public DataTable GetOptionSetListBySearchParameters(OptionSetListUI optionSetListUI)
{
DataTable dtb = new DataTable();
dtb = optionSetListDAL.GetOptionSetListBySearchParameters(optionSetListUI);
return(dtb);
}
public DataTable GetOptionSetListByOptionSetName(OptionSetListUI optionSetListUI)
{
DataTable dtb = new DataTable();
dtb = optionSetListDAL.GetOptionSetListByOptionSetName(optionSetListUI);
return(dtb);
}
private void BindColumnByTablesDropDown(OptionSetListUI optionSetListUI)
{
try
{
DataTable dtb = optionSetListBAL.GetColumnByTablesList(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlColoumnByTable.DataSource = dtb;
ddlColoumnByTable.DataTextField = "ColumnName";
ddlColoumnByTable.DataValueField = "column_id";
ddlColoumnByTable.DataBind();
ddlColoumnByTable.Items.Insert(0, new ListItem(Resources.GlobalResource.msgSelectRecord, "0"));
}
else
{
ddlColoumnByTable.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "00000000-0000-0000-0000-000000000001"));
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "BindOrganizationTypeDropDown()";
logExcpUIobj.ResourceName = "System_Settings_OptionSetForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[System_Settings_OptionSetForm : BindColumnByTablesDropDown] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
private void BindListBySearchParameters(OptionSetListUI optionSetListUI)
{
try
{
DataTable dtb = optionSetListBAL.GetOptionSetListBySearchParameters(this.optionSetListUI);
if (dtb.Rows.Count > 0 && dtb != null)
{
gvData.DataSource = dtb;
gvData.DataBind();
divError.Visible = false;
gvData.Visible = true;
}
else
{
divError.Visible = true;
lblError.Text = Resources.GlobalResource.msgNoRecordFound;
gvData.Visible = false;
}
txtSearch.Text = "";
txtSearch.Focus();
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "BindListBySearchParameters()";
logExcpUIobj.ResourceName = "System_Settings_OptionSetList.CS";
logExcpUIobj.RecordId = "All";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[System_Settings_OptionSetList : BindListBySearchParameters] An error occured in the processing of Record. Details : [" + exp.ToString() + "]");
}
}
private void BindTypeDropDownList()
{
try
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_DownPaymentFromCustomerApply";
optionSetListUI.OptionSetName = "opt_Type";
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlOptionType.DataSource = dtb;
ddlOptionType.DataBind();
ddlOptionType.DataTextField = "OptionSetLable";
ddlOptionType.DataValueField = "OptionSetValue";
ddlOptionType.DataBind();
ddlOptionType.Items.Insert(0, new ListItem(Resources.GlobalResource.OptionType_msgSelectPayablesType, "0"));
ddlOptionType.SelectedIndex = 0;
}
else
{
ddlOptionType.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "00000000-0000-0000-0000-000000000001"));
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "BindDocumentTypeDropDownList()";
logExcpUIobj.ResourceName = "Finance_Bank_Accounting_Payment_To_Suppliers_DownPaymentToSupplierDistributionForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Finance_Bank_Accounting_Payment_To_Suppliers_DownPaymentToSupplierDistributionForm : BindDocumentTypeDropDownList] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
public DataTable GetOptionSetListByOptionSetName(OptionSetListUI optionSetListUI)
{
DataSet ds = new DataSet();
DataTable dtbl = new DataTable();
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SqlCommand sqlCmd = new SqlCommand("SP_OptionSet_SelectOptionSet", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@TableName", SqlDbType.NVarChar);
sqlCmd.Parameters["@TableName"].Value = optionSetListUI.TableName;
sqlCmd.Parameters.Add("@OptionSetName", SqlDbType.NVarChar);
sqlCmd.Parameters["@OptionSetName"].Value = optionSetListUI.OptionSetName;
using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd))
{
adapter.Fill(ds);
}
}
if (ds.Tables.Count > 0)
{
dtbl = ds.Tables[0];
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "GetOptionSetListByOptionSetName()";
logExcpUIobj.ResourceName = "OptionSetListDAL.CS";
logExcpUIobj.RecordId = optionSetListUI.OptionSetName;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[OptionSetListDAL : GetOptionSetListByOptionSetName] An error occured in the processing of Record Id : " + optionSetListUI.OptionSetName + ". Details : [" + exp.ToString() + "]");
}
finally
{
ds.Dispose();
}
return(dtbl);
}
protected void ddlTables_SelectedIndexChanged(object sender, EventArgs e)
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
if (ddlTables.SelectedValue == "0" || ddlTables.SelectedIndex == 0)
{
ddlColoumnByTable.SelectedIndex = 0;
txtTableName.Text = "";
txtOptionSetName.Text = "";
txtOptionSetLable.Text = "";
txtOptionSetValue.Text = "";
}
else
{
optionSetListUI.TableObjectId = ddlTables.SelectedValue;
txtTableName.Text = ddlTables.SelectedItem.Text;
BindColumnByTablesDropDown(optionSetListUI);
}
}
private void BindOptionAccountTypeDropDown()
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_SupplierAndGroupAccount";
optionSetListUI.OptionSetName = "Opt_AccountType";
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlOpt_AccountType.DataSource = dtb;
ddlOpt_AccountType.DataBind();
ddlOpt_AccountType.DataTextField = "OptionSetLable";
ddlOpt_AccountType.DataValueField = "OptionSetValue";
ddlOpt_AccountType.DataBind();
}
else
{
ddlOpt_AccountType.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "-1"));
}
}
private void BindOptionBudgetYearDropDown()
{
OptionSetListUI optionSetListUI = new OptionSetListUI();
optionSetListUI.TableName = "tbl_Budget";
optionSetListUI.OptionSetName = "Opt_BudgetYear";
DataTable dtb = optionSetListBAL.GetOptionSetListByOptionSetName(optionSetListUI);
if (dtb.Rows.Count > 0)
{
ddlBudgetYear.DataSource = dtb;
ddlBudgetYear.DataBind();
ddlBudgetYear.DataTextField = "OptionSetLable";
ddlBudgetYear.DataValueField = "OptionSetValue";
ddlBudgetYear.DataBind();
}
else
{
ddlBasedOn.Items.Insert(0, new ListItem(Resources.GlobalResource.msgNoRecordFound, "-1"));
}
}
public int DeleteOptionSet(OptionSetListUI optionSetListUI)
{
int result = 0;
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SupportCon.Open();
SqlCommand sqlCmd = new SqlCommand("SP_OptionSet_Delete", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@tbl_OptionSetId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_OptionSetId"].Value = optionSetListUI.Tbl_OptionSetId;
result = sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
SupportCon.Close();
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "DeleteOptionSet()";
logExcpUIobj.ResourceName = "OptionSetListDAL.CS";
logExcpUIobj.RecordId = optionSetListUI.Tbl_OptionSetId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[OptionSetListDAL : DeleteOptionSet] An error occured in the processing of Record Id : " + optionSetListUI.Tbl_OptionSetId + ". Details : [" + exp.ToString() + "]");
}
return(result);
}