public DataTable GetRow(Hashtable parameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
dbw.ConnectionString = Shared.ConnectionString;
if (!dbw.ExecuteSP("SP_MST_TUNJANGAN_JABATAN_GETROW", parameters, ds))
{
throw new Exception("Fail to execute SP_MST_TUNJANGAN_JABATAN_GETROW", new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to SP_MST_TUNJANGAN_JABATAN_GETROW. No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
public DataTable GetRows(Hashtable parameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
dbw.ConnectionString = Shared.ConnectionString;
if (!dbw.ExecuteSP("sp_ls_tblemployee_getrows", parameters, ds))
{
throw new Exception("Fail to execute sp_ls_tblemployee_getrows", new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to sp_ls_tblemployee_getrows. No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
public DataTable RentalAdjustmentLetterGetRow(Hashtable parameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
dbw.ConnectionString = Shared.ConnectionString;
if (!dbw.ExecuteSP("sp_rpt_ls_amortschedule2doc_getrow", parameters, ds))
{
throw new Exception("Fail to execute sp_rpt_ls_amortschedule2doc_getrow", new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to sp_rpt_ls_amortschedule2doc_getrow. No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
public DataTable LsApplicationOfferingLetterGetRow(Hashtable parameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
dbw.ConnectionString = Shared.ConnectionString;
if (!dbw.ExecuteSP("sp_surat_getrowbyid", parameters, ds))
{
throw new Exception("Fail to execute sp_surat_getrowbyid", new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to sp_surat_getrowbyid. No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
public DataRow GetRow(string TableName, string SPName, Hashtable parameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
dbw.ConnectionString = Shared.ConnectionString;
if (!dbw.ExecuteSP(SPName, parameters, ds))
{
throw new Exception("Fail to execute " + SPName, new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to " + SPName + ". No row found.");
}
else
{
return(ds.Tables[0].Rows[0]);
}
}
}
public DataTable GetRow(Hashtable parameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
dbw.ConnectionString = Shared.ConnectionString;
if (!dbw.ExecuteSP("sp_reff_jenis_usaha_getrow", parameters, ds))
{
throw new Exception("Fail to execute sp_reff_jenis_usaha_getrow", new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to sp_hr_jenjang_pendidikan_getrow. No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
//public object Insert(string sTableName, Hashtable htParameters)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// string sp = SPNamePrefix + sTableName + SPInsertSuffix;
// if (!dbw.ExecuteSP(sp, htParameters))
// {
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// }
// return true;
//}
//public object Insert(string sTableName, Hashtable htParameters, ref string oReturnValue)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// string sp = SPNamePrefix + sTableName + SPInsertSuffix;
// if (!dbw.ExecuteSP(sp, htParameters, ref oReturnValue))
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// return true;
//}
//public object Insert(string sTableName, Hashtable htParameters, ref int oReturnValue)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// string sp = SPNamePrefix + sTableName + SPInsertSuffix;
// if (!dbw.ExecuteSP(sp, htParameters, ref oReturnValue))
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// return true;
//}
//public object Update(string sTableName, Hashtable htParameters)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// string sp = SPNamePrefix + sTableName + SPUpdateSuffix;
// if (!dbw.ExecuteSP(sp, htParameters))
// {
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// }
// return true;
//}
//public object Update(string sTableName, string sSPName, Hashtable htParameters)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// string sp = SPNamePrefix + sSPName;
// if (!dbw.ExecuteSP(sp, htParameters))
// {
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// }
// return true;
//}
//public object Delete(string sTableName, Hashtable htParameters)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// string sp = SPNamePrefix + sTableName + SPDeleteSuffix;
// if (!dbw.ExecuteSP(sp, htParameters))
// {
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// }
// return true;
//}
//public DataRow GetRow(string sTableName, Hashtable htParameters)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// DataSet ds = new DataSet();
// string sp = SPNamePrefix + sTableName + SPGetRowSuffix;
// if (!dbw.ExecuteSP(sp, htParameters, ds))
// {
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// }
// else
// {
// if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
// throw new Exception("Fail to execute " + sp + ". No row found.");
// else
// return ds.Tables[0].Rows[0];
// }
//}
//public DataRow GetRow(string sTableName, string sSPName, Hashtable htParameters)
//{
// DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
// DataSet ds = new DataSet();
// string sp = SPNamePrefix + sSPName;
// if (!dbw.ExecuteSP(sp, htParameters, ds))
// {
// throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
// }
// else
// {
// if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
// throw new Exception("Fail to execute " + sp + ". No row found.");
// else
// return ds.Tables[0].Rows[0];
// }
//}
public DataTable GetRows(string sTableName, Hashtable htParameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
//string sp = SPNamePrefix + sTableName + SPGetRowsSuffix;
string sp = sTableName;
if (!dbw.ExecuteSP(sp, htParameters, ds))
{
throw new Exception("Fail to execute " + sp, new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to execute " + sp + ". No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
public DataTable ExecuteExcelReport(string spReportName, string spResultName, Hashtable parameters)
{
DBWrapper dbw = DBWrapper.GetSqlClientWrapper();
DataSet ds = new DataSet();
dbw.ConnectionString = Shared.ConnectionString;
if (spReportName != null && spResultName != null)
{
if (dbw.ExecuteSP(spReportName, parameters))
{
if (!dbw.ExecuteSP(spResultName, parameters, ds))
{
throw new Exception(spResultName, new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to " + spResultName + ". No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
else
{
throw new Exception(spReportName);
}
}
else if (spReportName == null)
{
if (!dbw.ExecuteSP(spResultName, parameters, ds))
{
throw new Exception(spResultName, new Exception(dbw.DBErrorMessage));
}
else
{
if (ds.Tables.Count <= 0)
{
throw new Exception("Fail to " + spResultName + ". No row found.");
}
else
{
return(ds.Tables[0]);
}
}
}
else if (spResultName == null)
{
if (!dbw.ExecuteSP(spReportName, parameters))
{
throw new Exception(spReportName, new Exception(dbw.DBErrorMessage));
}
else
{
return(null);
}
}
else
{
return(null);
}
}