private void btnNoteDelete_Click(object sender, EventArgs e)
{
if (lstNotesOfPeople.SelectedItems.Count <= 0)
{
return;
}
txtNoteText.Text = "";
btnNoteSave.Enabled = false;
if (MyPeople.OpenDetailsForAdd || MyPeople.OpenForPersonalAdd)
{
NotesOfPeople n = MyPeople.Note.Find(p => p.NoteId == int.Parse(lstNotesOfPeople.SelectedItems[0].SubItems[3].Text));
MyPeople.Note.Remove(n);
lstNotesOfPeople.Items.Remove(lstNotesOfPeople.SelectedItems[0]);
}
else
{
int id = int.Parse(lstNotesOfPeople.SelectedItems[0].SubItems[3].Text);
DBFunction.Execute("delete from NotesOfPeople where NoteId=" + id);
HistoryChangeDetails h = new HistoryChangeDetails(
GLOBALVARS.MyUser.ID,
MyPeople.ID,
GLOBALVARS.MyUser.Name,
"הערה - מחיקה",
lstNotesOfPeople.SelectedItems[0].SubItems[2].Text,
"");
h.InserHistory();
loadNotes();
}
}
public static HistoryChangeDetails ReaderToHistoryChangeDetails(ref SqlDataReader reader)
{
HistoryChangeDetails h = new HistoryChangeDetails();
h.Date = DateTime.Parse(reader["Date"].ToString());
h.NameUser = (string)reader["NameUser"];
h.FieldName = (string)reader["FieldName"];
h.CurrentValue = (string)reader["CurrentValue"];
h.NewValue = (string)reader["NewValue"];
return(h);
}
private void btnconfirm_Click(object sender, EventArgs e)
{
LoadTxtsToPeople();
// try {
GLOBALVARS.LastPeopleCheckDB = DateTime.Now;
UpdateManager.UpdateLastTimeCheckToDb();
if (MyPeople.OpenDetailsForAdd || MyPeople.OpenForPersonalAdd)
{
People p = MyPeople;
p.Details.Pic = "sample49";
int id;
if (People.InsretNew(p, out id))
{
SaveCard = true;
//foreach (var item in p.Note)
//{
// item.PeopleId = id;
// HistoryChangeDetails h = new HistoryChangeDetails(
// GLOBALVARS.MyUser.ID,
// id,
// GLOBALVARS.MyUser.Name,
// "הערה חדשה",
//"",
//item.NoteText);
// h.InserHistory();
// People.InsertNewNotes(item);
// }
MyPeople.ID = id;
MessageBox.Show("נוסף בהצלחה", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("אירעה שגיאה. אנא בדקו שכל הנתונים שהזנתם תקינים", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
People.UpdatePeople(MyPeople, false);
SaveCard = true;
HistoryChangeDetails.InserListHistory(cdc);
}
if ((sender as Button) == btnConfirmClose)
{
Close();
}
}
private void LoadHistory()
{
if (MyPeople.OpenDetailsForAdd || MyPeople.OpenForPersonalAdd)
{
return;
}
SqlDataReader reader = HistoryChangeDetails.GetHistory(true, MyPeople);
List <HistoryChangeDetails> hl = new List <HistoryChangeDetails>();
olstHistoryChangeDetails.BeginUpdate();
while (reader.Read())
{
HistoryChangeDetails h = new HistoryChangeDetails();
h = HistoryChangeDetails.ReaderToHistoryChangeDetails(ref reader);
hl.Add(h);
}
olstHistoryChangeDetails.SetObjects(hl);
olstHistoryChangeDetails.EndUpdate();
reader.Close();
}
private void btnNoteSave_Click(object sender, EventArgs e)
{
if (MyPeople.OpenDetailsForAdd || MyPeople.OpenForPersonalAdd)
{
if (isnew)//הערה חדשה
{
if (txtNoteText.Text.Length < 1000)
{
MyPeople.Note.Add(new NotesOfPeople()
{
NoteText = txtNoteText.Text, NoteId = tempId
});
tempId++;
ListViewItem item;
lstNotesOfPeople.BeginUpdate();
item = new ListViewItem(new string[] {
DateTime.Now.ToShortDateString(),
GLOBALVARS.MyUser.Name,
txtNoteText.Text,
tempId.ToString()
});
item.Tag = tempId.ToString();
lstNotesOfPeople.Items.Add(item);
lstNotesOfPeople.EndUpdate();
}
else
{
MessageBox.Show("אורך הערה מקסימלי הוא עד 1000 תווים." + Environment.NewLine + "נא פצלו ל2 הערות");
}
}
else//הערה ששינו אותה
{
lstNotesOfPeople.SelectedItems[0].SubItems[2].Text = txtNoteText.Text;
MyPeople.Note.ToArray()[lstNotesOfPeople.SelectedItems[0].Index].NoteText = txtNoteText.Text;
}
}
else//הערה שמשנים אותה נשמרת מייד
{
if (isnew)
{
if (txtNoteText.Text.Length < 1000)
{
HistoryChangeDetails h = new HistoryChangeDetails(
GLOBALVARS.MyUser.ID,
MyPeople.ID,
GLOBALVARS.MyUser.Name,
"הערה חדשה",
"",
txtNoteText.Text);
h.InserHistory();
People.InsertNewNotes(new NotesOfPeople()
{
NoteText = txtNoteText.Text, PeopleId = MyPeople.ID
});
loadNotes();
}
else
{
MessageBox.Show("אורך הערה מקסימלי הוא עד 1000 תווים." + Environment.NewLine + "נא פצלו ל2 הערות");
}
}
else
{
NotesOfPeople n = new NotesOfPeople()
{
NoteId = int.Parse(lstNotesOfPeople.SelectedItems[0].SubItems[3].Text),
UserId = int.Parse(lstNotesOfPeople.SelectedItems[0].Tag.ToString()),
UserName = lstNotesOfPeople.SelectedItems[0].SubItems[1].Text,
NoteText = txtNoteText.Text,
PeopleId = MyPeople.ID,
NoteDate = DateTime.Parse(lstNotesOfPeople.SelectedItems[0].SubItems[0].Text)
};
if (txtNoteText.Text.Length < 1000)
{
HistoryChangeDetails h = new HistoryChangeDetails(
GLOBALVARS.MyUser.ID,
MyPeople.ID,
GLOBALVARS.MyUser.Name,
"הערה - עדכון",
lstNotesOfPeople.SelectedItems[0].SubItems[2].Text,
txtNoteText.Text);
h.InserHistory();
People.UpdateNotes(n);
loadNotes();
}
else
{
MessageBox.Show("אורך הערה מקסימלי הוא עד 1000 תווים." + Environment.NewLine + "נא פצלו ל2 הערות");
}
}
}
}
