public string updateCommonArea(CommonArea area)
{
string msg = "";
try
{
if (area.commonAreaId.Equals(""))
{
msg = "Id de area comun no valido";
}
else
{
var existeArea = data.getCommonAreaList().Any(x => x.commonAreaId == area.commonAreaId);
if (existeArea)
{
area.Validar();
data.updateCommonArea(area);
msg = "Area comun actualizada con éxito";
}
else
{
msg = "¡Area comun no existe!";
}
}
}
catch (Exception ex)
{
msg = "Error al actualizar area comun" + ex.Message;
}
return(msg);
}
public async Task <IActionResult> Edit(int id, [Bind("CommonAreaId,Name")] CommonArea commonArea)
{
if (id != commonArea.CommonAreaId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(commonArea);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CommonAreaExists(commonArea.CommonAreaId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(commonArea));
}
public List <CommonArea> getCommonAreasByPreference(string param)
{
List <CommonArea> list = null;
connection.Open();
var statement = "sp_getCommonAreaByPreference";
SqlCommand cmd = new SqlCommand(statement, connection);
cmd.Parameters.AddWithValue("@param", param);
SqlDataReader reader = cmd.ExecuteReader();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (reader.HasRows)
{
CommonArea commonArea = new CommonArea();
while (reader.Read())
{
commonArea.commonAreaId = reader["codigoAreaComun"].ToString();
commonArea.commonAreaName = reader["nombreAreaComun"].ToString();
commonArea.commonAreaDescription = reader["descripcionAreaComun"].ToString();
commonArea.commonAreaStatusId = int.Parse(reader[""].ToString());
list.Add(commonArea);
}
}
connection.Close();
return(list);
}
private async void TimerToDealWithPassengers(CommonArea area, int flightNumber)
{
Console.WriteLine($"Flight number {flightNumber} is in terminal {area.AreaNumber} and it's loading passengers");
await Task.Delay(area.SpendingMinutes);
//area.IsAvailable = true;
}
public CommonAreaDbSeed(SgConContext context) : base(context)
{
if (!context.CommonAreas.Any())
{
List <CommonArea> commonArea = new List <CommonArea>();
CommonArea commonAreaOne = new CommonArea {
Id = 1,
CondominiumId = 1,
Name = "Área 1",
Description = "Área de lazer 1",
Capacity = 20,
IntervalTime = 60
};
commonArea.Add(commonAreaOne);
CommonArea commonAreaTwo = new CommonArea
{
Id = 2,
CondominiumId = 1,
Name = "Área 2",
Description = "Área de lazer 2",
Capacity = 20,
IntervalTime = 30
};
commonArea.Add(commonAreaTwo);
context.AddRange(commonArea);
context.SaveChanges();
}
}
public string updateCommonArea(CommonArea area)
{
string msg = "";
msg = commonAreaBusiness.updateCommonArea(area);
return(msg);
}
public CommonArea getAreaById(string param)
{
var list = commonAreaBusiness.getCommonAreaList();
CommonArea area = list.FirstOrDefault(x => x.commonAreaId == param);
return(area);
}
public async Task <IActionResult> Create([Bind("CommonAreaId,Name")] CommonArea commonArea)
{
if (ModelState.IsValid)
{
_context.Add(commonArea);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(commonArea));
}
private async Task TerminalTime(CommonArea area, Flight flight)
{
area.IsAvailable = false;
if (flight.Flow == Flow.LandStatus)
{
UpdateFlightCurrentLocation(flight, flight.CurrentArea);
}
area.FlightNumber = flight.FlightNumber;
flight.CurrentArea = area;
Console.WriteLine($"flight {flight.FlightNumber} is in area {area.AreaNumber}");
await Task.Delay(area.SpendingMinutes);
// Console.WriteLine("------------------------" + area.SpendingMinutes);
}
public string addCommonArea(CommonArea area)
{
string msg = "";
try
{
area.Validar();
data.addCommonArea(area);
msg = "Area comun registrada con éxito";
}
catch (Exception ex)
{
msg = "Error al registrar area comun" + ex.Message;
}
return(msg);
}
public void addCommonArea(CommonArea area)
{
connection.Open();
string sqlStatement = "sp_addCommonArea";
SqlCommand cmd = new SqlCommand(sqlStatement, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@commonAreaId", area.commonAreaId);
cmd.Parameters.AddWithValue("@commonAreaName", area.commonAreaName);
cmd.Parameters.AddWithValue("@commonAreaDescription", area.commonAreaDescription);
cmd.Parameters.AddWithValue("@commonAreaStatusId", area.commonAreaStatusId);
cmd.Parameters.AddWithValue("@commonAreaDayId", area.commonAreaDayId);
cmd.ExecuteNonQuery();
connection.Close();
}
public List <CommonArea> getCommonAreaList()
{
List <CommonArea> commonAreaList = null;
connection.Open();
//crear Sqlstatement y poner el nombre del SP
var sqlStatement = "sp_getCommonAreaList";
//crear command y asignarle los parametros del statement más la conexion
SqlCommand cmd = new SqlCommand(sqlStatement, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//crear el reader y ejecutar el command
SqlDataReader reader = cmd.ExecuteReader();
//abrir la conexion
//verificar que tenga filas para leer con un if statement
if (reader.HasRows)
{
//inicializamos la lista de trabajadores
commonAreaList = new List <CommonArea>();
//se lee el arreglo en un while block
while (reader.Read())
{
//se instancia una variable de clase Trabajador
CommonArea commonArea = new CommonArea();
// se parsean mediante el reader los atributos de la tabla tb_trabajador
commonArea.commonAreaId = reader["codigoAreaComun"].ToString();
commonArea.commonAreaName = reader["nombreAreaComun"].ToString();
commonArea.commonAreaDescription = reader["descripcionAreaComun"].ToString();
commonArea.commonAreaStatusId = int.Parse(reader["codigoEstado"].ToString());
commonArea.commonAreaStatusDes = reader["descripcionEstado"].ToString();
commonArea.commonAreaDayId = int.Parse(reader["codDia"].ToString());
commonArea.commonAreaDayDes = reader["desDia"].ToString();
//se agrega a la lista workersList
commonAreaList.Add(commonArea);
}
}
//cerrar la conexion
connection.Close();
return(commonAreaList);
}
public Scheduler()
{
_area6 = Process.GetTerminal(6);
_area7 = Process.GetTerminal(7);
}
public View(string PreviousDate, string CurrentDate, string Month, Calculation2 f)
{
InitializeComponent();
Owner = f;
this.PD = PreviousDate;
this.CD = CurrentDate;
this.M = Month;
Month_textbox.Text = M;
Month1_textbox.Text = M;
var Sql = "SELECT MAX(date_Tarif) AS date_Tarif FROM kursach.Tarif WHERE date_Tarif <= '" + CD + "'";
var con = new Connection().Connect();
if (con == null)
{
return;
}
var command = new Connection().Command(Sql, con);
var Reader = command.ExecuteReader();
Reader.Read();
var FindDate = Reader.GetDateTime(0).ToString();
string[] separators = { " 0:00:00" };
FindDate = FindDate.Split(separators, StringSplitOptions.None)[0];
DateTime parsed;
parsed = DateTime.Parse(FindDate);
FindDate = parsed.ToString("yyyy-MM-dd");
Reader.Close();
Sql = "SELECT flat_Tarif, OC FROM kursach.Tarif WHERE date_Tarif = '" + FindDate + "';";
con = new Connection().Connect();
command = new MySqlCommand(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
Tarif = Convert.ToDecimal(Reader.GetValue(0));
TarifOs = Convert.ToDecimal(Reader.GetValue(1));
Reader.Close();
con = new Connection().Connect();
if (con == null)
{
return;
}
Sql = "SELECT flat_number, fio_tenant FROM kursach.tenants;";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
foreach (DbDataRecord record in Reader)
{
flats.Add(record.GetValue(0).ToString());
tenants.Add(record.GetValue(1).ToString());
}
Reader.Close();
con = new Connection().Connect();
if (con == null)
{
return;
}
Sql = "SELECT MAX(date_os) AS date_os FROM kursach.pokazanyia_os WHERE scht_id = 'лифт' AND date_os <= '" +
CD + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
var FindDateMax = Reader.GetDateTime(0).ToString();
FindDateMax = FindDateMax.Split(separators, StringSplitOptions.None)[0];
parsed = DateTime.Parse(FindDateMax);
FindDateMax = parsed.ToString("yyyy-MM-dd");
Reader.Close();
con = new Connection().Connect();
if (con == null)
{
return;
}
Sql = "SELECT MIN(date_os) AS date_os FROM kursach.pokazanyia_os WHERE scht_id = 'лифт' AND date_os >= '" +
PD + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
var FindDateMin = Reader.GetDateTime(0).ToString();
FindDateMin = FindDateMin.Split(separators, StringSplitOptions.None)[0];
parsed = DateTime.Parse(FindDateMin);
FindDateMin = parsed.ToString("yyyy-MM-dd");
Reader.Close();
Sql = "SELECT pokazanyia FROM kursach.pokazanyia_os WHERE scht_id = 'лифт' AND date_os = '" + FindDateMax + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
var MaxOs = Convert.ToInt32(Reader.GetValue(0));
Reader.Close();
Sql = "SELECT pokazanyia FROM kursach.pokazanyia_os WHERE scht_id = 'лифт' AND date_os = '" + FindDateMin + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
var MinOs = Convert.ToInt32(Reader.GetValue(0));
Reader.Close();
LiftDifference_textbox.Text = (MaxOs - MinOs).ToString();
LiftPay_textbox.Text = (Decimal.Round((MaxOs - MinOs) * TarifOs, 2)).ToString();
con = new Connection().Connect();
if (con == null)
{
return;
}
Sql = "SELECT MAX(date_os) AS date_os FROM kursach.pokazanyia_os WHERE scht_id = 'дом' AND date_os <= '" +
CD + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
FindDateMax = Reader.GetDateTime(0).ToString();
FindDateMax = FindDateMax.Split(separators, StringSplitOptions.None)[0];
parsed = DateTime.Parse(FindDateMax);
FindDateMax = parsed.ToString("yyyy-MM-dd");
Reader.Close();
con = new Connection().Connect();
if (con == null)
{
return;
}
Sql = "SELECT MIN(date_os) AS date_os FROM kursach.pokazanyia_os WHERE scht_id = 'дом' AND date_os >= '" +
PD + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
FindDateMin = Reader.GetDateTime(0).ToString();
FindDateMin = FindDateMin.Split(separators, StringSplitOptions.None)[0];
parsed = DateTime.Parse(FindDateMin);
FindDateMin = parsed.ToString("yyyy-MM-dd");
Reader.Close();
Sql = "SELECT pokazanyia FROM kursach.pokazanyia_os WHERE scht_id = 'дом' AND date_os = '" + FindDateMax + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
MaxOs = Convert.ToInt32(Reader.GetValue(0));
Reader.Close();
Sql = "SELECT pokazanyia FROM kursach.pokazanyia_os WHERE scht_id = 'дом' AND date_os = '" + FindDateMin + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
MinOs = Convert.ToInt32(Reader.GetValue(0));
Reader.Close();
HouseDifference_textbox.Text = (MaxOs - MinOs).ToString();
HousePay_textbox.Text = (Decimal.Round((MaxOs - MinOs) * TarifOs, 2)).ToString();
con = new Connection().Connect();
if (con == null)
{
return;
}
Sql = "SELECT MAX(date_os) AS date_os FROM kursach.pokazanyia_os WHERE scht_id = 'кв' AND date_os <= '" +
CD + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
FindDateMax = Reader.GetDateTime(0).ToString();
FindDateMax = FindDateMax.Split(separators, StringSplitOptions.None)[0];
parsed = DateTime.Parse(FindDateMax);
FindDateMax = parsed.ToString("yyyy-MM-dd");
Reader.Close();
con = new Connection().Connect();
if (con == null)
{
return;
}
Sql = "SELECT MIN(date_os) AS date_os FROM kursach.pokazanyia_os WHERE scht_id = 'кв' AND date_os >= '" +
PD + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
FindDateMin = Reader.GetDateTime(0).ToString();
FindDateMin = FindDateMin.Split(separators, StringSplitOptions.None)[0];
parsed = DateTime.Parse(FindDateMin);
FindDateMin = parsed.ToString("yyyy-MM-dd");
Reader.Close();
Sql = "SELECT pokazanyia FROM kursach.pokazanyia_os WHERE scht_id = 'кв' AND date_os = '" + FindDateMax + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
MaxOs = Convert.ToInt32(Reader.GetValue(0));
Reader.Close();
Sql = "SELECT pokazanyia FROM kursach.pokazanyia_os WHERE scht_id = 'кв' AND date_os = '" + FindDateMin + "'";
command = new Connection().Command(Sql, con);
Reader = command.ExecuteReader();
Reader.Read();
MinOs = Convert.ToInt32(Reader.GetValue(0));
Reader.Close();
FlatDifference_textbox.Text = (MaxOs - MinOs).ToString();
FlatPay_textbox.Text = (Decimal.Round((MaxOs - MinOs) * TarifOs, 2)).ToString();
SumDifference_textbox.Text = (Convert.ToInt32(FlatDifference_textbox.Text) +
Convert.ToInt32(LiftDifference_textbox.Text) +
Convert.ToInt32(HouseDifference_textbox.Text)).ToString();
SumPay_textbox.Text = Decimal.Round(Convert.ToDecimal(LiftPay_textbox.Text)
+ Convert.ToDecimal(HousePay_textbox.Text)
+ Convert.ToDecimal(FlatPay_textbox.Text), 2).ToString();
size = flats.Count / 2;
IndexPage = 1;
index = 0;
Page_textbox.Text = IndexPage.ToString() + '/' + size.ToString();
decimal Sum = 0;
decimal SumPay = 0;
for (int i = 0; i < Convert.ToInt32(flats.Count); i++)
{
results.Add(FindMax(flats[i]) - FindMin(flats[i]));
Sum += results[i];
SumPay += results[i] * Tarif;
}
SumPay = Decimal.Round(SumPay, 2);
CommonArea = Settings.Default.AreaSize;
CommonArea_textbox.Text = CommonArea.ToString();
PerMeter = Decimal.Round((Convert.ToDecimal(SumPay_textbox.Text) - SumPay) / CommonArea, 2);
DiffPay_textbox.Text = SumPay.ToString();
DiffSum_textbox.Text = Sum.ToString();
PerMeter_textbox.Text = PerMeter.ToString();
for (int i = 0; i < Convert.ToInt32(flats.Count); i++)
{
CommonLight.Add(results[i] * PerMeter);
FlatsAreas.Add(GetArea(flats[i]));
SetSumm(tenants[i], i);
}
SetResults();
}
