public async Task <List <DisplayResponceModel> > BulkTrash(List <int> NoteId, int UserId)
{
try
{
SqlConnection connection = DBConnection();
SqlCommand command = StoreProcedureConnection("spBulkTrash", connection);
List <DisplayResponceModel> responceList = new List <DisplayResponceModel>();
string noteIdString = string.Empty;
foreach (int i in NoteId)
{
noteIdString = noteIdString + i + ",";
}
string noteId = noteIdString.Remove(noteIdString.Length - 1);
command.Parameters.AddWithValue("@Id", noteId);
command.Parameters.AddWithValue("@UId", UserId);
connection.Open();
SqlDataReader dataReader = await command.ExecuteReaderAsync();
while (dataReader.Read())
{
DisplayResponceModel userDetails = new DisplayResponceModel();
userDetails.Id = (int)dataReader["Id"];
userDetails.Title = dataReader["Title"].ToString();
userDetails.Message = dataReader["MeassageDescription"].ToString();
userDetails.Image = dataReader["NoteImage"].ToString();
userDetails.Color = dataReader["Color"].ToString();
userDetails.CreatedDate = (DateTime)dataReader["CreatedDATETime"];
userDetails.ModifiedDate = (DateTime)dataReader["ModifiedDateTime"];
if (dataReader["AddReminder"] == null || dataReader["AddReminder"].Equals(DBNull.Value))
{
userDetails.AddReminder = null;
}
else
{
userDetails.AddReminder = (DateTime)dataReader["AddReminder"];
}
userDetails.UserId = (int)dataReader["UserId"];
userDetails.IsPin = (bool)dataReader["IsPin"];
userDetails.IsNote = (bool)dataReader["IsNote"];
userDetails.IsArchive = (bool)dataReader["IsArchive"];
userDetails.IsTrash = (bool)dataReader["IsTrash"];
responceList.Add(userDetails);
}
connection.Close();
return(responceList);
}
catch (Exception e)
{
throw e;
}
}
public async Task <IList <DisplayResponceModel> > DisplayLabel(string labelName, int userId)
{
try
{
IList <DisplayResponceModel> notes = new List <DisplayResponceModel>();
List <SpParameterData> paramsList = new List <SpParameterData>();
paramsList.Add(new SpParameterData("@UserId", userId));
paramsList.Add(new SpParameterData("@LabelName", labelName));
DataTable table = await spExecuteReader("spDisplayLabelNotes", paramsList);
foreach (DataRow row in table.Rows)
{
DisplayResponceModel userDetails = new DisplayResponceModel();
userDetails.Id = (int)row["Id"];
userDetails.Title = row["Title"].ToString();
userDetails.Message = row["MeassageDescription"].ToString();
userDetails.Image = row["NoteImage"].ToString();
userDetails.Color = row["Color"].ToString();
userDetails.CreatedDate = (DateTime)row["CreatedDATETime"];
userDetails.ModifiedDate = (DateTime)row["ModifiedDateTime"];
if (row["AddReminder"] == null || row["AddReminder"].Equals(DBNull.Value))
{
userDetails.AddReminder = null;
}
else
{
userDetails.AddReminder = (DateTime)row["AddReminder"];
}
userDetails.collaborators = await GetNoteallCollaborator(userDetails.Id, userId);
userDetails.Labels = await GetNoteLabels(userDetails.Id, userId);
userDetails.UserId = (int)row["UserId"];
userDetails.IsPin = (bool)row["IsPin"];
userDetails.IsNote = (bool)row["IsNote"];
userDetails.IsArchive = (bool)row["IsArchive"];
userDetails.IsTrash = (bool)row["IsTrash"];
notes.Add(userDetails);
}
return(notes);
}
catch (Exception e)
{
throw e;
}
}
