public static int insertPhieuNhap(PhieuNhap m)
{
try
{
return NhapHangDAO.insertPhieuNhap(m);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi thêm phiếu nhập");
}
return -1;
}
public int insertPhieuNhap(PhieuNhap m)
{
sql = "INSERT INTO PhieuNhap(MaNhanVien,TongTien,Ngay) VALUES(@MaNhanVien,@TongTien,@Ngay)";
cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Connection = helper.GetConnect();
cmd.Parameters.AddWithValue("@MaNhanVien", m.MaNhanVien);
cmd.Parameters.AddWithValue("@TongTien", m.TongTien);
cmd.Parameters.AddWithValue("@Ngay", m.Ngay);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "SELECT @@IDENTITY";
int insertID = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
cmd = null;
return insertID;
}
public static int insertPhieuNhap(PhieuNhap m)
{
cnn = helper.GetConnect();
string sql = "INSERT INTO PhieuNhap(id,MaNhanVien,TongTien,Ngay) VALUES(@id,@MaNhanVien,@TongTien,@Ngay)";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Connection = cnn;
cmd.Parameters.AddWithValue("@id", m.Id);
cmd.Parameters.AddWithValue("@MaNhanVien", m.MaNhanVien);
cmd.Parameters.AddWithValue("@TongTien", m.TongTien);
DateTime date = Convert.ToDateTime(m.Ngay);
cmd.Parameters.AddWithValue("@Ngay", date);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "SELECT @@IDENTITY";
//int insertID = Convert.ToInt32(cmd.ExecuteScalar());
int insertID = 1;
cmd.Dispose();
cmd = null;
return insertID;
}
