//Insert a new customer
public bool insertCustomer(string name, string addr, string contact, string gender, string email, string userName, string password, string cPassword, MemoryStream picture)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `ex1`(`name`, `addr`, `contact`, `gender`, `email`, `userName`, `password`, `cPassword`, `picture`) VALUES (@cn,@ad,@cont,@gen,@em,@un,@ps,@cps,@pict)", db.getConnection);
command.Parameters.Add("@cn", MySqlDbType.VarChar).Value = name;
command.Parameters.Add("@ad", MySqlDbType.VarChar).Value = addr;
command.Parameters.Add("@cont", MySqlDbType.VarChar).Value = contact;
command.Parameters.Add("@gen", MySqlDbType.VarChar).Value = gender;
command.Parameters.Add("@em", MySqlDbType.VarChar).Value = email;
command.Parameters.Add("@un", MySqlDbType.VarChar).Value = userName;
command.Parameters.Add("@ps", MySqlDbType.VarChar).Value = password;
command.Parameters.Add("@cps", MySqlDbType.VarChar).Value = cPassword;
command.Parameters.Add("@pict", MySqlDbType.LongBlob).Value = picture.ToArray();
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}
//Insert a new employee
public bool insertEmployee(string name, string tel, string addr, string email, string empType, string sal, MemoryStream photo, string nic)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `ex3`( `name`, `tel`, `addr`, `email`, `empType`, `sal`, `photo`, `nic`) VALUES (@en,@et,@eadd,@eem,@eet,@esal,@epic,@enic)", db.getConnection);
command.Parameters.Add("@en", MySqlDbType.VarChar).Value = name;
command.Parameters.Add("@et", MySqlDbType.VarChar).Value = tel;
command.Parameters.Add("@eadd", MySqlDbType.VarChar).Value = addr;
command.Parameters.Add("@eem", MySqlDbType.VarChar).Value = email;
command.Parameters.Add("@eet", MySqlDbType.VarChar).Value = empType;
command.Parameters.Add("@esal", MySqlDbType.VarChar).Value = sal;
command.Parameters.Add("@epic", MySqlDbType.LongBlob).Value = photo.ToArray();
command.Parameters.Add("@enic", MySqlDbType.VarChar).Value = nic;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}
//Insert a new order
public bool insertOrder(string name, string email, string tele, string flowerName, int quantity, DateTime odate, string time, string branch)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `flower_order`( `name`,`email`, `tele`, `flowerName`, `quantity`, `odate`, `time`, `branch`) VALUES (@en,@em,@et,@eadd,@eem,@eet,@esal,@es)", db.getConnection);
command.Parameters.Add("@en", MySqlDbType.VarChar).Value = name;
command.Parameters.Add("@em", MySqlDbType.VarChar).Value = email;
command.Parameters.Add("@et", MySqlDbType.VarChar).Value = tele;
command.Parameters.Add("@eadd", MySqlDbType.VarChar).Value = flowerName;
command.Parameters.Add("@eem", MySqlDbType.Int32).Value = quantity;
command.Parameters.Add("@eet", MySqlDbType.Date).Value = odate;
command.Parameters.Add("@esal", MySqlDbType.VarChar).Value = time;
command.Parameters.Add("@es", MySqlDbType.VarChar).Value = branch;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}
//Insert a new Product
public bool insertProduct(string category, string productName, int proPrice, string description, MemoryStream image)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `ex5`( `category`, `productName`, `proPrice`, `description`, `image`) VALUES (@cat,@pn,@pr,@des,@img)", db.getConnection);
command.Parameters.Add("@cat", MySqlDbType.VarChar).Value = category;
command.Parameters.Add("@pn", MySqlDbType.VarChar).Value = productName;
command.Parameters.Add("@pr", MySqlDbType.Int32).Value = proPrice;
command.Parameters.Add("@des", MySqlDbType.VarChar).Value = description;
command.Parameters.Add("@img", MySqlDbType.LongBlob).Value = image.ToArray();
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
db.closeConnection();
return(true);
}
else
{
db.closeConnection();
return(false);
}
}
