public Boolean ThemTangLuong(TangLuong pb) { SqlConnection conn = getConnection(); conn.Open(); try { string sqlThem = "INSERT INTO TangLuong VALUES(@MaPB ,@MaNV , @HoTen , @GioiTinh , @ChucVu , @MaLuong , @NgayTang)"; SqlCommand cmd = new SqlCommand(sqlThem, conn); cmd.Parameters.AddWithValue("MaPB", pb.MaPB); cmd.Parameters.AddWithValue("MaNV", pb.MaNV); cmd.Parameters.AddWithValue("HoTen", pb.HoTen); cmd.Parameters.AddWithValue("GioiTinh", pb.GioiTinh); cmd.Parameters.AddWithValue("ChucVu", pb.ChucVu); cmd.Parameters.AddWithValue("MaLuong", pb.MaLuong); cmd.Parameters.AddWithValue("NgayTang", pb.NgayTang); cmd.ExecuteNonQuery(); } catch (Exception) { return(false); } finally { conn.Close(); } return(true); }
public Boolean SuaTangLuong(TangLuong pb) { SqlConnection conn = getConnection(); conn.Open(); try { string sqlSua = "DECLARE @dem int select @dem = COUNT(MaNV) FROM TangLuong WHERE MaNV = @MaNV " + "IF @dem != 0 UPDATE TangLuong SET MaLuong = @MaLuong , NgayTang = @NgayTang WHERE MaNV = @MaNV else raiserror('',16,1)"; SqlCommand cmd = new SqlCommand(sqlSua, conn); cmd.Parameters.AddWithValue("MaNV", pb.MaNV); cmd.Parameters.AddWithValue("MaLuong", pb.MaLuong); cmd.Parameters.AddWithValue("NgayTang", pb.NgayTang); cmd.ExecuteNonQuery(); } catch (Exception) { return(false); } finally { conn.Close(); } return(true); }
public Boolean UpdateTangLuong(string MaPB, string MaNV, string HoTen, string GioiTinh, string ChucVu, string MaLuong, DateTime NgayTang) { DataProviderTangLuong dp = new DataProviderTangLuong(); TangLuong bh = new TangLuong(MaPB, MaNV, HoTen, GioiTinh, ChucVu, MaLuong, NgayTang); return(dp.SuaTangLuong(bh)); }