public static List <Moto> getTodasMotoDB()
{
string queryTemplate = "SELECT moto_id, nombre, descripcion, marca, year, modelo,color, tipo, precio, strock FROM Motos;";
DataTable tableMotos = DataBasePort.getTableQuery(queryTemplate);
List <Moto> result = new List <Moto>();
foreach (DataRow row in tableMotos.Rows)
{
int motoId = Int32.Parse(row["moto_id"].ToString());
string nombre = row["nombre"].ToString();
string descripcion = row["descripcion"].ToString();
string marca = row["marca"].ToString();
int year = Int32.Parse(row["year"].ToString());
string modelo = row["modelo"].ToString();
string tipo = row["tipo"].ToString();
string color = row["color"].ToString();
float price = float.Parse(row["precio"].ToString());
int stock = Int32.Parse(row["strock"].ToString());
Moto moto = new Moto(motoId, nombre, descripcion, marca, year, modelo, tipo, color, price, stock);
result.Add(moto);
}
return(result);
}
public static int getIdByCorreoAndPassword(string correo, string password)
{
string query_text = $"SELECT vendedor_id FROM Vendedores WHERE correo = '{correo}'AND contraseña = '{password}';";
int result = (int)DataBasePort.getScalarQuery(query_text);
return(result);
}
public static bool revisarValidezPassword(string correo, string password)
{
string query_text = $"SELECT 200 FROM Vendedores WHERE correo = '{correo}' AND contraseña = '{password}'";
int result = (int)DataBasePort.getScalarQuery(query_text);
return(result == 200);
}
public static bool revisarExistenciaPorCorreo(string correo)
{
string query_text = $"SELECT 200 FROM Vendedores WHERE correo = '{correo}'";
int result = (int)DataBasePort.getScalarQuery(query_text);
return(result == 200);
}
public void registrarVendedorDb()
{
string query_text = "INSERT INTO Vendedores (nombre, fecha_nacimiento, telefono, correo, direccion, contraseña) VALUES (" +
$"'{nombre}'," +
$"'{fechaNacimento.ToString()}'," +
$"'{telefono}'," +
$"'{correo}'," +
$"'{direccion}'," +
$"'{password}');";
vendedor_id = DataBasePort.insertarDatos(query_text);
}
public void actualizarVendedorDb()
{
string query_text = "UPDATE Vendedores SET " +
$" nombre = '{nombre}'," +
$" fecha_nacimiento = '{fechaNacimento.Date.ToString()}'," +
$" telefono = '{telefono}'," +
$" correo = '{correo}'," +
$" direccion = '{direccion}'," +
$" contraseña = '{password}' WHERE" +
$" vendedor_id = {vendedor_id};";
DataBasePort.actualizarDatos(query_text);
}
public void registrarMotoDB()
{
string query_register = "INSERT INTO Motos (nombre, descripcion, marca, year, modelo,color, tipo, precio, strock) VALUES (" +
$"'{nombre}'," +
$"'{descripcion}'," +
$"'{marca}'," +
$"{year}," +
$"'{modelo}'," +
$"'{color}'," +
$"'{tipo}'," +
$"{price}," +
$"{stock});";
moto_id = DataBasePort.insertarDatos(query_register);
}
public void DBSaveConfig()
{
#region Config Load
ExeConfigurationFileMap fileMap = null;
fileMap = new ExeConfigurationFileMap
{
ExeConfigFilename =
System.IO.Directory.GetCurrentDirectory()
+ "\\SatelliteDataPolling.exe.config"
};
var config = ConfigurationManager.OpenMappedExeConfiguration(fileMap, ConfigurationUserLevel.None);
#endregion
config.AppSettings.Settings["FCSRootDir"].Value = ModisRootDir;
config.AppSettings.Settings["ModisRootDir"].Value = ModisRootDir;
config.AppSettings.Settings["LandSatRootDir"].Value = LandSatRootDir;
config.AppSettings.Settings["AwsDir"].Value = AwsDir;
config.AppSettings.Settings["ReferenceDataPath"].Value = ReferenceDataPath;
config.AppSettings.Settings["GisFilePath"].Value = GisFilePath;
config.AppSettings.Settings["IdlFilePath"].Value = IdlFilePath;
config.AppSettings.Settings["DataBaseIP"].Value = DataBaseIP;
config.AppSettings.Settings["DataBasePort"].Value = DataBasePort.ToString();
config.AppSettings.Settings["DataBaseName"].Value = DataBaseName;
config.AppSettings.Settings["DataBaseID"].Value = DataBaseID;
config.AppSettings.Settings["DataBasePW"].Value = DataBasePW;
config.AppSettings.Settings["DataBaseAwsIP"].Value = DataBaseAwsIP;
config.AppSettings.Settings["DataBaseAwsPort"].Value = DataBaseAwsPort.ToString();
config.AppSettings.Settings["DataBaseAwsName"].Value = DataBaseAwsName;
config.AppSettings.Settings["DataBaseAwsID"].Value = DataBaseAwsID;
config.AppSettings.Settings["DataBaseAwsPW"].Value = DataBaseAwsPW;
config.AppSettings.Settings["DataBaseNewSnowIP"].Value = DataBaseNewSnowIP;
config.AppSettings.Settings["DataBaseNewSnowPort"].Value = DataBaseNewSnowPort.ToString();
config.AppSettings.Settings["DataBaseNewSnowName"].Value = DataBaseNewSnowName;
config.AppSettings.Settings["DataBaseNewSnowID"].Value = DataBaseNewSnowID;
config.AppSettings.Settings["DataBaseNewSnowPW"].Value = DataBaseNewSnowPW;
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("appSettings");
if (SettingClassSaveEvent != null)
{
SettingClassSaveEvent(null, EventArgs.Empty);
}
}
private void ButtonIniciar_Click(object sender, EventArgs e)
{
bool noerrors = true;
foreach (Control c in this.Controls)
{
if (errorProvider.GetError(c).Length > 0)
{
noerrors = false;
}
}
if (noerrors)
{
if (Vendedor.revisarExistenciaPorCorreo(textBoxUsuario.Text))
{
if (Vendedor.revisarValidezPassword(textBoxUsuario.Text, textBoxPassword.Text))
{
string usuario = DataBasePort.user_ID(textBoxUsuario.Text, textBoxPassword.Text);
MessageBox.Show("Se ha iniciado seccion al usuario " + usuario + "", "Bienvenido");
encontrado = true;
vendedor_resultado = Vendedor.getVendedorPorId(Vendedor.getIdByCorreoAndPassword(textBoxUsuario.Text, textBoxPassword.Text).ToString());
this.Close();
}
else
{
MessageBox.Show("La contraseña no es valida");
}
}
else
{
MessageBox.Show("El coreo no es valido");
}
}
else
{
MessageBox.Show("Tiene que llenar los campos correctamente");
}
}
public void realizarVenta(Moto moto, string nombre_cliente, string numero_tarjeta, string metodo_pago)
{
int moto_id = moto.moto_id;
float moto_precio = moto.price;
float IVA = moto_precio * 0.15f;
float Total = moto_precio + IVA;
string registerQuery = "INSERT INTO Ventas (vendedor_id, moto_id, nombre_cliente, numero_tarjeta, metodo_pago, monto, IVA, Total) VALUES (" +
$"{vendedor_id}," +
$"{moto_id}," +
$"'{nombre_cliente}'," +
$"'{numero_tarjeta}'," +
$"'{metodo_pago}'," +
$"{moto_precio}," +
$"{IVA}," +
$"{Total});";
DataBasePort.insertarDatos(registerQuery);
//Disminuir el stock
DataBasePort.actualizarDatos($"UPDATE Motos SET strock = (strock -1) WHERE moto_id = {moto_id}");
}
public static Vendedor getVendedorPorId(string vendedor_id)
{
string query_text = $"SELECT vendedor_id, nombre, CAST(fecha_nacimiento AS text) AS fecha_nacimiento, telefono, correo, direccion, contraseña FROM Vendedores WHERE vendedor_id = '{vendedor_id}';";
DataTable result = DataBasePort.getTableQuery(query_text);
if (result.Rows.Count <= 0)
{
return(null);
}
int id = Int32.Parse(result.Rows[0]["vendedor_id"].ToString());
string nombre = result.Rows[0]["nombre"].ToString();
DateTime fechaNacimiento = DateTime.Now;
string telefono = result.Rows[0]["telefono"].ToString();
string correo = result.Rows[0]["correo"].ToString();
string direccion = result.Rows[0]["direccion"].ToString();
string contraseña = result.Rows[0]["contraseña"].ToString();
Vendedor encontrado = new Vendedor(id, nombre, fechaNacimiento, correo, telefono, direccion, contraseña);
return(encontrado);
}
public void SaveConfig()
{
#region Config Load
ExeConfigurationFileMap fileMap = null;
fileMap = new ExeConfigurationFileMap
{
ExeConfigFilename =
System.IO.Directory.GetCurrentDirectory()
+ "\\SatelliteDataPolling.exe.config"
};
var config = ConfigurationManager.OpenMappedExeConfiguration(fileMap, ConfigurationUserLevel.None);
#endregion
config.AppSettings.Settings["IsFileCreated"].Value = IsFileCreated.ToString();
config.AppSettings.Settings["Mode"].Value = ((int)Mode).ToString();
config.AppSettings.Settings["FCSRootDir"].Value = ModisRootDir;
config.AppSettings.Settings["ModisRootDir"].Value = ModisRootDir;
config.AppSettings.Settings["LandSatRootDir"].Value = LandSatRootDir;
config.AppSettings.Settings["AutoFlag"].Value = AutoFlag.ToString();
config.AppSettings.Settings["GisFilePath"].Value = GisFilePath;
#region DB
config.AppSettings.Settings["DataBaseIP"].Value = DataBaseIP;
config.AppSettings.Settings["DataBasePort"].Value = DataBasePort.ToString();
config.AppSettings.Settings["DataBaseName"].Value = DataBaseName;
config.AppSettings.Settings["DataBaseID"].Value = DataBaseID;
config.AppSettings.Settings["DataBasePW"].Value = DataBasePW;
config.AppSettings.Settings["DataBaseAwsIP"].Value = DataBaseAwsIP;
config.AppSettings.Settings["DataBaseAwsPort"].Value = DataBaseAwsPort.ToString();
config.AppSettings.Settings["DataBaseAwsName"].Value = DataBaseAwsName;
config.AppSettings.Settings["DataBaseAwsID"].Value = DataBaseAwsID;
config.AppSettings.Settings["DataBaseAwsPW"].Value = DataBaseAwsPW;
config.AppSettings.Settings["DataBaseNewSnowIP"].Value = DataBaseNewSnowIP;
config.AppSettings.Settings["DataBaseNewSnowPort"].Value = DataBaseNewSnowPort.ToString();
config.AppSettings.Settings["DataBaseNewSnowName"].Value = DataBaseNewSnowName;
config.AppSettings.Settings["DataBaseNewSnowID"].Value = DataBaseNewSnowID;
config.AppSettings.Settings["DataBaseNewSnowPW"].Value = DataBaseNewSnowPW;
#endregion
#region 폭설
config.AppSettings.Settings["AwsDir"].Value = AwsDir;
config.AppSettings.Settings["IdlFilePath"].Value = IdlFilePath;
config.AppSettings.Settings["SnowMode"].Value = ((int)SnowModeSet).ToString();
config.AppSettings.Settings["InPutFilePathMOD03"].Value = InPutFilePathMOD03;
config.AppSettings.Settings["InPutFilePathMOD21"].Value = InPutFilePathMOD21;
config.AppSettings.Settings["ResultPath"].Value = ResultPath;
config.AppSettings.Settings["ReferenceDataPath"].Value = ReferenceDataPath;
config.AppSettings.Settings["MinTemperature"].Value = MinTemperature.ToString();
config.AppSettings.Settings["MaxTemperature"].Value = MaxTemperature.ToString();
config.AppSettings.Settings["Humidity"].Value = Humidity.ToString();
config.AppSettings.Settings["Building_Temperature"].Value = Building_Temperature.ToString();
config.AppSettings.Settings["Building_Humidity"].Value = Building_Humidity.ToString();
config.AppSettings.Settings["AnimalPlant_Temperature"].Value = AnimalPlant_Temperature.ToString();
config.AppSettings.Settings["AnimalPlant_Humidity"].Value = AnimalPlant_Humidity.ToString();
#endregion
#region 가뭄 LANDSAT
config.AppSettings.Settings["LandSatSatelliteImagePath"].Value = LandSatSatelliteImagePath;
config.AppSettings.Settings["LandSatMaskImagePath"].Value = LandSatMaskImagePath;
config.AppSettings.Settings["DamShapeDataPath"].Value = DamShapeDataPath;
config.AppSettings.Settings["LandSatResultPath"].Value = LandSatResultPath;
#endregion
#region 가뭄 MODIS
config.AppSettings.Settings["ModisLandAnalysisResultPath"].Value = ModisLandAnalysisResultPath;
config.AppSettings.Settings["MOD11A2InputPath"].Value = MOD11A2InputPath;
config.AppSettings.Settings["MOD13A2InputPath"].Value = MOD13A2InputPath;
config.AppSettings.Settings["ModisAlgorithmPath"].Value = ModisAlgorithmPath;
config.AppSettings.Settings["ManualGpmPath"].Value = ManualGpmPath;
#endregion
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("appSettings");
if (SettingClassSaveEvent != null)
{
SettingClassSaveEvent(null, EventArgs.Empty);
}
}
public static List <string> getNombresVendedores()
{
string query_text = "SELECT nombre FROM Vendedores;";
return(DataBasePort.getListOfStringQuery(query_text));
}
