public ClsQuery QueryReksa()
{
ClsQuery _cq = new ClsQuery();
_cq.Server = "tcp:reksa.database.windows.net,1433";
_cq.Database = "SQL_REKSA";
_cq.UserName = "******";
_cq.Password = "******";
_cq.isErrorExtHandled = true;
ClsQuery.queError.Clear();
return(_cq);
}
public bool ExecCommand(string strCommand, out string ErrMsg)
{
ClsQuery clsQuery = QueryReksa();
ErrMsg = "";
bool result = true;
try
{
result = clsQuery.ExecCommand(strCommand, out ErrMsg);
}
catch (Exception ex)
{
ErrMsg = ex.Message;
result = false;
}
return(result);
}
public bool ExecProc(ClsQuery clsQuery, string strProc, ref List <SqlParameter> dbParam, out SqlCommand cmdOut, out string ErrMsg)
{
ErrMsg = "";
bool result = true;
cmdOut = new System.Data.SqlClient.SqlCommand();
try
{
result = clsQuery.ExecProc(strProc, ref dbParam, out cmdOut, out ErrMsg);
}
catch (Exception ex)
{
ErrMsg = ex.Message;
result = false;
}
return(result);
}
private bool ExecProc(ClsQuery clsQuery, string strProc, ref List <SqlParameter> dbParam, out DataSet dsResult, out SqlCommand cmdOut, out string ErrMsg)
{
dsResult = null;
ErrMsg = "";
bool result = true;
cmdOut = new SqlCommand();
try
{
result = clsQuery.ExecProc(strProc, ref dbParam, out dsResult, out cmdOut, out ErrMsg);
}
catch (Exception ex)
{
ErrMsg = ex.Message;
result = false;
}
return(result);
}
