public static int DbGetInvoiceNumber(string query)
{
try
{
using (MySqlConnection objDbConnection = new MySqlConnection(dbConnection))
{
using (MySqlCommand DBcommand = new MySqlCommand(query, objDbConnection))
{
MySqlDataReader DBreader;
objDbConnection.Open();
DBreader = DBcommand.ExecuteReader();
if (DBreader.HasRows)
{
DBreader.Read();
return(int.Parse(DBreader["invoiceno"].ToString()) + 1);
}
else
{
return(1001);
}
}
}
}
catch (Exception ex)
{
throw new NotImplementedException(ex.Message);
}
}
public static List <Dictionary <string, object> > DbCustomerSearch(string query)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("value", typeof(string));
dt.Columns.Add("label", typeof(string));
dt.Columns.Add("cid", typeof(string));
using (MySqlConnection objDbConnection = new MySqlConnection(dbConnection))
{
using (MySqlCommand DBcommand = new MySqlCommand(query, objDbConnection))
{
MySqlDataReader DBreader;
objDbConnection.Open();
DBreader = DBcommand.ExecuteReader();
while (DBreader.Read())
{
string u = DBreader["cid"].ToString();
string v = DBreader["fname"].ToString() + " - " + u;
dt.Rows.Add(v, v, u);
}
return(DictionaryData(dt));
}
}
}
catch (Exception ex)
{
throw new NotImplementedException(ex.Message);
}
}
public static List <Customer> DbSingleCustomer(string query)
{
try
{
List <Customer> listcustomer = new List <Customer>();
using (MySqlConnection objDbConnection = new MySqlConnection(dbConnection))
{
using (MySqlCommand DBcommand = new MySqlCommand(query, objDbConnection))
{
MySqlDataReader DBreader;
objDbConnection.Open();
DBreader = DBcommand.ExecuteReader();
while (DBreader.Read())
{
Customer cus = new Customer();
cus.amount = float.Parse(DBreader["amount"].ToString());
cus.paid = float.Parse(DBreader["paid"].ToString());
cus.balance = float.Parse(DBreader["balance"].ToString());
listcustomer.Add(cus);
}
return(listcustomer);
}
}
}
catch (Exception ex)
{
throw new NotImplementedException(ex.Message);
}
}
public static string DbChangePassword(string query)
{
try
{
using (MySqlConnection objDbConnection = new MySqlConnection(dbConnection))
{
using (MySqlCommand DBcommand = new MySqlCommand(query, objDbConnection))
{
MySqlDataReader DBreader;
objDbConnection.Open();
DBreader = DBcommand.ExecuteReader();
if (DBreader.Read())
{
return(DBreader["password"].ToString());
}
else
{
return("nil");
}
}
}
}
catch (Exception ex)
{
throw new NotImplementedException(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var db = new DBreader();
var htmlQueryable = db.GetAllHTMLbySearchSession(3);
var htmlList = htmlQueryable.ToList();
}
public IQueryable <tblSearchSession> GetHTMLdata()
{
var dbReader = new DBreader();
var sessionList = dbReader.GetAllHTMLbySearchSession(3);
return(sessionList);
}
public List <tblVehicle> ChooseTypeOfSearch(List <tblVehicle> vehicleSearchList)
{
// create instance of dbreader class to read vehicles to search.
if (!AppSettings.manualSingleSearchMode)
{
// Multiple search
var dbReader = new DBreader();
vehicleSearchList = dbReader.readSearchVehicles();
}
else
{
//Single Search
var dbReader = new DBreader();
vehicleSearchList = dbReader.GetSingleSearchVehicle(AppSettings.singleSearchVehicleModel);
}
return(vehicleSearchList);
}
public static string DbLogin(string query)
{
try
{
using (MySqlConnection objDbConnection = new MySqlConnection(dbConnection))
{
using (MySqlCommand DBcommand = new MySqlCommand(query, objDbConnection))
{
MySqlDataReader DBreader;
objDbConnection.Open();
DBreader = DBcommand.ExecuteReader();
if (DBreader.HasRows)
{
DBreader.Read();
int active = Int32.Parse(DBreader["active"].ToString());
if (active == 1)
{
return("success");
}
else if (active == 0)
{
return("noactive");
}
else
{
return("");
}
}
else
{
return("fail");
}
}
}
}
catch (Exception ex)
{
throw new NotImplementedException(ex.Message);
}
}
public static List <Dictionary <string, object> > DbChart(string query)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("value", typeof(int));
dt.Columns.Add("color", typeof(string));
dt.Columns.Add("highlight", typeof(string));
dt.Columns.Add("label", typeof(string));
using (MySqlConnection objDbConnection = new MySqlConnection(dbConnection))
{
using (MySqlCommand DBcommand = new MySqlCommand(query, objDbConnection))
{
MySqlDataReader DBreader;
objDbConnection.Open();
DBreader = DBcommand.ExecuteReader();
while (DBreader.Read())
{
int v = Int32.Parse(DBreader["co"].ToString());
string c = DBreader["colorcode"].ToString();
string h = DBreader["colorcode"].ToString();
string l = DBreader["membertypename"].ToString();
dt.Rows.Add(v, c, h, l);
}
return(DictionaryData(dt));
}
}
}
catch (Exception ex)
{
throw new NotImplementedException(ex.Message);
}
}
