public bool InsertReviewNotes(ClientReviewNotes Notes)
{
bool isRowAffected = false;
try
{
string queryCommand = "INSERT";
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", Notes.AgencyId));
command.Parameters.Add(new SqlParameter("@ClientId", Notes.ClientId));
command.Parameters.Add(new SqlParameter("@ReviewMonth", Notes.ReviewMonth));
command.Parameters.Add(new SqlParameter("@OpenNotes", Notes.OpenNotes));
command.Parameters.Add(new SqlParameter("@CloseNotes", Notes.CloseNotes));
command.Parameters.Add(new SqlParameter("@UserId", Notes.UserId));
command.Parameters.Add(new SqlParameter("@StaffName", Notes.ReviewedStaffName));
command.Parameters.Add(new SqlParameter("@Status", Notes.ReviewStatus));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.CommandText = "USP_ClientReviewNotes";
int RowsAffected = command.ExecuteNonQuery();
if (RowsAffected > 0)
{
isRowAffected = true;
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(isRowAffected);
}
public List <ClientReviewNotes> GetReviewNotes(ClientReviewNotes reviewNotes, Guid userID)
{
string queryCommand = "SELECT";
List <ClientReviewNotes> notesList = new List <ClientReviewNotes>();
try
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyId", reviewNotes.AgencyId));
command.Parameters.Add(new SqlParameter("@ClientId", reviewNotes.ClientId));
command.Parameters.Add(new SqlParameter("@ReviewMonth", reviewNotes.ReviewMonth));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.CommandText = "USP_ClientReviewNotes";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
if ((_dataset.Tables[0] != null) && (_dataset.Tables[0].Rows.Count > 0))
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
reviewNotes = new ClientReviewNotes();
reviewNotes.ClientId = Convert.ToInt64(dr["ClientId"].ToString());
reviewNotes.ReviewedStaffName = dr["StaffName"].ToString();
reviewNotes.ReviewStatus = Convert.ToBoolean(dr["Status"]);
reviewNotes.NotesId = Convert.ToInt64(dr["NotesId"]);
reviewNotes.OpenNotes = dr["OpenNotes"].ToString();
reviewNotes.CloseNotes = dr["CloseNotes"].ToString();
reviewNotes.ReviewDate = Convert.ToDateTime(dr["DateReviewed"]).ToString("MM/dd/yyyy");
reviewNotes.UserActiveStatus = (dr["UserActiveStatus"].ToString() == "1") ? true : (dr["UserActiveStatus"].ToString() == "2") ? false : false;
reviewNotes.StaffUniqueColor = dr["UserColor"].ToString();
reviewNotes.UserId = new Guid(dr["CreatedBy"].ToString());
if (reviewNotes.UserId != userID)
{
if (!reviewNotes.UserActiveStatus)
{
reviewNotes.IsEdit = true;
}
}
else
{
reviewNotes.IsEdit = true;
}
notesList.Add(reviewNotes);
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(notesList);
}
