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));
}
