public bool add(loaidto loai) { string insert = string.Format("insert into LOAI (MALOAI,TENLOAI) values (@maloai,@tenloai)"); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@maloai", SqlDbType.NVarChar, 15); sqlParameters[0].Value = Convert.ToString(loai.Maloai); sqlParameters[1] = new SqlParameter("@tenloai", SqlDbType.NVarChar, 50); sqlParameters[1].Value = Convert.ToString(loai.Tenloai); return(conn.executeInsertQuery(insert, sqlParameters)); }
public bool add(thanhphodto thanhpho) { string insert = string.Format("insert into THANHPHO (MATP,TENTP) values (@matp,@tentp)"); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@matp", SqlDbType.NVarChar, 15); sqlParameters[0].Value = Convert.ToString(thanhpho.Mathanhpho); sqlParameters[1] = new SqlParameter("@tentp", SqlDbType.NVarChar, 100); sqlParameters[1].Value = Convert.ToString(thanhpho.Tenthanhpho); return(conn.executeInsertQuery(insert, sqlParameters)); }
public bool add(nhaphangdto nhaphang) { string insert = string.Format("insert into NHAPHANG (MANHAPHANG,NGAYNHAPHANG,MACHINHANH) values (@manh,@ngaynh,@machinhanh)"); SqlParameter[] sqlParameters = new SqlParameter[3]; sqlParameters[0] = new SqlParameter("@manh", SqlDbType.NVarChar, 15); sqlParameters[0].Value = Convert.ToString(nhaphang.Manhaphang); sqlParameters[1] = new SqlParameter("@ngaynh", SqlDbType.Date); sqlParameters[1].Value = Convert.ToString(nhaphang.Ngaynhaphang); sqlParameters[2] = new SqlParameter("@machinhanh", SqlDbType.Int); sqlParameters[2].Value = nhaphang.Machinhanh; return(conn.executeInsertQuery(insert, sqlParameters)); }
public bool add(cuahangdto cuahang) { string insert = string.Format("insert into CUAHANG (TENCHINHANH,DIACHI,MATP) values (@tenchinhanh,@diachi,@matp)"); SqlParameter[] sqlParameters = new SqlParameter[3]; sqlParameters[0] = new SqlParameter("@tenchinhanh", SqlDbType.NVarChar, 100); sqlParameters[0].Value = Convert.ToString(cuahang.Tenchinhanh); sqlParameters[1] = new SqlParameter("@diachi", SqlDbType.NVarChar, 100); sqlParameters[1].Value = Convert.ToString(cuahang.Diachi); sqlParameters[2] = new SqlParameter("@matp", SqlDbType.NVarChar, 15); sqlParameters[2].Value = Convert.ToString(cuahang.Matp); return(conn.executeInsertQuery(insert, sqlParameters)); }
public bool add(vatphamdto vp) { string insert = string.Format("insert into VATPHAM (HINHANH,TENVP,LOAIVP,GIA,TUKHOA) values (@hinhanh,@tenvp,@loaivp,@gia,@tukhoa)"); SqlParameter[] sqlParameters = new SqlParameter[5]; sqlParameters[0] = new SqlParameter("@hinhanh", SqlDbType.NVarChar, 100); sqlParameters[0].Value = Convert.ToString(vp.Hinhanh); sqlParameters[1] = new SqlParameter("@tenvp", SqlDbType.NVarChar, 100); sqlParameters[1].Value = Convert.ToString(vp.Tenvatpham); sqlParameters[2] = new SqlParameter("@loaivp", SqlDbType.NVarChar, 15); sqlParameters[2].Value = Convert.ToString(vp.Loaivatpham); sqlParameters[3] = new SqlParameter("@gia", SqlDbType.Decimal); sqlParameters[3].Value = Convert.ToString(vp.Gia); sqlParameters[4] = new SqlParameter("@tukhoa", SqlDbType.NVarChar, 100); sqlParameters[4].Value = Convert.ToString(vp.Tukhoa); return(conn.executeInsertQuery(insert, sqlParameters)); }
public bool add(tonkhodto tonkho) { string insert = string.Format("insert into TONKHO (MANHAPHANG,MAVP,NGAYHETHAN,SOLUONGNHAP,SOLUONGTON) values (@manh,@mavp,@ngayhethan,@slnhap,@slton)"); SqlParameter[] sqlParameters = new SqlParameter[5]; sqlParameters[0] = new SqlParameter("@manh", SqlDbType.NVarChar, 15); sqlParameters[0].Value = Convert.ToString(tonkho.Manhaphang); sqlParameters[1] = new SqlParameter("@mavp", SqlDbType.Int); sqlParameters[1].Value = Convert.ToString(tonkho.Mavp); sqlParameters[2] = new SqlParameter("@ngayhethan", SqlDbType.Date); sqlParameters[2].Value = Convert.ToString(tonkho.Ngayhethan); sqlParameters[3] = new SqlParameter("@slnhap", SqlDbType.Int); sqlParameters[3].Value = Convert.ToString(tonkho.Soluongnhap); sqlParameters[4] = new SqlParameter("@slton", SqlDbType.Int); sqlParameters[4].Value = Convert.ToString(tonkho.Soluongton); return(conn.executeInsertQuery(insert, sqlParameters)); }