public DataTable GetDailyCallPlanner(string companyCode, string userCode, string dcrDate)
{
DataTable dt = new DataTable();
SPData _objSPData = new SPData();
Data _objData = new Data();
try
{
SqlCommand command = new SqlCommand(SP_HD_V4_GetDailyPlanHeader);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
_objSPData.AddParamToSqlCommand(command, "@DCRDate", ParameterDirection.Input, SqlDbType.VarChar, 15, dcrDate);
_objData.OpenConnection(companyCode);
dt = _objData.ExecuteDataTable(command);
return(dt);
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
}
public DataTable GetNonSampleGivenYTD(string companyCode, string userCode, string fromDate, string customerCode)
{
DataTable dt = new DataTable();
SPData _objSPData = new SPData();
Data _objData = new Data();
try
{
SqlCommand command = new SqlCommand(SP_hdGetGiftsGivenYTD);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
_objSPData.AddParamToSqlCommand(command, "@FromDate", ParameterDirection.Input, SqlDbType.VarChar, 15, fromDate);
_objSPData.AddParamToSqlCommand(command, "@CustomerCode", ParameterDirection.Input, SqlDbType.VarChar, 30, customerCode);
_objData.OpenConnection(companyCode);
dt = _objData.ExecuteDataTable(command);
return(dt);
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
}
public DataTable GetCompetitorBrandProducts(string companyCode, string userCode, string year, string month, string customerCode)
{
DataTable dt = new DataTable();
SPData _objSPData = new SPData();
Data _objData = new Data();
try
{
SqlCommand command = new SqlCommand(SP_hdGetCompetitorBrandProducts);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
_objSPData.AddParamToSqlCommand(command, "@Year", ParameterDirection.Input, SqlDbType.VarChar, 5, year);
_objSPData.AddParamToSqlCommand(command, "@Month", ParameterDirection.Input, SqlDbType.VarChar, 5, month);
_objSPData.AddParamToSqlCommand(command, "@CustomerCode", ParameterDirection.Input, SqlDbType.VarChar, 30, customerCode);
_objData.OpenConnection(companyCode);
dt = _objData.ExecuteDataTable(command);
return(dt);
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
}
public DataTable GetDoctorProductMappingDetail(string companyCode, string customerCode, string regionCode)
{
DataTable dt = new DataTable();
SPData _objSPData = new SPData();
Data _objData = new Data();
try
{
SqlCommand command = new SqlCommand(SP_hdGetDoctorProductMappimgDetail);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@CustomerCode", ParameterDirection.Input, SqlDbType.VarChar, 30, customerCode);
_objSPData.AddParamToSqlCommand(command, "@RegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, regionCode);
_objData.OpenConnection(companyCode);
dt = _objData.ExecuteDataTable(command);
return(dt);
}
catch
{
throw;
}
finally
{
_objData.CloseConnection();
}
}
