public DataTable LoadManualSMSReport(DateTime st_date, DateTime end_date)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadManualSMSReport",
new object[] { st_date, end_date });
return(dt);
}
internal DataTable LoadGroupAllCreate(string group_id)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadGroupAllCreateByID",
new object[] { group_id });
return(dt);
}
public DataTable LoadDisplayGroup(string st)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadDisplayGroup",
new object[] { st });
return(dt);
}
public DataTable LoadSMSReport(DateTime st_date, DateTime end_date, int p, string groupid)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadSMSReport",
new object[] { st_date, end_date, p, groupid });
return(dt);
}
public DataTable LoadMobileInPTTB(string PTTB_str)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadMobileInPTTB",
new object[] { PTTB_str });
return(dt);
}
public DataTable LoadAllGCUnit()
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadALLGCUnit",
new object[] { });
return(dt);
}
public DataTable LoadPTTBGroup(string code, string unitcode)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadPTTBGroup2",
new object[] { code, unitcode });
return(dt);
}
public DataTable LoadToAddTCSPPL(string sch)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadToAddTCSPPL",
new object[] { sch });
return(dt);
}
public DataTable LoadGCGroup(string EmployeeID, string company_id)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadGCGroup",
new object[] { EmployeeID, company_id });
return(dt);
}
public DataTable findAdmin(string _filterAttribute)
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_findAdmin",
new object[] { _filterAttribute });
return(dt);
}
public DataTable LoadMonthlyReport()
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadMonthlyReport",
new object[] { });
return(dt);
}
public DataTable LoadPTTBPPL(string group_id)
{
string group = group_id.Substring(0, 1);
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("SMS_LoadPTTBPPL",
new object[] { group_id });
return(dt);
}
public DataTable LoadAllTempAIS()
{
DataTable dt = null;
OracleQuery2 ora = new OracleQuery2();
dt = ora.ExecuteProcedureToDataTable("smstemplateall",
new object[] { });
DataTable dtt = new DataTable();
DataColumn colString = new DataColumn("StringCol");
colString.DataType = System.Type.GetType("System.String");
dtt.Columns.Add(colString);
DataColumn colString2 = new DataColumn("StringCol2");
colString2.DataType = System.Type.GetType("System.String");
dtt.Columns.Add(colString2);
dtt.Rows.Add("081".ToString(), "081".ToString());
return(dt);
}
