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