public Partys GetsByString(string sString)
{
Partys oPartys = new Partys();
try
{
SqlCommand cmd = new SqlCommand(sString, _conn);
cmd.CommandType = CommandType.Text;
if (_conn.State == ConnectionState.Open)
{
}
else
{
cmd.Connection.Open();
}
IDataReader reader = cmd.ExecuteReader();
oPartys = CreateObjects(reader);
reader.Close();
cmd.Dispose();
cmd.Connection.Close();
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(oPartys);
}
public Partys GetsByID(int nID)
{
Partys oPartys = new Partys();
try
{
SqlCommand cmd = new SqlCommand("SP_Party_GetsByID", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PartyID", SqlDbType.Int)).Value = nID;
if (_conn.State == ConnectionState.Open)
{
}
else
{
cmd.Connection.Open();
}
IDataReader reader = cmd.ExecuteReader();
oPartys = CreateObjects(reader);
reader.Close();
cmd.Dispose();
cmd.Connection.Close();
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(oPartys);
}
public static PWParty CreateParty(PWClient client)
{
PWParty party = new PWParty(client);
Partys.Add(party);
OnPartyCreated?.Invoke(null, party);
return(party);
}
private Partys CreateObjects(IDataReader oReader)
{
Partys oPartys = new Partys();
NullHandler oHandler = new NullHandler(oReader);
while (oReader.Read())
{
Party oItem = CreateObject(oHandler);
oPartys.Add(oItem);
}
return(oPartys);
}
public Company GetParty(string partyName)
{
var party = Partys.FirstOrDefault(v => v.Name == partyName);
if (party == null)
{
party = new Company();
party.Id = 0;
party.Name = partyName;
SaveCompany(party);
}
return(party);
}
/// <summary>
/// Получение всех партий.
/// </summary>
private void GetAllPartys()
{
if (GetAll != null)
{
GetAll();
}
Partys = Filters();
if (Partys.Any())
{
btnNext.Enabled = true;
btnPrev.Enabled = true;
}
else
{
btnNext.Enabled = false;
btnPrev.Enabled = false;
}
}
public Company GetParty(int guid)
{
return(Partys.SingleOrDefault(v => v.Id == guid));
}
public static void RemoveParty(PWParty party)
{
Partys.Remove(party);
OnPartyDeleted?.Invoke(null, party);
}
