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