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