private void FillList()
{
DBConnection.cmd.CommandType = CommandType.StoredProcedure;
if (Properties.Settings.Default.nameBranch == Properties.Settings.Default.nameOffice)
{
DBConnection.cmd.CommandText = "sp_displayFollowUPBranch";
DBConnection.cmd.Parameters.Add(new SqlParameter("@Branch", SqlDbType.Int));
DBConnection.cmd.Parameters["@Branch"].Value = Properties.Settings.Default.Branch;
}
else
{
DBConnection.cmd.CommandText = "sp_displayFollowUPOffice";
DBConnection.cmd.Parameters.Add(new SqlParameter("@Office", SqlDbType.Int));
DBConnection.cmd.Parameters["@Office"].Value = Properties.Settings.Default.Office;
}
DBConnection.cmd.Parameters.Add(new SqlParameter("@Success", SqlDbType.Int));
DBConnection.cmd.Parameters["@Success"].Direction = ParameterDirection.Output;
Follow_up TR;
try
{
list.Clear();
DBConnection.OpenConnection();
DBConnection.reader = DBConnection.cmd.ExecuteReader();
while (DBConnection.reader.Read())
{
TR = new Follow_up();
TR.DecisionNO = DBConnection.reader.GetInt64(0).ToString();
TR.fullname = DBConnection.reader.GetString(1);
TR.ReceivedDate = DBConnection.reader.GetDateTime(2);
TR.VisitDate2 = DBConnection.reader.GetString(3);
TR.DeliverDate2 = DBConnection.reader.GetString(4);
TR.Distance2 = DBConnection.reader.GetString(5);
TR.FStatus2 = DBConnection.reader.GetString(6);
TR.Scribe_ssn2 = DBConnection.reader.GetString(7);
TR.Observer_ssn = DBConnection.reader.GetString(8);
list.Add(TR);
}
_list2.Clear();
_list2.AddRange(list.ToList <Follow_up>());
}
catch (Exception ex)
{
MessageBox.Show("خطا في عرض البيانات" + Environment.NewLine + ex.Message.ToString(), "", MessageBoxButton.OK, MessageBoxImage.Error,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
finally
{
DBConnection.CloseConnection();
}
}
private void FillList()
{
DBConnection.cmd.CommandType = CommandType.StoredProcedure;
if (Properties.Settings.Default.nameBranch == Properties.Settings.Default.nameOffice)
{
DBConnection.cmd.CommandText = "sp_displayFollowUPObserverBranch";
DBConnection.cmd.Parameters.Add(new SqlParameter("@Branch", SqlDbType.Int));
DBConnection.cmd.Parameters["@Branch"].Value = Properties.Settings.Default.Branch;
}
else
{
DBConnection.cmd.CommandText = "sp_displayFollowUPObserverOffice";
DBConnection.cmd.Parameters.Add(new SqlParameter("@Office", SqlDbType.Int));
DBConnection.cmd.Parameters["@Office"].Value = Properties.Settings.Default.Office;
}
DBConnection.cmd.Parameters.Add(new SqlParameter("@Observer_ssn", SqlDbType.BigInt));
DBConnection.cmd.Parameters.Add(new SqlParameter("@Success", SqlDbType.Int));
DBConnection.cmd.Parameters["@Observer_ssn"].Value = Properties.Settings.Default.EmpNo;
DBConnection.cmd.Parameters["@Success"].Direction = ParameterDirection.Output;
Follow_up TR;
try
{
List.Clear();
DBConnection.OpenConnection();
DBConnection.reader = DBConnection.cmd.ExecuteReader();
while (DBConnection.reader.Read())
{
TR = new Follow_up
{
DecisionNO = DBConnection.reader.GetInt64(0).ToString(),
fullname = DBConnection.reader.GetString(1),
Phone = DBConnection.reader.GetString(2),
Office = DBConnection.reader.GetString(3),
LastConnection2 = DBConnection.reader.GetString(4),
Notice = DBConnection.reader.GetString(5),
Comment = DBConnection.reader.GetString(6)
};
List.Add(TR);
}
_list2.Clear();
_list2.AddRange(List.ToList <Follow_up>());
}
catch (Exception ex)
{
MessageBox.Show("خطا في عرض البيانات" + Environment.NewLine + ex.Message.ToString(), "", MessageBoxButton.OK, MessageBoxImage.Error,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
finally
{
DBConnection.CloseConnection();
}
}
