private void updateevaluateperformanceidcomboBox_SelectedValueChanged(object sender, EventArgs e) { string pid = updateevaluateperformanceidcomboBox.Text; p = pds.GetPerformance(pid); updateevaluatereviewcommenttext.Text = p.reviewComment; updateReviewDatetime.Value = p.reviewDate; }
public bool updatePerformance(Performance obj) { string insertCommand = "update performance set ReviewComment=@ReviewComment,ReviewDate=@ReviewDate,ReviewByAdminId=@ReviewByAdminId " + " where employeeId=@EmployeeId and performanceId=@performanceId"; SqlCommand command = new SqlCommand(insertCommand); SqlParameter idParameter = new SqlParameter("@EmployeeId", SqlDbType.NVarChar, 50); idParameter.Value = obj.employeeId; SqlParameter performanceidParameter = new SqlParameter("@performanceId", SqlDbType.NVarChar, 50); performanceidParameter.Value = obj.PerformanceId; SqlParameter ReviewCommentParameter = new SqlParameter("@ReviewComment", SqlDbType.NVarChar, 50); @ReviewCommentParameter.Value = obj.reviewComment; SqlParameter ReviewDateParameter = new SqlParameter("@ReviewDate", SqlDbType.Date); @ReviewDateParameter.Value = obj.reviewDate; SqlParameter ReviewByAdminIdParameter = new SqlParameter("@ReviewByAdminId", SqlDbType.NVarChar, 50); ReviewByAdminIdParameter.Value = obj.reviewByAdmin; command.Parameters.Add(idParameter); command.Parameters.Add(performanceidParameter); command.Parameters.Add(ReviewCommentParameter); command.Parameters.Add(ReviewDateParameter); command.Parameters.Add(ReviewByAdminIdParameter); if (da.Execution(command)) { return true; } else { return false; } }
public bool insertPerformance(Performance obj) { string insertCommand = "INSERT INTO performance (EmployeeId,performanceId,ReviewComment,ReviewDate,ReviewByAdminId) " + "VALUES (@EmployeeId,@performanceId,@ReviewComment,@ReviewDate,@ReviewByAdminId)"; SqlCommand command = new SqlCommand(insertCommand); SqlParameter idParameter = new SqlParameter("@EmployeeId", SqlDbType.NVarChar, 50); idParameter.Value = obj.employeeId; SqlParameter performanceidParameter = new SqlParameter("@performanceId", SqlDbType.NVarChar, 50); performanceidParameter.Value = obj.PerformanceId; SqlParameter ReviewCommentParameter = new SqlParameter("@ReviewComment", SqlDbType.NVarChar, 50); ReviewCommentParameter.Value = obj.reviewComment; SqlParameter ReviewDateParameter = new SqlParameter("@ReviewDate", SqlDbType.Date); ReviewDateParameter.Value = obj.reviewDate; SqlParameter ReviewByAdminIdParameter = new SqlParameter("@ReviewByAdminId", SqlDbType.NVarChar, 50); ReviewByAdminIdParameter.Value = obj.reviewByAdmin; command.Parameters.Add(idParameter); command.Parameters.Add(performanceidParameter); command.Parameters.Add(ReviewCommentParameter); command.Parameters.Add(ReviewDateParameter); command.Parameters.Add(ReviewByAdminIdParameter); if (da.Execution(command)) { return true; } else { return false; } }
public List<Performance> GetPerformanceList() { List<Performance> performanceList = new List<Performance>(); string query = "select EmployeeId,performanceId,ReviewComment,ReviewDate,ReviewByAdminId from performance"; SqlCommand cmd = da.GetCommand(query); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Performance ej = new Performance(); ej.employeeId = reader.GetString(0); ej.PerformanceId = reader.GetString(1); ej.reviewComment = reader.GetString(2); ej.reviewDate = reader.GetDateTime(3); ej.reviewByAdmin = reader.GetString(4); performanceList.Add(ej); } return performanceList; }
public Performance GetPerformance(string perid) { Performance p = new Performance(); string query = "select ReviewComment,ReviewDate from performance where performanceId= '" + perid + "'"; SqlCommand cmd = da.GetCommand(query); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { p.reviewComment = reader.GetString(0); p.reviewDate = reader.GetDateTime(1); } return p; }
public bool deletePerformance(Performance obj) { string insertCommand = "delete from performance " + " where EmployeeId=@EmployeeId and performanceId=@performanceId "; SqlCommand command = new SqlCommand(insertCommand); SqlParameter employeeIdParameter = new SqlParameter("@EmployeeId", SqlDbType.NVarChar, 50); employeeIdParameter.Value = obj.employeeId; SqlParameter performanceIdParameter = new SqlParameter("@performanceId", SqlDbType.NVarChar, 50); performanceIdParameter.Value = obj.PerformanceId; command.Parameters.Add(employeeIdParameter); command.Parameters.Add(performanceIdParameter); if (da.Execution(command)) { return true; } else { return false; } }