public List <ClientRep> SearchClient(string text)
{
string query = "SELECT * from Client WHERE Name LIKE '%" + text + "%'"; //OR AccountHolderName LIKE '%" + text + "%'";
List <ClientRep> aList = new List <ClientRep>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
ClientRep a = new ClientRep();
//a.AccountId = sdr["AccountId"].ToString();
//a.AccountHolderName = sdr["AccountHolderName"].ToString();
//a.Balance = Convert.ToDouble(sdr["Balance"]);
a.Id = sdr["Id"].ToString();
a.Name = sdr["Name"].ToString();
a.Address = sdr["Address"].ToString();
a.Email = sdr["Email"].ToString();
a.Contacts = sdr["Contact"].ToString();
aList.Add(a);
}
return(aList);
}
public bool Insert(ClientRep cr)
{
try
{
string query = "INSERT into Client VALUES ('" + cr.Id + "', '" + cr.Name + "', '" + cr.Gender + "', '" + cr.Address + "', '" + cr.Email + "', '" + cr.Contacts + "', '" + cr.Password + "','" + cr.Occupation + "','" + cr.AddedBy + "')";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public List <ClientRep> GetAllClient()
{
string query = "SELECT * from Client";
List <ClientRep> crList = new List <ClientRep>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
ClientRep cr = new ClientRep();
////a.AccountId = sdr["AccountId"].ToString();
////a.AccountHolderName = sdr["AccountHolderName"].ToString();
////a.Balance = Convert.ToDouble(sdr["Balance"]);
//cr.SalesID = sdr["ID"].ToString();
//cr.CustName = sdr["Name"].ToString();
////cr.Gender =
////se.SeniorEmployeename = sdr["Name"].ToString();
////cr.CustGender = sdr["Gender"].ToString();
//cr.CustAddress = sdr["Address"].ToString();
//cr.CustMail = sdr["Email"].ToString();
////cr.Status = sdr["Status"].ToString();
//cr.CustContacts = sdr["Contact"].ToString();
//cr.Payment = sdr["Payment"].ToString();
//cr.VecModel = sdr["VehicleModel"].ToString();
//cr.VecNetCost = sdr["NetCost"].ToString();
//cr.Date = sdr["PurchaseDate"].ToString();
cr.Id = sdr["Id"].ToString();
cr.Name = sdr["Name"].ToString();
cr.Address = sdr["Address"].ToString();
cr.Email = sdr["Email"].ToString();
cr.Contacts = sdr["Contact"].ToString();
cr.Occupation = sdr["Occupation"].ToString();
crList.Add(cr);
}
return(crList);
}