public bool SavePayment(PaymentEnt pay)
{
bool guardado = false; //bandera
int x = 0; //variable de control
sb.Clear();
sb.Append("INSERT INTO payment ");
sb.Append("(id_costumer,date,total,iva,payment_method,subtotal)");
sb.Append(" VALUES('" + pay.Id_costumer + "','" + pay.Date.ToString("yyyy-MM-dd HH:mm:ss") + "','" + pay.Total + "','" + pay.Iva + "','" + pay.Payment_method + "','" + pay.Subtotal + "');");
try
{
con.AbrirCOnexion();
x = con.Ejecutar(CommandType.Text, sb.ToString());
if (x > 0)
{
guardado = true;
var ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Info, ButtonsType.Ok, "Se guardo el pago con exito!");
ms.Run();
ms.Destroy();
}
return(guardado);
}
catch (Exception e)
{
var ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Error, ButtonsType.Ok, e.Message);
ms.Run();
ms.Destroy();
throw;
}
finally
{
con.CerrarConexion();
}
}//fin del metodo
public bool SaveCourse(Course cour)
{
bool guardado = false; //bandera
int x = 0; //variable de control
sb.Clear();
sb.Append("INSERT INTO course ");
sb.Append("(name,description)");
sb.Append(" VALUES('" + cour.Name + "','" + cour.Description + "')");
try
{
con.AbrirCOnexion();
x = con.Ejecutar(CommandType.Text, sb.ToString());
if (x > 0)
{
guardado = true;
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Info, ButtonsType.Ok, "Se guardo el curso con exito!!!");
ms.Run();
ms.Destroy();
}
return(guardado);
}
catch (Exception e)
{
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Error, ButtonsType.Ok, e.Message);
ms.Run();
ms.Destroy();
throw;
}
finally
{
con.CerrarConexion();
}
}//fin del metodo
public bool SaveService(CourseService tservices)
{
bool guardado = false; //bandera
int x = 0; //variable de control
sb.Clear();
sb.Append("INSERT INTO course_service ");
sb.Append("(id_course,name,price,state)");
sb.Append(" VALUES('" + tservices.Id_course_operating + "','" + tservices.Name + "','" + tservices.Price + "','" + 1 + "')");
try
{
con.AbrirCOnexion();
x = con.Ejecutar(CommandType.Text, sb.ToString());
if (x > 0)
{
guardado = true;
var ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Info, ButtonsType.Ok, "Se guardo el curso con exito!!!");
ms.Run();
ms.Destroy();
}
return(guardado);
}
catch (Exception e)
{
var ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Error, ButtonsType.Ok, e.Message);
ms.Run();
ms.Destroy();
throw;
}
finally
{
con.CerrarConexion();
}
}//fin del metodo
}//fin del metodo
public bool SaveVehicle(escuela_manejo.Vehicle tvehi)
{
bool guardado = false; //bandera
int x = 0; //variable de control
sb.Clear();
sb.Append("INSERT INTO vehicle ");
sb.Append("(id_category,model,brand,plate,color,state)");
sb.Append(" VALUES('" + tvehi.Id_category + "','" + tvehi.Model + "','" + tvehi.Brand + "','" + tvehi.Plate + "','" + tvehi.Color + "','" + tvehi.State + "')");
try
{
con.AbrirCOnexion();
x = con.Ejecutar(CommandType.Text, sb.ToString());
if (x > 0)
{
guardado = true;
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Info, ButtonsType.Ok, "Se guardo el curso con exito!!!");
ms.Run();
ms.Destroy();
}
return(guardado);
}
catch (Exception e)
{
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Error, ButtonsType.Ok, e.Message);
ms.Run();
ms.Destroy();
throw;
}
finally
{
con.CerrarConexion();
}
}//fin del metodo
public bool Saverol(escuela_manejo.Rol trol)
{
bool guardado = false; //bandera
int x = 0; //variable de control
sb.Clear();
sb.Append("INSERT INTO Rol ");
sb.Append("(Rol,state)");
sb.Append(" VALUES('" + trol.Rols + "','" + trol.State + "')");
try
{
con.AbrirCOnexion();
x = con.Ejecutar(CommandType.Text, sb.ToString());
if (x > 0)
{
guardado = true;
///ms = new MessageDialog(null, DialogFlags.Modal,
//MessageType.Info, ButtonsType.Ok, "Se guardo el usuario con exito!!!");
//ms.Run();
//ms.Destroy();
}
return(guardado);
}
catch (Exception e)
{
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Error, ButtonsType.Ok, e.Message);
ms.Run();
ms.Destroy();
throw;
}
finally
{
con.CerrarConexion();
}
}//fin del metodo
public bool SaveCourseOperating(CourseOperating ins)
{
bool guardado = false; //bandera
int x = 0; //variable de control
sb.Clear();
sb.Append("INSERT INTO course_operating ");
sb.Append("(id_course,id_instructor,id_vehicle,id_customer,start_date,end_date)");
sb.Append(" VALUES('" + ins.Id_course + "','" + ins.Id_instructor + "','" + ins.Id_vehicle + "','" + ins.Id_customer + "','" + ins.Start_date + "','" + ins.End_date + "')");
try
{
con.AbrirCOnexion();
x = con.Ejecutar(CommandType.Text, sb.ToString());
if (x > 0)
{
guardado = true;
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Info, ButtonsType.Ok, "Se guardo el curso con exito!!!");
ms.Run();
ms.Destroy();
}
return(guardado);
}
catch (Exception e)
{
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Error, ButtonsType.Ok, e.Message);
ms.Run();
ms.Destroy();
throw;
}
finally
{
con.CerrarConexion();
}
} //fin del metodo
public bool SaveUser(User tus)
{
bool guardado = false; //bandera
int x = 0; //variable de control
sb.Clear();
sb.Append("INSERT INTO User ");
sb.Append("(user,pwd,first_name,last_name,email,state,id,phone)");
sb.Append(" VALUES('" + tus.Username + "','" + tus.Pwd + "','" + tus.First_name + "','" + tus.Last_name + "','" + tus.Email + "','" + tus.State + "','" + tus.Id + "','" + tus.Phone + "')");
try
{
con.AbrirCOnexion();
x = con.Ejecutar(CommandType.Text, sb.ToString());
if (x > 0)
{
guardado = true;
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Info, ButtonsType.Ok, "Se guardo el usuario con exito!!!");
ms.Run();
ms.Destroy();
}
return(guardado);
}
catch (Exception e)
{
ms = new MessageDialog(null, DialogFlags.Modal,
MessageType.Error, ButtonsType.Ok, e.Message);
ms.Run();
ms.Destroy();
throw;
}
finally
{
con.CerrarConexion();
}
}//fin del metodo
