public bool insertBill(string userid, string tableid) { string sql = "insert into tblHoadon (sMaNV, sMaban,dThoigianthanhtoan,sTrangthai,fToongtien) values(" + userid + "," + tableid + ",GETDATE(),0,0)"; try { conn.ExcuteNonQuery(sql); return(true); } catch (Exception exp) { return(false); } }
public bool insertTable(string name) { String sql = "insert into tblBan (sName,sStatus) values (N'" + name + "', '0');"; try { conn.ExcuteNonQuery(sql); return(true); } catch (Exception exp) { return(false); } }
public bool insertDrinks(string name, String typeDrink, String fDongia) { String sql = "insert into tblMenu (sTendouong,sLoaidouong,fDongia) values(N'" + name + "'," + typeDrink + "," + fDongia + ")"; try { conn.ExcuteNonQuery(sql); return(true); } catch (Exception exp) { return(false); } }
public bool insertTypeDrinks(string name) { String sql = "insert into tblLoaidouong (sName) values (N'" + name + "');"; try { conn.ExcuteNonQuery(sql); return(true); } catch (Exception exp) { return(false); } }
public bool insertUser(string sHoten, string sGioitinh, string iType_user, string iSdt, string dNgaysinh, string iCMND, string sUsername, string sPassword, string sDiachi) { string sql = "insert into tblUser(sHoten,sGioitinh,iType_user,iSdt,dNgaysinh,iCMND,sUsername,sPassword,sDiaChi) values" + "(N'" + sHoten + "', N'" + sGioitinh + "', " + iType_user + ", '" + iSdt + "', '" + dNgaysinh + "', '" + iCMND + "', N'" + sUsername + "', N'" + sPassword + "', N'" + sDiachi + "')"; try { conn.ExcuteNonQuery(sql); return(true); } catch (Exception exp) { return(false); } }
public bool insertBillinfor(string bill_id, string drinks_id, string soluong) { string sql = "insert into tblChitietHD(sMaHD,sMadouong,iSoluong) values (" + bill_id + "," + drinks_id + "," + soluong + ")"; try { conn.ExcuteNonQuery(sql); return(true); } catch (Exception exp) { return(false); } }