public bool UpdateNote(ResponseUserNote Note, string InsertUser)
{
bool rpta = false;
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspUpdateUserNote]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlCmd.Parameters.AddWithValue("@NoteID", Note.NoteID);
SqlCmd.Parameters.AddWithValue("@InsertUser", InsertUser);
SqlCmd.Parameters.AddWithValue("@UpdateType", Note.ActionType);
if (Note.ResponseNote.Length > 0)
{
SqlCmd.Parameters.AddWithValue("@ResponseNote", Note.ResponseNote);
}
//EXEC Command
SqlCmd.ExecuteNonQuery();
rpta = true;
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(rpta);
}
public bool UpdateNote(ResponseUserNote Note, string InsertUser)
{
return(UDAL.UpdateNote(Note, InsertUser));
}
