public void SetFormData()
{
Biz_Bsc_Interface_Datasource objBSC = new Biz_Bsc_Interface_Datasource(this.ISourceId);
this.ISourceId = objBSC.ISource_Id;
txtSOURCE_NAME.Text = objBSC.ISource_Name;
PageUtility.FindByValueDropDownList(ddlSOURCE_TYPE, objBSC.ISource_Type);
PageUtility.FindByValueDropDownList(ddlPROVIDER, objBSC.ICs_Provider);
txtINITIAL_CATALOG.Text = objBSC.ICs_Initial_Catalog;
txtDATA_SOURCE.Text = objBSC.ICs_Data_Source;
txtUSER_ID.Text = objBSC.ICs_User_Id;
txtPASSWORD.Text = objBSC.ICs_Password;
txtEXTENDED_PROPERTIES.Text = objBSC.ICs_Extended_Properties;
txtDESCRIPTIONS.Text = objBSC.IDescriptions;
txtConnectionResult.Text = "";
if (PageUtility.GetByTextDropDownList(ddlSOURCE_TYPE) == "OLEDB")
{
ddlPROVIDER.Visible = true;
ddlSOURCE_TYPE.Visible = true;
}
else
{
ddlPROVIDER.Visible = false;
ddlSOURCE_TYPE.Visible = true;
}
}
public void SetSourceGrid()
{
Biz_Bsc_Interface_Datasource objBSC = new Biz_Bsc_Interface_Datasource();
DataSet rDs = objBSC.GetAllList();
ugrdSourceData.Clear();
ugrdSourceData.DataSource = rDs;
ugrdSourceData.DataBind();
}
protected void iBtnConnect_Click(object sender, ImageClickEventArgs e)
{
Biz_Bsc_Interface_Datasource objBSC = new Biz_Bsc_Interface_Datasource();
bool isSucc = false;
string sMsg = "";
Object objCon = objBSC.GetConnection(this.ISourceId, out isSucc, out sMsg);
string conStr = "";
if (objCon.GetType() == typeof(SqlConnection))
{
SqlConnection conn = null;
conn = (SqlConnection)objCon;
conStr = conn.ConnectionString;
}
else if (objCon.GetType() == typeof(OracleConnection))
{
OracleConnection conn = null;
conn = (OracleConnection)objCon;
conStr = conn.ConnectionString;
}
else if (objCon.GetType() == typeof(OleDbConnection))
{
OleDbConnection conn = null;
conn = (OleDbConnection)objCon;
conStr = conn.ConnectionString;
}
System.Text.StringBuilder result = new System.Text.StringBuilder();
result.AppendLine("MSG : ");
result.AppendLine(sMsg);
result.AppendLine("");
result.AppendLine("CONNECTION STRING : ");
result.AppendLine(conStr);
txtConnectionResult.ForeColor = (isSucc) ? Color.Blue : Color.Red;
txtConnectionResult.Text = result.ToString();
}
public bool SetTrxFormData()
{
Biz_Bsc_Interface_Datasource objBSC = new Biz_Bsc_Interface_Datasource();
objBSC.ISource_Id = this.ISourceId;
objBSC.ISource_Name = txtSOURCE_NAME.Text;
objBSC.ISource_Type = PageUtility.GetByValueDropDownList(ddlSOURCE_TYPE, "");
objBSC.ICs_Provider = PageUtility.GetByValueDropDownList(ddlPROVIDER, "");
objBSC.ICs_Initial_Catalog = txtINITIAL_CATALOG.Text;
objBSC.ICs_Data_Source = txtDATA_SOURCE.Text;
objBSC.ICs_User_Id = txtUSER_ID.Text;
objBSC.ICs_Password = txtPASSWORD.Text;
objBSC.ICs_Connect_Timeout = "";
objBSC.ICs_Extended_Properties = txtEXTENDED_PROPERTIES.Text;
objBSC.IDescriptions = txtDESCRIPTIONS.Text;
int iRtn = 0;
if (this.IType == "A")
{
iRtn = objBSC.InsertData
(null, null
, objBSC.ISource_Name
, objBSC.ISource_Type
, objBSC.ICs_Initial_Catalog
, objBSC.ICs_Data_Source
, objBSC.ICs_Provider
, objBSC.ICs_User_Id
, objBSC.ICs_Password
, objBSC.ICs_Connect_Timeout
, objBSC.ICs_Extended_Properties
, objBSC.IDescriptions
, "Y"
, gUserInfo.Emp_Ref_ID);
this.ISourceId = objBSC.ISource_Id;
ltrScript.Text = objBSC.Transaction_Message;
return((objBSC.Transaction_Result == "Y") ? true : false);
}
else if (this.IType == "U")
{
iRtn = objBSC.UpdateData
(null, null
, objBSC.ISource_Id
, objBSC.ISource_Name
, objBSC.ISource_Type
, objBSC.ICs_Initial_Catalog
, objBSC.ICs_Data_Source
, objBSC.ICs_Provider
, objBSC.ICs_User_Id
, objBSC.ICs_Password
, objBSC.ICs_Connect_Timeout
, objBSC.ICs_Extended_Properties
, objBSC.IDescriptions
, "Y"
, gUserInfo.Emp_Ref_ID);
ltrScript.Text = objBSC.Transaction_Message;
return((objBSC.Transaction_Result == "Y") ? true : false);
}
else if (this.IType == "D")
{
iRtn = objBSC.DeleteData
(null, null
, objBSC.ISource_Id
, gUserInfo.Emp_Ref_ID);
ltrScript.Text = objBSC.Transaction_Message;
return((objBSC.Transaction_Result == "Y") ? true : false);
}
this.SetButton();
return(false);
}
