/// <summary>
/// Добавление новой записи Busines в базу
/// </summary>
/// <param name="item">Модель данных</param>
internal static void AddBusines(Busines item)
{
try
{
string sql = "INSERT INTO Busines (Id, OrganizationName, INNCode, StatusId, CityId, FIO, PositionName)" +
" VALUES (@Id, @OrganizationName, @INNCode, @StatusId, @CityId, @FIO, @PositionName)";
ConnectionClient.ConOpen();
using (SqlCommand cmd = new SqlCommand(sql, ConnectionClient.connection))
{
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.Parameters.AddWithValue("@OrganizationName", item.OrganizationName);
cmd.Parameters.AddWithValue("@INNCode", item.INNCode);
cmd.Parameters.AddWithValue("@StatusId", item.StatusId);
cmd.Parameters.AddWithValue("@CityId", item.CityId);
cmd.Parameters.AddWithValue("@FIO", item.FIO);
cmd.Parameters.AddWithValue("@PositionName", item.PositionName);
cmd.ExecuteNonQuery();
ConnectionClient.connection.Close();
}
}
catch (SqlException e) { errorMes.ErrorSQL(e.Message); }
catch (Exception e) { errorMes.ErrorSQL(e.Message); }
finally { ConnectionClient.ConClose(); }
}
public void AddOperator(MobileOperatorModel mobileOperatorModel)
{
MobileOperator mobileOperator = new MobileOperator();
mobileOperator.OperatorName = mobileOperatorModel.OperatorName;
mobileOperator.OperatorRating = mobileOperatorModel.OperatorRating;
Busines busines = new Busines();
busines.AddOperator(mobileOperator);
}
public void AddCustomer(CustomerModel customerModel)
{
Customer customer = new Customer();
customer.CustomerName = customerModel.CustomerName;
customer.OperatorId = new MobileOperator();
customer.OperatorId.OperatorId = customerModel.OperatorId.OperatorId;
Busines busines = new Busines();
busines.AddCustomer(customer);
}
/// <summary>
/// Добавление/обновление данных юр.лиц
/// </summary>
/// <param name="model">Модель данных</param>
public void EditCustom(Busines model)
{
if (model.Id == 0)
{
model.Id = IdGenarator();
busines.Add(model);
DataWork.AddData.AddBusines(model);
CustomersList.Add(CustomFactory.GetCustomerFactory(model));
}
else
{
var itemcustomer = CustomersList.Single(s => s.Id == model.Id);
itemcustomer.Changed(model);
DataWork.UpdateData.UpdateBusines(model);
}
}
/// <summary>
/// Обновление данных Busines
/// </summary>
/// <param name="item">Модель обновленных данных</param>
internal static void UpdateBusines(Busines item)
{
try
{
string sql = string.Format($"UPDATE Busines SET StatusId = @StatusId, OrganizationName = @OrganizationName, INNCode = @INNCode, CityId = @CityId, FIO = @FIO, PositionName = @PositionName WHERE Id = @Id");
ConnectionClient.ConOpen();
using (SqlCommand cmd = new SqlCommand(sql, ConnectionClient.connection))
{
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.Parameters.AddWithValue("@OrganizationName", item.OrganizationName);
cmd.Parameters.AddWithValue("@INNCode", item.INNCode);
cmd.Parameters.AddWithValue("@StatusId", item.StatusId);
cmd.Parameters.AddWithValue("@CityId", item.CityId);
cmd.Parameters.AddWithValue("@FIO", item.FIO);
cmd.Parameters.AddWithValue("@PositionName", item.PositionName);
cmd.ExecuteNonQuery();
ConnectionClient.ConClose();
}
}
catch (SqlException e) { errorMes.ErrorSQL(e.Message); }
catch (Exception e) { errorMes.ErrorSQL(e.Message); }
finally { ConnectionClient.ConClose(); }
}
/// <summary>
/// Загрузка списка ую.лиц
/// </summary>
private static void DataBusines()
{
try
{
string sql = "SELECT * FROM Busines";
ConnectionClient.ConOpen();
using (SqlCommand commmand = new SqlCommand(sql, ConnectionClient.connection))
{
SqlDataReader reader = commmand.ExecuteReader();
while (reader.Read())
{
Busines busines = new Busines((int)reader["Id"], (string)reader["OrganizationName"],
(long)reader["INNCode"], (int)reader["StatusId"], (int)reader["CityId"], (string)reader["FIO"], (string)reader["PositionName"]);
Repository.busines.Add(busines);
customersLoad.Add(CustomFactory.GetCustomerFactory(busines));
}
ConnectionClient.ConClose();
}
}
catch (SqlException e) { errorMes.ErrorSQL(e.Message); }
catch (Exception e) { errorMes.ErrorSQL(e.Message); }
finally { ConnectionClient.ConClose(); }
}
/// <summary>
/// Загрузка данных юр.лико (клиента)
/// </summary>
/// <param name="id">ИД Клиента</param>
/// <returns>Модель с данными клиента</returns>
public static Busines GetBusinesId(int id)
{
Busines item = busines.Single(s => s.Id == id);
return(item);
}
