public Collection <Feedback> ManagementGetFeedbacks()
{
var feedbacks = new ManagementTeam.Collection <ManagementTeam.Feedback>();
feedbacks.Entities = new List <ManagementTeam.Feedback>();
using (SqlConnection connection = new SqlConnection
(ConfigurationManager.ConnectionStrings["SQLProviderConnectionString"].ConnectionString))
{
var cmd = new SqlCommand("dbo.umsp_GetFeedbacks", connection);
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//SELECT Id, EmployeeId, ReviewerId, WorkedTogether,
//WishToWorkTogether, PossitiveSide, NegativeSide, ThingsToImprove, Message
var feedback = new ManagementTeam.Feedback();
// TODO: modify sp, as information about employees maybe needed
feedback.Id = Int32.Parse(reader[0].ToString());
feedback.EmployeeId = int.Parse(reader[1].ToString());
feedback.ReviewerId = int.Parse(reader[2].ToString());
feedback.WorkedTogether = Boolean.Parse(reader[3].ToString());
feedback.WishToWorkTogether = Boolean.Parse(reader[4].ToString());
feedback.PossitiveSide = reader[5].ToString();
feedback.NegativeSide = reader[6].ToString();
feedback.ThingsToImprove = reader[7].ToString();
feedback.Message = reader[8].ToString();
feedbacks.Entities.Add(feedback);
}
}
return(feedbacks);
}
public EntityBase ManagementLeaveFeedback(ManagementTeam.Feedback feedback)
{
var resultEntityBase = new EntityBase();
try
{
using (var connection = new SqlConnection
(ConfigurationManager.ConnectionStrings["SQLProviderConnectionString"].ConnectionString))
{
var command = new SqlCommand("umsp_LeaveFeedback", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@employeeId", feedback.EmployeeId);
command.Parameters.AddWithValue("@reviewerId", feedback.ReviewerId);
command.Parameters.AddWithValue("@workedTogether", feedback.WorkedTogether);
command.Parameters.AddWithValue("@wishToWorkTogether", feedback.WishToWorkTogether);
command.Parameters.AddWithValue("@possitiveSide", feedback.PossitiveSide);
command.Parameters.AddWithValue("@negativeSide", feedback.NegativeSide);
command.Parameters.AddWithValue("@thingsToImprove", feedback.ThingsToImprove);
command.Parameters.AddWithValue("@message", feedback.Message);
connection.Open();
command.ExecuteNonQuery();
}
resultEntityBase.StatusInfo = "Feedback was successfully submited";
}
catch (SqlException ex)
{
resultEntityBase.StatusInfo = ex.ToString() + "ERROR! Couldn't pass data to DB";
}
return(resultEntityBase);
}
/// <summary>
/// Casts Feedback entity to a Feedback Model
/// </summary>
/// <param name="feedback"></param>
/// <returns></returns>
internal FeedbackModel CastToFeedbackModel(ManagementTeam.Feedback feedback)
{
var feedbackModel = new FeedbackModel()
{
Id = feedback.Id,
//Employee.Id = feedback.EmployeeId,
//EmployeeId = feedback.EmployeeId,
ReviewerId = feedback.ReviewerId,
WorkedTogether = feedback.WorkedTogether,
WishToWorkTogether = feedback.WishToWorkTogether,
PossitiveSide = feedback.PossitiveSide,
NegativeSide = feedback.NegativeSide,
ThingsToImprove = feedback.ThingsToImprove,
Message = feedback.Message
};
feedbackModel.Employee.Id = feedback.EmployeeId;
return(feedbackModel);
//return new FeedbackModel()
//{
// Id = feedback.Id,
// EmployeeId = feedback.EmployeeId,
// ReviewerId = feedback.ReviewerId,
// WorkedTogether = feedback.WorkedTogether,
// WishToWorkTogether = feedback.WishToWorkTogether,
// PossitiveSide = feedback.PossitiveSide,
// NegativeSide = feedback.NegativeSide,
// ThingsToImprove = feedback.ThingsToImprove,
// Message = feedback.Message
//};
}
