public void GetClientsForTheBookTest()
{
IDataFiller constantDataFiller = new ConstantDataFiller();
IDataRepository dataRepository = new DataRepositoryForTest(constantDataFiller);
IDataService dataService = new DataService(dataRepository);
Book book = dataRepository.GetBook(3);
ImmutableHashSet <Client> clients = dataService.GetClientsForTheBook(book).ToImmutableHashSet();
IEnumerable <Event> events = dataService.GetEventsForTheBook(book);
foreach (Event e in events)
{
Reclamation r = e as Reclamation;
Invoice i = e as Invoice;
if (i != null)
{
Assert.Contains(i.Client, clients);
}
else
{
Assert.Contains(r.Invoice.Client, clients);
}
}
}
public async Task <IActionResult> PutReclamation(Guid id, Reclamation reclamation)
{
if (id != reclamation.Id)
{
return(BadRequest());
}
_context.Entry(reclamation).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ReclamationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public UsgsRealTimeSeries(TimeSeriesDatabase db,Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db,sr)
{
var p = ConnectionStringUtility.GetToken(ConnectionString,"UsgsParameter","");
m_parameter = (UsgsRealTimeParameter)Enum.Parse(typeof(UsgsRealTimeParameter), p);
m_site_no = ConnectionStringToken( "site_no");
}
public IEnumerable <Event> GetEventsForTheClient(Client client)
{
return(GetEvents().Where(eEvent =>
{
Reclamation r = eEvent as Reclamation;
Invoice i = eEvent as Invoice;
if (r != null)
{
if (r.Invoice.Client.Email.Equals(client.Email))
{
return true;
}
else
{
return false;
}
}
else
{
if (i.Client.Email.Equals(client.Email))
{
return true;
}
else
{
return false;
}
}
}
));
}
/// <summary>
/// Used to create ModsimSeries from TimeSeriesDatabase
/// </summary>
public ModsimSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
m_defaultUnits = Units;
m_xyFilename = ConnectionStringUtility.GetFileName(ConnectionString, db.DataSource);
m_mdbFilename = Path.ChangeExtension(m_xyFilename, null) + "OUTPUT.mdb";
m_accdbFilename = Path.ChangeExtension(m_xyFilename, null) + "OUTPUT.accdb";
if (File.Exists(m_accdbFilename))
{
m_databaseName = m_accdbFilename;
}
else
m_databaseName = m_mdbFilename;
if (File.Exists(m_xyFilename))
{
StreamReader srr = File.OpenText(m_xyFilename);
string line1 = srr.ReadLine();
string[] line1Parts = line1.Split(' ');
m_xyFileVersion = new Version(line1Parts[1]);
srr.Close();
}
else
{
Logger.WriteLine("Error: File missing " + m_xyFilename);
}
ScenarioName = Path.GetFileNameWithoutExtension(m_xyFilename);
ExternalDataSource = true;
modsimName = ConnectionStringToken("ModsimName");
timeSeriesName = ConnectionStringToken("TimeSeriesName");
ReadOnly = true;
}
public ActionResult Edit(int id, rec r1)
{
try
{
if (ModelState.IsValid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reclamation recl = rs.GetById(id);
recl.objet = r1.objet;
recl.contenu = r1.contenu;
recl.status = r1.status;
recl.type = r1.type;
recl.dateDebut = r1.dateDebut;
recl.dateFin = r1.dateFin;
if (recl == null)
{
return(HttpNotFound());
}
rs.Update(recl);
rs.Commit();
return(RedirectToAction("Index"));
}
return(View(r1));
}
catch
{
return(View("~/Views/Shared/Customer.cshtml"));
}
}
public async Task <ActionResult <Reclamation> > PostReclamation(Reclamation reclamation)
{
_context.Reclamation.Add(reclamation);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetReclamation", new { id = reclamation.Id }, reclamation));
}
//status refusée
public ActionResult refuser(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reclamation r = rs.GetById(id);
r.status = "refusée";
if (r == null)
{
return(HttpNotFound());
}
rs.Update(r);
rs.Commit();
return(RedirectToAction("Index"));
// TODO: Add delete logic her
}
// PUT: api/EventWebApi/5
public IHttpActionResult Put(Reclamation student)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new MyContext())
{
var existingStudent = ctx.Reclamations.Where(s => s.Id == student.Id)
.FirstOrDefault <Reclamation>();
if (existingStudent != null)
{
existingStudent.Nom = student.Nom;
existingStudent.Prenom = student.Prenom;
existingStudent.Telephone = student.Telephone;
existingStudent.Type = student.Type;
existingStudent.Email = student.Email;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public async Task <IHttpActionResult> PutReclamation(int id, Reclamation reclamation)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != reclamation.IdReclamation)
{
return(BadRequest());
}
db.Entry(reclamation).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ReclamationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create(Reclamation r, int idUser)
{
try
{
Models.User u = new Models.User();
u.id = idUser;
r.user = u;
r.dateReclamation = null;
Console.WriteLine(r);
HttpClient Client = new HttpClient();
HttpResponseMessage response = Client.PostAsJsonAsync <Reclamation>("http://localhost:18080/PI_OTDAV_4GL5B-web/api/reclamations/add", r).ContinueWith((postTask) => postTask.Result.EnsureSuccessStatusCode()).Result;
if (response.IsSuccessStatusCode)
{
//Add Notif
user utilisateur = us.GetById(idUser);
Notification n = new Notification();
n.description = "L'utilisateur " + utilisateur.FirstName + " " + utilisateur.LastName + " a ajouté une réclamation de type:" + r.type + ".";
n.type = "Réclamation";
nc.Create(n, idUser);
//End Add Notif
SendMail(idUser);
return(RedirectToAction("Display", new { idUser = idUser }));
}
else
{
return(View());
}
}
catch
{
return(View());
}
}
public IEnumerable <Event> GetEventsForTheBook(Book book)
{
return(GetEvents().Where(eEvent =>
{
Reclamation r = eEvent as Reclamation;
Invoice i = eEvent as Invoice;
if (r != null)
{
if (r.Invoice.CopyDetails.Book.Equals(book))
{
return true;
}
else
{
return false;
}
}
else
{
if (i.CopyDetails.Book.Equals(book))
{
return true;
}
else
{
return false;
}
}
}
));
}
public void ModifyDatabase(Reclamation.TimeSeries.TimeSeriesDatabase db, PiscesFolder selectedFolder)
{
var dlg = new ImportCorpsDataQuery();
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
var s = new Usace.UsaceSeries(dlg.DssPath);
db.AddSeries(s, selectedFolder);
}
}
public ActionResult Create(Reclamation rec)
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("https://localhost:8091");
client.PostAsJsonAsync <Reclamation>("http://localhost:8091/reclamation/save-reclamation", rec).ContinueWith((postTask) => postTask.Result.EnsureSuccessStatusCode());
return(RedirectToAction("Index"));
}
public FileImporter(Reclamation.TimeSeries.TimeSeriesDatabase db,
DatabaseSaveOptions saveOption= DatabaseSaveOptions.UpdateExisting)
{
m_saveOption = saveOption;
m_db = db;
if( ConfigurationManager.AppSettings["ValidLoggerNetPcodes"] != null)
validPcodes = ConfigurationManager.AppSettings["ValidLoggerNetPcodes"].Split(',');
if (ConfigurationManager.AppSettings["ValidLoggerNetSites"] != null)
validSites = ConfigurationManager.AppSettings["ValidLoggerNetSites"].Replace(" ", "").Replace("\r\n", "").Split(',');
}
public void DeleteReclamation(object sender, EventArgs e)
{
LinkButton source = (LinkButton)sender;
int reclId = Int32.Parse(source.ID.Remove(0, 3));
Reclamation reclam = usr.Reclamations.Find(reclId);
usr.Reclamations.Remove(reclam);
usr.SaveChanges();
Page_Load(sender, e);
}
public ActionResult Create(Reclamation reclamation)
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("http://localhost:8082/SpringMVC/");
_ = client.PostAsJsonAsync <Reclamation>("servlet/ajouterReclamation", reclamation).ContinueWith((postTask) => postTask.Result.EnsureSuccessStatusCode());
return(RedirectToAction("Index"));
}
// GET: api/getRecmlamation/1
public IHttpActionResult GetOneReclamation(int id)
{
Reclamation r = rs.GetById(id);
if (r == null)
{
return(NotFound());
}
return(Ok(r));
}
public async Task <Reclamation> getOne(int id)
{
Reclamation reclamation = null;
HttpResponseMessage response = await client.GetAsync($"/reclamation/{id}");
if (response.IsSuccessStatusCode)
{
reclamation = await response.Content.ReadAsAsync <Reclamation>();
}
return(reclamation);
}
public async Task <IHttpActionResult> GetReclamation(int id)
{
Reclamation reclamation = await db.Reclamations.FindAsync(id);
if (reclamation == null)
{
return(NotFound());
}
return(Ok(reclamation));
}
private Notification(NotificationType type, Reclamation reclamation)
{
if (reclamation == null)
{
throw new ArgumentNullException("reclamation");
}
Type = type;
Reclamation = reclamation;
DateTime = DateTime.Now;
}
public async Task <IHttpActionResult> PostReclamation(Reclamation reclamation)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Reclamations.Add(reclamation);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = reclamation.IdReclamation }, reclamation));
}
public ActionResult DetailsReclamation(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reclamation reclamation = reclamationService.GetById(id.Value);
if (reclamation == null)
{
return(HttpNotFound());
}
return(View("Reclamation/Details", reclamation));
}
public void DetailReclamation(object sender, EventArgs e)
{
LinkButton source = (LinkButton)sender;
int reclId = Int32.Parse(source.ID.Remove(0, 6));
Reclamation reclam = usr.Reclamations.Find(reclId);
reclam.status = true;
usr.SaveChanges();
LabelAssure.Text = reclam.Assure.Prenom + ", " + reclam.Assure.Nom;
LabelTitre.Text = reclam.Titre;
LabelDescription.Text = reclam.Description;
ModalPopupExtender1.Show();
}
public async Task <IHttpActionResult> DeleteReclamation(int id)
{
Reclamation reclamation = await db.Reclamations.FindAsync(id);
if (reclamation == null)
{
return(NotFound());
}
db.Reclamations.Remove(reclamation);
await db.SaveChangesAsync();
return(Ok(reclamation));
}
public async System.Threading.Tasks.Task <ActionResult> Repondre([Bind(Include = "id,reponse")] Reclamation sign)
{
//LoginRequest user1;
if (ModelState.IsValid)
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("http://localhost:8091");
string json = JsonConvert.SerializeObject(sign);
StringContent httpContent = new StringContent(json, System.Text.Encoding.UTF8, "application/json");
HttpResponseMessage response = await client.PutAsync("/reclamation/repondre", httpContent);
}
return(RedirectToAction("Index"));
}
// GET: reclamationFront/Delete/5
public ActionResult Delete(int id)
{
Reclamation cm = new Reclamation();
cm = rs.GetById(id);
rec c = new rec();
c.type = cm.type;
c.objet = cm.objet;
c.status = cm.status;
c.dateDebut = cm.dateDebut;
c.dateFin = cm.dateFin;
c.contenu = cm.contenu;
return(View(c));
}
public ActionResult NewReclamation(AllReclamationsViewModel model)
{
var reclamation = new Reclamation
{
DateCreated = DateTime.Now,
Reason = model.NewReclamation.Reclamation.Reason,
ReservationId = model.NewReclamation.Reclamation.ReservationId,
Accepted = false
};
db.Reclamations.Add(reclamation);
db.SaveChanges();
return(RedirectToAction("AllReclamations", true));
}
public ActionResult Create(Reclamation reclamation)
{
try
{
HttpClient Client = new HttpClient();
Client.BaseAddress = new Uri("http://localhost:8082");
Client.PostAsJsonAsync <Reclamation>("SpringMVC/servlet/addReclamation", reclamation).ContinueWith((postTask) => postTask.Result.EnsureSuccessStatusCode());
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public async Task <Uri> Create(Reclamation reclamation, long userId)
{
ServiceMessages serviceMessages = new ServiceMessages();
if (serviceMessages.isSpam(reclamation.explication) || serviceMessages.profanityDetection(reclamation.explication))
{
return(null);
}
HttpResponseMessage response = await client.PostAsJsonAsync(
$"/reclamation/add/{userId}", reclamation);
response.EnsureSuccessStatusCode();
// return URI of the created resource.
return(response.Headers.Location);
}
public ActionResult Reclamation()
{
string name = Request["name"];
string sujet = Request["sujet"];
string email = Request["email"];
Reclamation c = new Reclamation()
{
Sujet = sujet, Nom = name, Email = email, état = "non lu"
};
IReclamationService csv = new ReclamationService();
csv.Add(c);
csv.Commit();
return(RedirectToAction("Contact"));
}
// POST: api/WebApiProject
public IHttpActionResult Post([FromBody] ReclamationViewModels RVM)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data gateau."));
}
Reclamation P = new Reclamation();
P.ID = RVM.ID;
P.Descriptions = RVM.Descriptions;
P.IdEvent = RVM.IdEvent;
P.Idpar = RVM.Idpar;
rs.Add(P);
rs.Commit();
return(Ok(P));
}
protected void button_AjoutReclamation_Click(object sender, EventArgs e)
{
//Ajout de la reclamation
Reclamation R = new Reclamation()
{
Titre = TextBox_TitreReclamation.Text,
Description = TextBoxDescription.Text,
status = false,
Assure = usr.Assures.Find(1),
Date = DateTime.Now.ToString("dd/MM/yyyy")
};
R.Assure = usr.Assures.FirstOrDefault(u => u.AssureId == user.UserId);
usr.Reclamations.Add(R);
usr.SaveChanges();
Page_Load(sender, e);
}
public ActionResult Create(Reclamation reclam)
{
try
{
// TODO: Add insert logic here
RS.Add(reclam);
RS.Commit();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public Cr10xSeries(TimeSeriesDatabase db,Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db,sr)
{
ExternalDataSource = true;
ReadOnly = true;
m_filename = ConnectionStringUtility.GetToken(ConnectionString, "FileName","");
if (!Path.IsPathRooted(m_filename))
{
string dir = Path.GetDirectoryName(m_db.DataSource);
m_filename = Path.Combine(dir, m_filename);
}
m_interval = ConnectionStringToken("Interval");
m_columnNumber = Convert.ToInt32(ConnectionStringUtility.GetToken(ConnectionString, "ColumnNumber",""));
InitTimeSeries(null, this.Units, this.TimeInterval, this.ReadOnly, false, true);
Appearance.LegendText = Name;
}
public SpreadsheetGearSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db, sr)
{
}
private new void Insert(Reclamation.TimeSeries.Series series, bool overWrite)
{
for (int i = 0; i < series.Count; i++)
{
Insert(series[i], overWrite);
}
if (Count > 0)
{//modsim needs dataStartDate as the first entry.
DateTime dataStartDate = m_mi.TimeStepManager.dataStartDate;
if (this[0].DateTime != dataStartDate)
{
this.Insert(new Reclamation.TimeSeries.Point(dataStartDate, -999));
if (this[0].DateTime != dataStartDate)
{
throw new Exception("Internal error.");
}
}
}
DateTime dataEndDate = m_mi.TimeStepManager.dataEndDate;
if (series.Count > 0 && series.MaxDateTime > dataEndDate)
{
Logger.WriteLine("extending modsim date range");
m_mi.TimeStepManager.dataEndDate = series.MaxDateTime.AddHours(23).AddMinutes(59);
m_mi.TimeStepManager.UpdateTimeStepsInfo(m_mi.timeStep);
}
}
/// <summary>
/// сохранение рекламации в БД
/// </summary>
/// <param name="rec">рекламация</param>
public static int SendReclamation(Reclamation rec)
{
using (var dc = new DCFactory<StoreDataContext>())
{
//Коннекция открывается в фабрике
//dc.DataContext.Connection.Open();
dc.DataContext.Reclamations.InsertOnSubmit(rec);
dc.DataContext.SubmitChanges();
//dc.Transaction = dc.Connection.BeginTransaction();
//try
//{
// dc.SubmitChanges();
// ReclamationEnvelope envelope = new ReclamationEnvelope()
// {
// ContactPerson = rec.ContactPerson,
// ContactPhone = rec.ContactPhone,
// Qty = rec.Qty,
// ReclamationReason = rec.ReclamationReason,
// ReclamationDescription = rec.ReclamationDescription,
// Torg12Number = rec.Torg12Number,
// Torg12Price = rec.Torg12Price,
// InvoiceNumber = rec.InvoiceNumber,
// ClientName = rec.ClientName,
// ClientID = rec.ClientID,
// ReclamationDate = rec.ReclamationDate,
// OrderID = rec.OrderID,
// OrderDate = rec.OrderDate,
// EstSupplyDate = rec.EstSupplyDate,
// ManagerName = rec.ManagerName,
// Manufacturer = rec.Manufacturer,
// PartNumber = rec.PartNumber,
// PartName = rec.PartName,
// UnitPrice = rec.UnitPrice,
// UnitQty = rec.UnitQty,
// SupplyDate = rec.SupplyDate,
// SupplierID = rec.SupplierID,
// CurrentStatus = rec.CurrentStatus,
// CurrentStatusDate = rec.CurrentStatusDate,
// ReclamationType = (byte)rec.ReclamationType,
// OrderLineID = rec.OrderLineID
// };
// ServiceProxy.Default.SendReclamation( envelope );
// dc.Transaction.Commit();
//}
//catch(Exception ex)
//{
// dc.Transaction.Rollback();
// Logger.WriteException( ex );
// throw;
//}
//finally
//{
// if (dc.Connection.State == System.Data.ConnectionState.Open)
// dc.Connection.Close();
//}
return rec.ReclamationID;
}
}
private static int LookupNumberOfRuns(Reclamation.Core.TextFile tf)
{
int number_of_runs = 1;
//:53
//number_of_runs:53
int index = tf.IndexOf("number_of_runs:");
if (index == -1)
{
Logger.WriteLine("Error: number_of_runs is not defined in file " +tf.FileName);
}
else
{
number_of_runs = Convert.ToInt32(tf[index].Substring(15));
}
return number_of_runs;
}
private void SaveStandaloneSeries(SeriesCatalogRow row,
Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.ScenarioRow sRow,
bool scenarios)
{
if (row.IsFolder == 0)
{
if (!m_server.TableExists(row.TableName + sRow.Name)) // table name is blank for MODSIM
{
Series s = Factory.GetSeries(row); // from RiverWare rdf (for example)
s.ScenarioName = sRow.Name;
s.Read();
// save to pisces database
var tn = s.Name;
if (sRow.Name != "")
{ tn += "_" + sRow.Name; }
s.SeriesCatalogRow.TableName = GetUniqueTableName(tn);
s.Table.TableName = s.SeriesCatalogRow.TableName;
row.Provider = "Series";
ImportTimeSeriesTable(s.Table, row, DatabaseSaveOptions.Insert);
}
else // may be Hydromet data with existing data
{
row.Provider = "Series";
}
}
}
public static void Import(Reclamation.Core.Arguments args, TimeSeriesDatabase dbase)
{
//// Pisces /ImportIdwr /Data:data.dat /Index:index.dat /Filename:SnakeMonthly.sdf
if (!args.Contains("Data") || !args.Contains("Filename"))
{
Console.WriteLine("Usage: Pisces /ImportIdwr /Data:datafile /Filename:databasename");
Console.WriteLine(" or: Pisces /ImportIdwr /Data:datafile /Index:indexfile /Filename:databasename");
return;
}
string dbname = args["Filename"];
IdwrMonthy id;
db = dbase;
if (args.Count == 3)
{
id = new IdwrMonthy(args["Data"], "noIndex" , dbname);
}
else
{
if (args.Contains("Index"))
{
if (args[2] == "ValidityCheck")
id = new IdwrMonthy(args["Data"], "ValidityCheck", dbname);
else
id = new IdwrMonthy(args["Data"], args["Index"], dbname);
}
else
id = new IdwrMonthy(args["Data"], "noIndex", dbname);
}
id.Import();
}
public HydrossSeries(TimeSeriesDatabase db, Reclamation.TimeSeries.TimeSeriesDatabaseDataSet.SeriesCatalogRow sr)
: base(db,sr)
{
ExternalDataSource = true;
Init(db);
}
