public static void LoadCallLogPage(string search_val, System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, Label lbltotalrecord, int LocationID, DateTime FromDate, DateTime ToDate, String UserID, string SignUp) { int recordCount = 0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlClientProvider sqlClientProvider = new SqlClientProvider(); DataSet ds = sqlClientProvider.GetCallLogPageWise(search_val, pageIndex, PageSize, out recordCount, LocationID, FromDate, ToDate, UserID, SignUp); gv.DataSource = ds; gv.DataBind(); string htmlStatus = ""; foreach (DataRow dr in ds.Tables[1].Rows) { htmlStatus += dr["TourStatusName"].ToString() + " : (<b>"; int count = 0; foreach (DataRow drCount in ds.Tables[2].Rows) { if (drCount["StastusID"].ToString() == dr["TourStatusID"].ToString()) { count = int.Parse(drCount["NoOfRecords"].ToString()); } } htmlStatus += count.ToString() + "</b>) "; } lbltotalrecord.Text = htmlStatus + " Total Record Found : (<b>" + recordCount + "</b>)"; clientsPaggination(rptPager, recordCount, pageIndex, PageSize); }
public static long InsertClient(Client client) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); var id = sqlClientProvider.InsertClient(client); return(id); }
public static List <Client> GetAllClients() { SqlClientProvider sqlClientProvider = new SqlClientProvider(); var allClients = sqlClientProvider.GetAllClients(); return(allClients); }
public static Client GetClientByClientID(int ClientID) { Client client = new Client(); SqlClientProvider sqlClientProvider = new SqlClientProvider(); client = sqlClientProvider.GetClientByClientID(ClientID); return client; }
public static bool HideClient(long clientId) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); var isDelete = sqlClientProvider.HideClient(clientId); return(isDelete); }
public static DataSet GetDropDownListAllClient() { DataSet clients = new DataSet(); SqlClientProvider sqlClientProvider = new SqlClientProvider(); clients = sqlClientProvider.GetDropDownLisAllClient(); return clients; }
public static DataSet GetAllClientsWithRelation() { DataSet clients = new DataSet(); SqlClientProvider sqlClientProvider = new SqlClientProvider(); clients = sqlClientProvider.GetAllClients(); return clients; }
public static bool UpdateClient(Client client) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); var isUpdate = sqlClientProvider.UpdateClient(client); return(isUpdate); }
public static DataSet GetAllClients() { DataSet clients = new DataSet(); SqlClientProvider sqlClientProvider = new SqlClientProvider(); clients = sqlClientProvider.GetAllClients(); return(clients); }
public static Client GetMetroLocationByMetroLocationID(int MetroLocationID) { Client client = new Client(); SqlClientProvider sqlClientProvider = new SqlClientProvider(); client = sqlClientProvider.GetClientByMetroLocationID(MetroLocationID); return(client); }
public static Client GetClientByClientID(int ClientID) { Client client = new Client(); SqlClientProvider sqlClientProvider = new SqlClientProvider(); client = sqlClientProvider.GetClientByClientID(ClientID); return(client); }
public static void LoadClientPaymentHistoryPage(string search_val, 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); SqlClientProvider sqlClientProvider = new SqlClientProvider(); DataSet ds = sqlClientProvider.LoadClientPaymentHistoryPage(search_val, pageIndex, PageSize, out recordCount); gv.DataSource = ds; gv.DataBind(); LoadClientPaymentHistoryPage(rptPager, recordCount, pageIndex, PageSize); }
public static void LoadClientPage(string search_val, System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, Label lbltotalrecord, int LocationID, DateTime FromDate, DateTime ToDate) { int recordCount = 0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlClientProvider sqlClientProvider = new SqlClientProvider(); DataSet ds = sqlClientProvider.GetClientPageWise(search_val, pageIndex, PageSize, out recordCount, LocationID, FromDate, ToDate); gv.DataSource = ds; gv.DataBind(); lbltotalrecord.Text = "Total Record Found : " + recordCount; clientsPaggination(rptPager, recordCount, pageIndex, PageSize); }
public static Client GetClientById(long clientId) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return(sqlClientProvider.GetClientById(clientId)); }
public static string GetClientByMaxApptDate(int ClientID) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return sqlClientProvider.GetClientMaxApptDate(ClientID); }
public static bool DeleteClient(int clientID) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return sqlClientProvider.DeleteClient(clientID); }
public static int InsertClient(Client client) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return sqlClientProvider.InsertClient(client); }
public static Client GetMetroLocationByMetroLocationID(int MetroLocationID) { Client client = new Client(); SqlClientProvider sqlClientProvider = new SqlClientProvider(); client = sqlClientProvider.GetClientByMetroLocationID(MetroLocationID); return client; }
public static string GetClientByMaxApptDate(int ClientID) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return(sqlClientProvider.GetClientMaxApptDate(ClientID)); }
public static void LoadClientPage(string search_val, System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, Label lbltotalrecord, int LocationID, DateTime FromDate, DateTime ToDate) { int recordCount=0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlClientProvider sqlClientProvider = new SqlClientProvider(); DataSet ds = sqlClientProvider.GetClientPageWise(search_val, pageIndex, PageSize, out recordCount, LocationID,FromDate, ToDate); gv.DataSource = ds; gv.DataBind(); lbltotalrecord.Text = "Total Record Found : " + recordCount; clientsPaggination(rptPager,recordCount, pageIndex, PageSize); }
public static bool DeleteClient(long Id) { SqlClientProvider provider = new SqlClientProvider(); return(provider.DeleteClient(Id)); }
public static bool UpdateClient(Client client) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return sqlClientProvider.UpdateClient(client); }
public static bool DeleteClient(int clientID) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return(sqlClientProvider.DeleteClient(clientID)); }
public static int InsertClient(Client client) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return(sqlClientProvider.InsertClient(client)); }
public static bool UpdateClient(OurClient client) { SqlClientProvider provider = new SqlClientProvider(); return(provider.UpdateClient(client)); }
public static Client GetClientByEmail(string email) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return(sqlClientProvider.GetClientByEmail(email)); }
public static OurClient GetClientById(long Id) { SqlClientProvider provider = new SqlClientProvider(); return(provider.GetClientById(Id)); }
public static Client GetClientByMobile(string mobile) { SqlClientProvider sqlClientProvider = new SqlClientProvider(); return(sqlClientProvider.GetClientByMobile(mobile)); }
public static long InsertClient(OurClient client) { SqlClientProvider provider = new SqlClientProvider(); return(provider.InsertClient(client)); }
public static Client GetClientByEmailAndPassword(string email, string password) { SqlClientProvider clientProvider = new SqlClientProvider(); return(clientProvider.GetClientByEmailAndPassword(email, password)); }
public static List <OurClient> GetAllClients() { SqlClientProvider provider = new SqlClientProvider(); return(provider.GetAllClients()); }