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