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