public DataTable GetCutomerDetails(frmCalllistModel model)
{
try
{
DbCommand dbcommand = database.GetStoredPocCommand("SP_GetCutomerDetails");
database.AddInParameter(dbcommand, "@SearchText", DbType.String, model.CustmoerName);
dt = database.ExecuteDataTable(dbcommand);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataTable GetcallList(frmCalllistModel model)
{
try
{
DbCommand dbcommand = database.GetStoredPocCommand("SP_GetCallDetails");
database.AddInParameter(dbcommand, "@FromDate", DbType.String, model.fromDate);
database.AddInParameter(dbcommand, "@ToDate", DbType.String, model.ToDate);
dt = database.ExecuteDataTable(dbcommand);
return(dt);
}
catch (Exception)
{
throw;
}
}