private static List <Lister> GetListersAllByGroupID(int?id)
{
List <Lister> ls = new List <Lister>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_GetListersAllByGroupID", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@GroupID", id);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
ls.Add(Lister.GetListerByID(rd.GetInt32(0)));
}
rd.Close();
}
catch
{
ls = new List <Lister>();
}
finally
{
con.Close();
}
return(ls);
}
private void Control_Changed(object sender, TextChangedEventArgs e)
{
if (dgListers.ItemsSource != null)
{
ListCollectionView view = (ListCollectionView)CollectionViewSource.GetDefaultView(dgListers.ItemsSource);
view.Filter = delegate(object item)
{
Lister l = (Lister)item;
if (txtFirstName.Text != "" && !l.FirstName.Contains(txtFirstName.Text))
{
return(false);
}
if (txtLastName.Text != "" && !l.LastName.Contains(txtLastName.Text))
{
return(false);
}
if (cmboGender.SelectedIndex > 0)
{
return((cmboGender.SelectedIndex == 1) ? (l.Gender == "ذكر") : (l.Gender == "أنثى"));
}
return(true);
};
view.Refresh();
}
}
private void btnDelLister_Click(object sender, RoutedEventArgs e)
{
if (dgListers.SelectedIndex != -1)
{
if (!BaseDataBase.CurrentUser.CanDelete)
{
MyMessageBox.Show("ليس لديك صلاحيات للحذف");
}
else
{
Lister l = Lister.GetListerByID((int)(dgListers.Items[dgListers.SelectedIndex] as DataRowView)[0]);
if (int.Parse(BaseDataBase._Scalar("select dbo.GetGroupCountByListerID(" + l.ListerID + ")")) > 0)
{
MyMessageBox.Show("لا يمكن حذف المقيّم \nبسبب وجود بيانات تقييم سابقة له ضمن فرق التقييم");
}
else if (int.Parse(BaseDataBase._Scalar("select COUNT(ID) from Trained where TrainedType = 2 and TrainedID = " + l.ListerID)) > 0)
{
MyMessageBox.Show("لا يمكن حذف المقيّم \nبسبب وجود بيانات تدريب سابقة له");
}
else if (DBMain.DeleteData(l))
{
dgListers.ItemsSource = Lister.GetAllListersTable;
MyMessage.DeleteMessage();
}
}
}
}
public ListerControl(int ListerID)
{
InitializeComponent();
this.DataContext = Lister.GetListerByID(ListerID);
btnExecute.Visibility = System.Windows.Visibility.Hidden;
btnUpdate.Visibility = System.Windows.Visibility.Visible;
}
private void btnDelLister_Click(object sender, RoutedEventArgs e)
{
if (lbListerGroup.SelectedIndex != -1)
{
List <Lister> ListersLB = (List <Lister>)lbListerGroup.ItemsSource;
Lister l = lbListerGroup.SelectedItem as Lister;
ListersLB.Remove(l);
lbListerGroup.Items.Refresh();
}
}
public static Lister GetListerByID(int?id)
{
Lister x = new Lister();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_GetListerByID", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@ListerID", id);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
if (!(rd["ListerID"] is DBNull))
{
x.ListerID = System.Int32.Parse(rd["ListerID"].ToString());
}
x.FirstName = rd["FirstName"].ToString();
x.LastName = rd["LastName"].ToString();
x.Gender = rd["Gender"].ToString();
x.BirthPlace = rd["BirthPlace"].ToString();
if (!(rd["DOB"] is DBNull))
{
x.DOB = System.DateTime.Parse(rd["DOB"].ToString());
}
x.Job = rd["Job"].ToString();
x.Phone = rd["Phone"].ToString();
x.Mobile = rd["Mobile"].ToString();
x.Email = rd["Email"].ToString();
x.MaritalStatus = rd["MaritalStatus"].ToString();
if (!(rd["ChildCount"] is DBNull))
{
x.ChildCount = System.Int32.Parse(rd["ChildCount"].ToString());
}
x.PlaceAddress = rd["PlaceAddress"].ToString();
x.ScientificQualifier = rd["ScientificQualifier"].ToString();
x.IdentityImage = rd["IdentityImage"].ToString();
x.Notes = rd["Notes"].ToString();
}
rd.Close();
}
catch
{
x = null;
}
finally
{
con.Close();
}
return(x);
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
Lister x = (Lister)this.DataContext;
if (x.IsValidate())
{
if (DBMain.UpdateData(x))
{
MyMessage.UpdateMessage();
DialogResult = true;
}
}
}
private void btnAddLister_Click(object sender, RoutedEventArgs e)
{
if (dgListers.SelectedIndex != -1)
{
List <Lister> ListersLB;
if (lbListerGroup.ItemsSource == null)
{
ListersLB = new List <Lister>();
lbListerGroup.ItemsSource = ListersLB;
}
else
{
ListersLB = lbListerGroup.ItemsSource as List <Lister>;
}
Lister l = dgListers.SelectedItem as Lister;
if (!ListersLB.Contains(l))
{
ListersLB.Add(l);
}
lbListerGroup.Items.Refresh();
}
}
//Done :)
public static List <ListerGroup> GetListerGroupsByFamilyID(int?FamilyID)
{
List <ListerGroup> lgs = new List <ListerGroup>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_All_ListerGroups_ByFamilyID", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@FamilyID", FamilyID);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
ListerGroup lg = null;
while (rd.Read())
{
if (lg == null || (int)rd["ListerGroupID"] != lg.GroupID.Value)
{
lg = new ListerGroup();
lg.GroupID = (int)rd["ListerGroupID"];
if (!(rd["OrphanID"] is DBNull))
{
lg.OrphanID = System.Int32.Parse(rd["OrphanID"].ToString());
}
if (!(rd["Date"] is DBNull))
{
lg.Date = System.DateTime.Parse(rd["Date"].ToString());
}
lg.Evaluation = rd["Evaluation"].ToString();
lg.Notes = rd["ListerGroupNotes"].ToString();
lg.CreatePerson = rd["CreatePerson"].ToString();
if (!(rd["CreateDate"] is DBNull))
{
lg.CreateDate = System.DateTime.Parse(rd["CreateDate"].ToString());
}
lg.LastModifiedPerson = rd["LastModifiedPerson"].ToString();
lg.Notes = rd["ListerGroupNotes"].ToString();
if (!(rd["FamilyID"] is DBNull))
{
lg.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
}
lgs.Add(lg);
}
Lister l = new Lister();
l.ListerID = System.Int32.Parse(rd["ListerListerID"].ToString());
l.FirstName = rd["FirstName"].ToString();
l.LastName = rd["LastName"].ToString();
l.Gender = rd["Gender"].ToString();
l.BirthPlace = rd["BirthPlace"].ToString();
if (!(rd["DOB"] is DBNull))
{
l.DOB = System.DateTime.Parse(rd["DOB"].ToString());
}
l.Job = rd["Job"].ToString();
l.Phone = rd["Phone"].ToString();
l.Mobile = rd["Mobile"].ToString();
l.Email = rd["Email"].ToString();
l.MaritalStatus = rd["MaritalStatus"].ToString();
if (!(rd["ChildCount"] is DBNull))
{
l.ChildCount = System.Int32.Parse(rd["ChildCount"].ToString());
}
l.PlaceAddress = rd["PlaceAddress"].ToString();
l.ScientificQualifier = rd["ScientificQualifier"].ToString();
l.IdentityImage = rd["IdentityImage"].ToString();
l.Notes = rd["ListerNotes"].ToString();
lg.Listers.Add(l);
// lg.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupByListerGroupID(lg.GroupID.Value);
}
rd.Close();
}
catch
{
lgs = new List <ListerGroup>();
}
finally
{
con.Close();
}
return(lgs);
}