/// <summary>
/// Deletes the specified FeedbackSession
/// </summary>
/// <returns></returns>
public int Delete(FeedbackSession feedbackSession)
{
SqlConnection conn = this.CreateSqlConnection();
try
{
this.InitializeConnection(conn);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = String.Format(@"DELETE FROM [{0}].[FeedbackSession]
WHERE [FeedbackSessionId] = @FeedbackSessionId", this.Schema);
if (ReferenceEquals(feedbackSession.FeedbackSessionId, null))
{
cmd.Parameters.AddWithValue("@FeedbackSessionId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FeedbackSessionId", feedbackSession.FeedbackSessionId);
}
int rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected);
}
finally
{
conn.Close();
}
}
/// <summary>
/// Returns a count of the numbers of rows affected by the Upsert.
/// </summary>
/// <param name="person"></param>
/// <param name="dataSource"></param>
/// <param name="dbName"></param>
/// <returns></returns>
public int Upsert(FeedbackSession feedbackSession)
{
SqlConnection conn = this.CreateSqlConnection();
try
{
this.InitializeConnection(conn);
SqlCommand cmd = conn.CreateCommand();
// Check if this method exists, and call insert or udpate as appropriate
var id = feedbackSession.FeedbackSessionId;
cmd.CommandText = String.Format(@"SELECT CASE WHEN EXISTS (SELECT * FROM [FeedbackSession] WHERE FeedbackSessionId = '{0}') THEN 1 else 0 END", id);
var rowExists = cmd.ExecuteScalar();
if (rowExists.SafeToString() == "1")
{
return(this.Update(feedbackSession));
}
else
{
return(this.Insert(feedbackSession));
}
}
finally
{
conn.Close();
}
}
partial void OnAfterPut(FeedbackSession feedbacksession);
partial void OnBeforePut(FeedbackSession feedbacksession);
partial void OnAfterGetById(FeedbackSession FeedbackSessions, String feedbackSessionId);
/// <summary>
/// Updates the specified FeedbackSession
/// </summary>
/// <returns></returns>
public int Update(FeedbackSession feedbackSession)
{
SqlConnection conn = this.CreateSqlConnection();
try
{
this.InitializeConnection(conn);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = String.Format(@"UPDATE [{0}].[FeedbackSession] SET
[Notes] = @Notes, [PersonInterviewed] = @PersonInterviewed, [Date] = @Date, [mm] = @mm, [SessionType] = @SessionType, [OverallFeedbackScore] = @OverallFeedbackScore, [Name] = @Name, [createdTime] = @createdTime
WHERE [FeedbackSessionId] = @FeedbackSessionId", this.Schema);
//TEXT
if (ReferenceEquals(feedbackSession.FeedbackSessionId, null))
{
cmd.Parameters.AddWithValue("@FeedbackSessionId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FeedbackSessionId", feedbackSession.FeedbackSessionId);
}
//TEXT
if (ReferenceEquals(feedbackSession.Notes, null))
{
cmd.Parameters.AddWithValue("@Notes", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Notes", feedbackSession.Notes);
}
//TEXT
if (ReferenceEquals(feedbackSession.PersonInterviewed, null))
{
cmd.Parameters.AddWithValue("@PersonInterviewed", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@PersonInterviewed", feedbackSession.PersonInterviewed);
}
//xs:date
if (ReferenceEquals(feedbackSession.Date, null))
{
cmd.Parameters.AddWithValue("@Date", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Date", feedbackSession.Date);
}
//SHORT
if (ReferenceEquals(feedbackSession.mm, null))
{
cmd.Parameters.AddWithValue("@mm", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@mm", feedbackSession.mm);
}
//TEXT
if (ReferenceEquals(feedbackSession.SessionType, null))
{
cmd.Parameters.AddWithValue("@SessionType", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@SessionType", feedbackSession.SessionType);
}
//INT32
if (ReferenceEquals(feedbackSession.OverallFeedbackScore, null))
{
cmd.Parameters.AddWithValue("@OverallFeedbackScore", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@OverallFeedbackScore", feedbackSession.OverallFeedbackScore);
}
//TEXT
if (ReferenceEquals(feedbackSession.Name, null))
{
cmd.Parameters.AddWithValue("@Name", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Name", feedbackSession.Name);
}
//DATETIME
if (ReferenceEquals(feedbackSession.createdTime, null) ||
(feedbackSession.createdTime == DateTime.MinValue))
{
cmd.Parameters.AddWithValue("@createdTime", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@createdTime", feedbackSession.createdTime);
}
int rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected);
}
finally
{
conn.Close();
}
}
/// <summary>
/// Returns a count of the numbers of rows affected by the insert
/// </summary>
/// <param name="person"></param>
/// <param name="dataSource"></param>
/// <param name="dbName"></param>
/// <returns></returns>
public int Insert(FeedbackSession feedbackSession)
{
SqlConnection conn = this.CreateSqlConnection();
try
{
this.InitializeConnection(conn);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = String.Format(@"INSERT INTO [{0}].[FeedbackSession] (FeedbackSessionId, Notes, PersonInterviewed, Date, mm, SessionType, OverallFeedbackScore, Name, createdTime)
VALUES (@FeedbackSessionId, @Notes, @PersonInterviewed, @Date, @mm, @SessionType, @OverallFeedbackScore, @Name, @createdTime)", this.Schema);
if (ReferenceEquals(feedbackSession.FeedbackSessionId, null))
{
cmd.Parameters.AddWithValue("@FeedbackSessionId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FeedbackSessionId", feedbackSession.FeedbackSessionId);
}
if (ReferenceEquals(feedbackSession.Notes, null))
{
cmd.Parameters.AddWithValue("@Notes", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Notes", feedbackSession.Notes);
}
if (ReferenceEquals(feedbackSession.PersonInterviewed, null))
{
cmd.Parameters.AddWithValue("@PersonInterviewed", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@PersonInterviewed", feedbackSession.PersonInterviewed);
}
if (ReferenceEquals(feedbackSession.Date, null))
{
cmd.Parameters.AddWithValue("@Date", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Date", feedbackSession.Date);
}
if (ReferenceEquals(feedbackSession.mm, null))
{
cmd.Parameters.AddWithValue("@mm", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@mm", feedbackSession.mm);
}
if (ReferenceEquals(feedbackSession.SessionType, null))
{
cmd.Parameters.AddWithValue("@SessionType", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@SessionType", feedbackSession.SessionType);
}
if (ReferenceEquals(feedbackSession.OverallFeedbackScore, null))
{
cmd.Parameters.AddWithValue("@OverallFeedbackScore", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@OverallFeedbackScore", feedbackSession.OverallFeedbackScore);
}
if (ReferenceEquals(feedbackSession.Name, null))
{
cmd.Parameters.AddWithValue("@Name", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Name", feedbackSession.Name);
}
if (ReferenceEquals(feedbackSession.createdTime, null) ||
(feedbackSession.createdTime == DateTime.MinValue))
{
cmd.Parameters.AddWithValue("@createdTime", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@createdTime", feedbackSession.createdTime);
}
int rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected);
}
finally
{
conn.Close();
}
}
