public static DataSet GetAllAppointmnetByMetroLocationID(int MetroLocationID)
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.GetAllAppointmnetByMetroLocationID(MetroLocationID);
return appointmnets;
}
public static DataSet GetAllAppointmnets()
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.GetAllAppointmnets();
return appointmnets;
}
public static DataSet GetAllAppointmnetByClientID(int ClientID)
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.GetAllAppointmnetByClientID(ClientID);
return appointmnets;
}
public static Appointmnet GetAppointmnetByClientID(int ClientID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByClientID(ClientID);
return appointmnet;
}
public static Appointmnet GetStastusByStastusID(int StastusID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByStastusID(StastusID);
return(appointmnet);
}
public static Appointmnet GetMetroLocationByMetroLocationID(int MetroLocationID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByMetroLocationID(MetroLocationID);
return(appointmnet);
}
public static DataSet SearchAppointMent(string MetroLocationID, string dateFrom, string DateTo)
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.SearchAppointMent(MetroLocationID, dateFrom, DateTo);
return(appointmnets);
}
public static DataSet GetAllAppointmnetByClientID(int ClientID)
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.GetAllAppointmnetByClientID(ClientID);
return(appointmnets);
}
public static DataSet GetAllAppointmnetByMetroLocationID(int MetroLocationID)
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.GetAllAppointmnetByMetroLocationID(MetroLocationID);
return(appointmnets);
}
public static Appointmnet GetAppointmnetByClientID(int ClientID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByClientID(ClientID);
return(appointmnet);
}
public static DataSet GetDropDownListAllAppointmnet()
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.GetDropDownLisAllAppointmnet();
return(appointmnets);
}
public static void LoadAppointmnetPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
DataSet ds = sqlAppointmnetProvider.GetAppointmnetPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
appointmnetsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool DeleteAppointmnet(int appointmnetID)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return(sqlAppointmnetProvider.DeleteAppointmnet(appointmnetID));
}
public static bool UpdateAppointmnetStatus(int id, int status)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return sqlAppointmnetProvider.UpdateAppointmnetStatus(id,status);
}
public static bool UpdateAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return(sqlAppointmnetProvider.UpdateAppointmnet(appointmnet));
}
public static int InsertAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return(sqlAppointmnetProvider.InsertAppointmnet(appointmnet));
}
public static int InsertAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return sqlAppointmnetProvider.InsertAppointmnet(appointmnet);
}
public static Appointmnet GetMetroLocationByMetroLocationID(int MetroLocationID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByMetroLocationID(MetroLocationID);
return appointmnet;
}
public static void LoadAppointmnetPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
DataSet ds = sqlAppointmnetProvider.GetAppointmnetPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
appointmnetsPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static DataSet SearchAppointMent(string MetroLocationID,string dateFrom,string DateTo)
{
DataSet appointmnets = new DataSet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnets = sqlAppointmnetProvider.SearchAppointMent(MetroLocationID, dateFrom, DateTo);
return appointmnets;
}
public static bool UpdateAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return sqlAppointmnetProvider.UpdateAppointmnet(appointmnet);
}
public static bool UpdateAppointmnetStatus(int id, int status)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return(sqlAppointmnetProvider.UpdateAppointmnetStatus(id, status));
}
public static Appointmnet GetStastusByStastusID(int StastusID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByStastusID(StastusID);
return appointmnet;
}
public static bool DeleteAppointmnet(int appointmnetID)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return sqlAppointmnetProvider.DeleteAppointmnet(appointmnetID);
}
