private STATES SelectTarif() { Console.WriteLine("Select your Tariff:"); foreach (Tarif tarif in (Tarif[])Enum.GetValues(typeof(Tarif))) { //TODO: maybe show prices? Console.WriteLine($"{(int)tarif}. {tarif.ToString()}"); } var input = Console.ReadLine(); Tarif intput; //Check if (input == "c") { return(STATES.MENU); } if (!Tarif.TryParse(input, out intput) || !Enum.IsDefined(typeof(Tarif), intput)) { return(STATES.SELECT_TARIF); } //Add to current order currentOrder.Tarif = intput; return(STATES.SELECT_TARIF + 1); }
/// <summary> /// retourne les tarifs d'une librairie. /// </summary> /// <param name="libId"></param> /// <param name="listToReturn"></param> public static void GetTarifByLib(int libId, ref List <Tarif> listToReturn) { StringBuilder sLog = new StringBuilder(); listToReturn.Clear(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (GetTarifByLibId_Result _vTarif in dbEntity.GetTarifByLibId(libId)) { Tarif _tarif = new Tarif(); _tarif.Id = _vTarif.Id; _tarif.DailyPenalty = _vTarif.DailyPenalty; _tarif.Duration = _vTarif.Duration; _tarif.Fee = _vTarif.Fee; _tarif.LibraryId = _vTarif.Library_Id; _tarif.Name = _vTarif.Name; _tarif.Year = _vTarif.Year; listToReturn.Add((_tarif)); } } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
public bool AddTarif(Tarif tarif) { bool result = true; Connect(); try { SqlCommand cmd = new SqlCommand( "INSERT INTO Tarif (Price, Object, Conditions) " + "VALUES (@Price, @Object, @Conditions)", Connection ); cmd.Parameters.AddWithValue("@Price", tarif.Price); cmd.Parameters.AddWithValue("@Object", tarif.Object); cmd.Parameters.AddWithValue("@Conditions", tarif.Conditions); cmd.ExecuteNonQuery(); } catch (Exception ex) { Logger.Log.Error("Ошибка: ", ex); result = false; } finally { Disconnect(); } return(result); }
public List <Tarif> GetAllTarif() { Connect(); List <Tarif> tarifList = new List <Tarif>(); try { SqlCommand command = new SqlCommand("SELECT * FROM Tarif", Connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Tarif tarif = new Tarif(); tarif.Id = Convert.ToInt32(reader["Id"]); tarif.Price = Convert.ToInt32(reader["Price"]); tarif.Object = Convert.ToString(reader["Object"]); tarif.Conditions = Convert.ToString(reader["Conditions"]); tarifList.Add(tarif); } reader.Close(); } catch (Exception ex) { Logger.Log.Error("Ошибка: ", ex); } finally { Disconnect(); } return(tarifList); }
public Tarif valeur_tarif(int IdJ, int Coefficient) { using (SqlConnection connection = new SqlConnection(connectionString)) { string sqlQuery = "Select * from dbo.Tarif where IdJ = " + IdJ + "Coefficient = " + Coefficient; SqlCommand command = new SqlCommand(sqlQuery, connection); command.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = IdJ; connection.Open(); SqlDataReader reader = command.ExecuteReader(); Tarif tarif = new Tarif(); if (reader.HasRows) { while (reader.Read()) { tarif.Coefficient = reader.GetInt32(3); tarif.JourId = reader.GetInt32(4); tarif.IdT = reader.GetInt32(0); tarif.Montant = reader.GetDouble(1); tarif.Type_Tarif = reader.GetString(2); } } return(tarif); } }
public ActionResult Edit(int id, HttpPostedFileBase Foto, Tarif tarif) { try { var tarifs = db.Tarif.Where(x => x.TarifID == id).SingleOrDefault(); if (Foto != null) { if (System.IO.File.Exists(Server.MapPath(tarif.Foto))) { System.IO.File.Delete(Server.MapPath(tarif.Foto)); } WebImage img = new WebImage(Foto.InputStream); FileInfo fotoinfo = new FileInfo(Foto.FileName); string newfoto = Guid.NewGuid().ToString() + fotoinfo.Extension;//uzantısı demek extensıon img.Resize(800, 350); img.Save("~/Uploads/TarifFoto/" + newfoto); tarifs.Foto = "/Uploads/TarifFoto/" + newfoto; tarifs.Malzemeler = tarif.Malzemeler; tarifs.Yapilis = tarif.Yapilis; tarifs.KategoriID = tarif.KategoriID; tarifs.TarifAdi = tarif.TarifAdi; db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); } catch { ViewBag.KategoriId = new SelectList(db.Kategori, "KategoriId", "KategoriAdi", tarif.KategoriID); return(View(tarif)); } }
public int AddEditTarif(Tarif tarif) { string sqlCommand = "spAddEditTarif"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@custno", tarif.custno); parameters.Add("@kdproduct", tarif.kdproduct); parameters.Add("@dst", tarif.dst); parameters.Add("@kdpengiriman", tarif.kdpengiriman); parameters.Add("@discnt", tarif.discnt); parameters.Add("@kilo1", tarif.kilo1); parameters.Add("@kategory", tarif.kategory); parameters.Add("@jns_shipment", tarif.jns_shipment); parameters.Add("@prckilo1", tarif.prckilo1); parameters.Add("@prckilo2", tarif.prckilo2); parameters.Add("@valuta_kurs", tarif.valuta_kurs); parameters.Add("@ctk_hrg", tarif.ctk_hrg); parameters.Add("@kilo_min", tarif.kilo_min); parameters.Add("@xtake", tarif.xtake); parameters.Add("@xlangsam", tarif.xlangsam); parameters.Add("@xnoflat", tarif.xnoflat); parameters.Add("@id", tarif.id); using (SqlCommand cmd = General.GetCommand(sqlCommand, parameters)) { if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } return(cmd.ExecuteNonQuery()); } }
public Festivalier Insert(int JourId, int nbr_personne, string Nom, string Prenom, String Login, string Pwd, Double somme, int FestivalId, int nbr_Jour, int coefficient) { FestivalierDAO festivalierDAO = new FestivalierDAO(); TarifDAO tarifDAO = new TarifDAO(); Tarif tarif = new Tarif(); Festivalier festivalier = new Festivalier(); tarif = tarifDAO.valeur_tarif(JourId, coefficient); somme = tarif.Montant * tarif.Coefficient * nbr_personne * nbr_Jour; using (SqlConnection connection = new SqlConnection(connectionString)) { string sqlQuery = "Insert into Festivalier (Id, Nom, Prenom, Login, Pwd, Nb_Participants, Somme, FestivalId) " + "Values (Id.nextVal, @Nom, @Prenom, @Login, @Pwd, @Nb_Participants, @Somme, @FestiavalId)"; SqlCommand command = new SqlCommand(sqlQuery, connection); command.Parameters["@Nom"].Value = Nom; command.Parameters["@Prenom"].Value = Prenom; command.Parameters["@Login"].Value = Login; command.Parameters["@Pwd"].Value = Pwd; command.Parameters["@Nb_Participants"].Value = nbr_personne; command.Parameters["@Somme"].Value = somme; command.Parameters["@FestivalId"].Value = FestivalId; connection.Open(); command.ExecuteNonQuery(); connection.Close(); festivalier = festivalierDAO.Display_One_Festivalier_Login(Login, FestivalId); return(festivalier); } }
public async Task <IActionResult> Edit(int id, [Bind("IdTarif,TarifHarga")] Tarif tarif) { if (id != tarif.IdTarif) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tarif); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TarifExists(tarif.IdTarif)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(tarif)); }
/// <summary> /// Retourne le tarif d'une bibliothèque (ne prend que le premier). /// </summary> /// <param name="idLib"></param> /// <returns></returns> internal static Tarif getTarif(int idLib) { Tarif _tarifToReturn = new Tarif(); try { using (AffiliateServiceClient _sClient = new AffiliateServiceClient()) { _tarifToReturn = _sClient.GetTarifsByLib(idLib)[0]; } } catch (System.ServiceModel.EndpointNotFoundException endpointEx) { int cstmErrorN = 9; // "End point not found! Vérifiez que le serveur est lancé." CstmError.Display(new CstmError(cstmErrorN, endpointEx)); } catch (System.ServiceModel.FaultException <ServiceReference.CustomFault> Fault) { CstmError.Display(Fault.Message); } catch (CstmError cstmError) { CstmError.Display(cstmError); } catch (Exception e) { CstmError.Display(new CstmError(7, e)); //Un problème est survenu à la récupération des données ! } return(_tarifToReturn); }
public async Task <ActionResult <Tarif> > PostTarif(Tarif tarif) { _context.Tarif.Add(tarif); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTarif", new { id = tarif.IdT }, tarif)); }
public async Task <IActionResult> Update([FromBody] Dto.Tarif updatedTarif) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tarif tarif = await _context.Tarif.FirstOrDefaultAsync(t => t.Service.ToLower().Equals(updatedTarif.Service.ToLower()) && t.RelookeuseId == int.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value)); if (tarif == null) { return(NotFound(updatedTarif.Service)); } tarif.Price = updatedTarif.Price; _context.Entry(tarif).OriginalValues["RowVersion"] = updatedTarif.RowVersion; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { return(Conflict()); } return(Ok(_mapper.Map <Dto.Tarif>(tarif))); }
public async Task <IActionResult> PutTarif(int id, Tarif tarif) { if (id != tarif.IdT) { return(BadRequest()); } _context.Entry(tarif).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TarifExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Update(int Id, DateTime dateJour, int nbr_personne, string Nom, string Prenom, String Login, string Pwd, Double somme, int FestivalId, int Coefficient) { int IdJ; JourDAO jourDAO = new JourDAO(); TarifDAO tarifDAO = new TarifDAO(); Tarif tarif = new Tarif(); IdJ = jourDAO.Id_Jour(dateJour, FestivalId); tarif = tarifDAO.valeur_tarif(IdJ, Coefficient); somme = tarif.Montant * tarif.Coefficient * nbr_personne; using (SqlConnection connection = new SqlConnection(connectionString)) { string sqlQuery = "Update Festivalier (Id, Nom, Prenom, Login, Pwd, Nb_Participants, Somme, FestivalId) " + "Values (Id.nextVal, @Nom, @Prenom, @Login, @Pwd, @Nb_Participants, @Somme, @FestiavalId) where Id = " + Id; SqlCommand command = new SqlCommand(sqlQuery, connection); command.Parameters["@Nom"].Value = Nom; command.Parameters["@Prenom"].Value = Prenom; command.Parameters["@Login"].Value = Login; command.Parameters["@Pwd"].Value = Pwd; command.Parameters["@Nb_Participants"].Value = nbr_personne; command.Parameters["@Somme"].Value = somme; command.Parameters["@FestivalId"].Value = FestivalId; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } }
public IHttpActionResult PutTarif(int id, Tarif tarif) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tarif.TarifId) { return(BadRequest()); } db.Entry(tarif).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TarifExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult TarifDuzenle(int id) { TempData["tarifID"] = id; Tarif t = db.Tarif.Where(x => x.tarifID == id).SingleOrDefault(); TempData["YemekID"] = t.yemekID; return(View(t)); }
// GET: Tarifler public ActionResult Index(int id) { //detay Tarif tr = db.Tarif.SingleOrDefault(x => x.TarifID == id); return(View(tr)); }
public ActionResult DeleteConfirmed(int id) { Tarif tarif = db.Tarifs.Find(id); db.Tarifs.Remove(tarif); db.SaveChanges(); return(RedirectToAction("Index")); }
//Tarif işlemleri public ActionResult TarifEkle(int id) { Tarif t = new Tarif(); t.siraNo = (db.Tarif.Where(x => x.yemekID == id).Count() + 1); t.yemekID = id; TempData["YemekID"] = id; return(View(t)); }
/// <summary> /// Execution de la procedure stocké /// Recupere la liste de tous les equipements par centre /// </summary> /// <param name="num"></param> /// <returns></returns> public List <Equipement> GetEquipementByCentre(int num) { using (DbConnection db = DAOConnection.GetConnexion()) { using (DbCommand cde = db.CreateCommand()) { cde.CommandText = "GetEquipementsByIdCentre"; cde.CommandType = CommandType.StoredProcedure; DbParameter odbP1 = cde.CreateParameter(); odbP1.DbType = System.Data.DbType.String; odbP1.Direction = System.Data.ParameterDirection.Input; odbP1.ParameterName = "@num"; odbP1.Value = num; cde.Parameters.Add(odbP1); List <Equipement> lstEqui = new List <Equipement>(); try { using (DbDataReader reader = cde.ExecuteReader()) { while (reader.Read()) { string numSerie = reader.GetString(0); string nomModele = reader.GetString(1); int numModele = reader.GetInt32(2); decimal tarif = reader.GetDecimal(3); int codetarif = reader.GetInt32(4); string typeE = reader.GetString(5); int idtype = reader.GetInt32(6); DateTime?dt = reader.GetDateTime(7); TypeEquipement te = new TypeEquipement(0, typeE); Tarif Letarif = new Tarif(Convert.ToDouble(tarif), dt); Modele m = new Modele(numModele, nomModele, Letarif, te); Equipement e = new Equipement(m, numSerie); lstEqui.Add(e); } reader.Close(); } } catch (DbException se) { throw new DAOExceptionClient("[DAO] GetClientByName :\n" + se.Message, se); } return(lstEqui); } //End using command } //End using connection }
public ActionResult Edit([Bind(Include = "id_tarif,libelle_tarif,prix_tarif")] Tarif tarif) { if (ModelState.IsValid) { db.Entry(tarif).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tarif)); }
public ActionResult Edit([Bind(Include = "ID,TelDot_A,TelDot_B,Price_D,Price_N")] Tarif tarif) { if (ModelState.IsValid) { db.Entry(tarif).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tarif)); }
public ActionResult Edit([Bind(Include = "Id,HotWater,ColdWater,OtoplenieEnergy,TeplotaVKube,Date")] Tarif tarif) { if (ModelState.IsValid) { db.Entry(tarif).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tarif)); }
public ActionResult Edit(Tarif edit) { if (ModelState.IsValid) { edit.IsActive = Convert.ToBoolean(edit.Activ); db.Entry(edit).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(PartialView(edit)); }
public async Task <IActionResult> Create([Bind("TarifID,Montant,DateApplication,DateFinApplication")] Tarif tarif) { if (ModelState.IsValid) { _context.Add(tarif); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tarif)); }
public IHttpActionResult GetTarif(int id) { Tarif tarif = db.Tarifs.Find(id); if (tarif == null) { return(NotFound()); } return(Ok(tarif)); }
public ActionResult Create([Bind(Include = "id_tarif,libelle_tarif,prix_tarif")] Tarif tarif) { if (ModelState.IsValid) { db.Tarifs.Add(tarif); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tarif)); }
public ActionResult Create([Bind(Include = "ID,TelDot_A,TelDot_B,Price_D,Price_N")] Tarif tarif) { if (ModelState.IsValid) { db.Tarifs.Add(tarif); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tarif)); }
public async Task <IActionResult> Create([Bind("IdTarif,TarifHarga")] Tarif tarif) { if (ModelState.IsValid) { _context.Add(tarif); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tarif)); }
public JsonResult AddEditTarif(Tarif tarif) { if (ModelState.IsValid) { db.AddEditTarif(tarif); } string status = tarif.id != Guid.Empty ? "updated" : "saved"; string message = $"Site / Domain has been {status} successfully"; return(Json(message, JsonRequestBehavior.AllowGet)); }