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); }