public List<torganization> GetAllOrganizations()
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("GetAllOrganizations", con);
cmd.CommandType = CommandType.StoredProcedure;
// Создать коллекцию для всех записей
List<torganization> Organizations = new List<torganization>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
torganization emp = new torganization(
(int)reader["organizationID"],
(string)reader["name"],
(string)reader["director"],
(string)reader["position"],
(string)reader["orgface"],
(string)reader["address1"],
(string)reader["orgemail"],
(string)reader["orgphone"],
(string)reader["address2"],
(string)reader["contactname"],
(string)reader["contactposition"],
(string)reader["contactphone"],
(string)reader["bikbank"],
(string)reader["bank"],
(string)reader["rschet"],
(string)reader["orgschet"],
(string)reader["inn"],
(string)reader["kpp"],
(string)reader["ogrn"],
(string)reader["okpo"]);
Organizations.Add(emp);
}
reader.Close();
return Organizations;
}
catch
{
throw new ApplicationException("Ошибка данныx.");
}
finally
{
con.Close();
}
}
public int InsertOrganization(torganization emp1)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("InsertOrganization", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Director", SqlDbType.NVarChar, 200));
cmd.Parameters["@Director"].Value = emp1.Director;
cmd.Parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar, 50));
cmd.Parameters["@Name"].Value = emp1.Name;
cmd.Parameters.Add(new SqlParameter("@Position", SqlDbType.NVarChar, 50));
cmd.Parameters["@Position"].Value = emp1.Position;
cmd.Parameters.Add(new SqlParameter("@Orgface", SqlDbType.NVarChar, 200));
cmd.Parameters["@Orgface"].Value = emp1.Orgface;
cmd.Parameters.Add(new SqlParameter("@Address1", SqlDbType.NVarChar, 200));
cmd.Parameters["@Address1"].Value = emp1.Address1;
cmd.Parameters.Add(new SqlParameter("@Orgemail", SqlDbType.NVarChar, 50));
cmd.Parameters["@Orgemail"].Value = emp1.Orgemail;
cmd.Parameters.Add(new SqlParameter("@Orgphone", SqlDbType.NVarChar, 20));
cmd.Parameters["@Orgphone"].Value = emp1.Orgphone;
cmd.Parameters.Add(new SqlParameter("@Address2", SqlDbType.NVarChar, 200));
cmd.Parameters["@Address2"].Value = emp1.Address2;
cmd.Parameters.Add(new SqlParameter("@Contactname", SqlDbType.NVarChar, 150));
cmd.Parameters["@Contactname"].Value = emp1.Contactname;
cmd.Parameters.Add(new SqlParameter("@Bank", SqlDbType.NVarChar, 50));
cmd.Parameters["@Bank"].Value = emp1.Bank;
cmd.Parameters.Add(new SqlParameter("@Contactposition", SqlDbType.NVarChar, 50));
cmd.Parameters["@Contactposition"].Value = emp1.Contactposition;
cmd.Parameters.Add(new SqlParameter("@Rschet", SqlDbType.NVarChar, 50));
cmd.Parameters["@Rschet"].Value = emp1.Rschet;
cmd.Parameters.Add(new SqlParameter("@Contactphone", SqlDbType.NVarChar, 20));
cmd.Parameters["@Contactphone"].Value = emp1.Contactphone;
cmd.Parameters.Add(new SqlParameter("@Orgschet", SqlDbType.NVarChar, 100));
cmd.Parameters["@Orgschet"].Value = emp1.Orgschet;
cmd.Parameters.Add(new SqlParameter("@Bikbank", SqlDbType.NVarChar, 50));
cmd.Parameters["@Bikbank"].Value = emp1.Bikbank;
cmd.Parameters.Add(new SqlParameter("@Inn", SqlDbType.NVarChar, 50));
cmd.Parameters["@Inn"].Value = emp1.Inn;
cmd.Parameters.Add(new SqlParameter("@Kpp", SqlDbType.NVarChar, 50));
cmd.Parameters["@Kpp"].Value = emp1.Kpp;
cmd.Parameters.Add(new SqlParameter("@Ogrn", SqlDbType.NVarChar, 50));
cmd.Parameters["@Ogrn"].Value = emp1.Ogrn;
cmd.Parameters.Add(new SqlParameter("@Okpo", SqlDbType.NVarChar, 50));
cmd.Parameters["@Okpo"].Value = emp1.Okpo;
cmd.Parameters.Add(new SqlParameter("@OrganizationID", SqlDbType.Int, 4));
cmd.Parameters["@OrganizationID"].Direction = ParameterDirection.Output;
try
{
con.Open();
cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@OrganizationID"].Value;
}
catch
{
throw new ApplicationException("Ошибка данныx.");
}
finally
{
con.Close();
}
}
