// Edit a product
public void Edit(Product product)
{
try {
// Search product by id
Product productTemp = SearchById(product.Id);
// Check if product exists
// If it doesn't exist, generate an exception
if (productTemp == null)
{
throw new Exception("Produto não encontrado");
}
//If it exists, change its properties
productTemp.Name = product.Name;
productTemp.Price = product.Price;
// Change product in context
_ctx.Products.Update(productTemp);
// Save the context
_ctx.SaveChanges();
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}
public ActionResult Post([FromBody] Request request)
{
Request requestToAdd = request;
int idToAdd = (from n in requestContext.Requests orderby n.Id descending select n.Id).FirstOrDefault();
requestToAdd.Id = idToAdd + 1;
requestContext.Requests.Add(requestToAdd);
requestContext.SaveChanges();
return(Ok());
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,PhoneNumber,ApartmentName,UnitNumber,Description,Permission")] RequestForm requestForm)
{
if (ModelState.IsValid)
{
db.request.Add(requestForm);
db.SaveChanges();
return(RedirectToAction("ThanksPage"));
}
return(View(requestForm));
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,PhoneNum,AptName,Unit,Expl")] Request request)
{
if (ModelState.IsValid)
{
db.Requests.Add(request);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(request));
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,PhoneNumber,ApptName,UnitNumber, Explanation, Permission")] Request request)
{
try
{
db.Requests.Add(request);
db.SaveChanges();
return(RedirectToAction("Index", "Home/Index"));
}
catch
{
return(View(request));
}
}
// GET: Translate
public JsonResult TransLang(string id)
{
string api = "http://api.giphy.com/v1/stickers/translate?";
string apikey = "&api_key=" + System.Web.Configuration.WebConfigurationManager.AppSettings["CS460ApiKey"];
string query = "&s=" + id;
string url = api + apikey + query;
//var giphyData = new WebClient().DownloadString(url);
// same result but transfer to json format
Stream giphyStream = WebRequest.Create(url).GetResponse().GetResponseStream();
var giphyData = new System.Web.Script.Serialization.JavaScriptSerializer()
.Deserialize <Object>(new StreamReader(giphyStream)
.ReadToEnd());
// working on database
// the request can help a lot, use a object based on model
Request item = new Request();
item.IPAddress = Request.UserHostAddress;
item.Description = id;
item.Type = Request.UserAgent;
database.Requests.Add(item);
database.SaveChanges();
//giphyStream.Close();
return(Json(giphyData, JsonRequestBehavior.AllowGet));
}
public static void AddDepartments(RequestContext context)
{
var departments = new List <Departments>
{
new Departments {
Department = "IT"
},
new Departments {
Department = "Sales"
},
new Departments {
Department = "Marketing"
},
new Departments {
Department = "Human Resources"
},
new Departments {
Department = "Customer Service"
},
new Departments {
Department = "Office Management"
},
new Departments {
Department = "Finance"
},
};
foreach (var department in departments)
{
context.Departments.Add(department);
}
context.SaveChanges();
}
public IActionResult Create([FromBody] Node node)
{
// var options = new DbContextOptionsBuilder<MemoryContext>()
// .UseInMemoryDatabase(databaseName: "meorydb")
// .Options;
// using (_context = new MemoryContext(options))
// {
// _context.Nodes.Add(node);
// _context.SaveChanges();
// }
if (node is null)
{
return(NotFound());
}
_context.Add(node);
_context.SaveChanges();
return(Ok(node));
}
/*
* IP Address of client should be logged into the database
* with date/time of the request
*/
public void LogRequest(string ip)
{
var request = new Request {
IpAddress = ip, RequestDateTime = DateTime.Now
};
_context.Request.Add(request);
_context.SaveChanges();
}
public void Can_Get_Orders_Price_Range()
{
//preparation - create new dbcontext with in-memory db
using (var context = new RequestContext(CreateNewContextOptions()))
{
Request request = new Request
{
Id = 1111,
Price = 10,
Quantity = 1,
RequestId = 1,
ClientId = 111,
Name = "product1"
};
Order order = new Order
{
OrderId = 1,
ClientId = request.ClientId,
RequestId = request.RequestId,
Amount = request.Price * request.Quantity
};
Order order2 = new Order
{
OrderId = 2,
ClientId = 3,
RequestId = 3,
Amount = 71
};
Order order3 = new Order
{
OrderId = 3,
ClientId = 3,
RequestId = 1,
Amount = 70
};
request.Order = order;
//adding order to db
context.Requests.Add(request);
context.Orders.Add(order);
context.Orders.Add(order2);
context.Orders.Add(order3);
context.SaveChanges();
var service = new OrderService(context);
List <Order> orders = service.OrdersPriceRange(0, 70).OrdersList;
//assert - is quantity of price range orders equal 1
Assert.AreEqual(2, orders.Count);
//assert - check correct of insert data
Assert.AreEqual(1, orders[0].OrderId);
Assert.AreEqual(3, orders[1].OrderId);
}
}
public ActionResult Create(Request request)
{
if (ModelState.IsValid)
{
db.Requests.Add(request);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(request));
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,DOB,PhoneNumber,CatalogYear,VNumber,Email,Major,Minor,Advisor")] Request request)
{
if (ModelState.IsValid)
{
db.Requests.Add(request);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(request));
}
public ActionResult RequestForm([Bind(Include = "ID, FirstName, LastName, PhoneNumber, ApartmentName, UnitNumber, Explanation, ")] Request request)
{
if (ModelState.IsValid)
{
db.Requests.Add(request);
db.SaveChanges();
return(RedirectToAction("ViewRequests"));
}
return(View(request));
}
public ActionResult Create([Bind(Include = "TimeOfRequest,FirstName,LastName,PhoneNumber,ApartmentName,UnitNumber,MaintenanceRequired,Permission")] Request request)
{
if (ModelState.IsValid)
{
db.Requests.Add(request);
db.SaveChanges();
return(RedirectToAction("ThankYou"));
}
return(View(request));
}
public ActionResult Create([Bind(Include = "Id,Title,Caption")] Request request)
{
request.StatusId = 1;
request.Date = DateTime.Now;
if (ModelState.IsValid)
{
request = db.Requests.Add(request);
var movement = new RequestMovement();
movement.Comment = "Создана заявка";
movement.Date = DateTime.Now;
movement.NewStatusId = 1;
movement.OldStatusId = 1;
movement.RequestId = request.Id;
db.RequestMovements.Add(movement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(request));
}
public ActionResult DeleteRequest(int request_id)
{
using(RequestContext context = new RequestContext())
{
context.Requests.Remove(context.Requests.Where(x=>x.ID==request_id).FirstOrDefault());
context.SaveChanges();
}
if (User.IsInRole("admin"))
{
return GetAllRequests(null);
}
return GetRequestsById(null);
}
public IActionResult Add(AddRequestModel model)
{
var request = new Request
{
OrderId = model.OrderId,
AccountId = accountContext.findIdByLogin(User.Identity.Name),
Text = model.Text,
Date = model.Date
};
requestContext.Add(request);
requestContext.SaveChanges();
return(RedirectToAction("Success", "Request"));
}
public ActionResult Create([Bind(Include = "Id,OldStatusId,NewStatusId,RequestId,Comment")] RequestMovement requestMovement, int id)
{
requestMovement.OldStatusId = db.Requests.Find(id).StatusId;
db.Requests.Find(id).StatusId = requestMovement.NewStatusId;
requestMovement.RequestId = id;
if (ModelState.IsValid)
{
requestMovement.Date = DateTime.Now;
db.RequestMovements.Add(requestMovement);
db.SaveChanges();
return(RedirectToAction("Index/" + id.ToString()));
}
return(View(requestMovement));
}
public ActionResult Create(Request request)
{
try
{
using (var db = new RequestContext())
{
request.CreateDate = DateTime.Now;
db.Requests.Add(request);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View(request));
}
}
public ActionResult Index()
{
rqInfo.RequestInformationType = Request.HttpMethod;
try
{
rqInfo.RequestInformationUrl = Request.UrlReferrer.ToString();
}
catch
{
rqInfo.RequestInformationUrl = "First application start";
}
rqInfo.RequestInformationIp = Request.UserHostAddress;
// Write request info to DB
rq.RequestInformation.Add(rqInfo);
rq.SaveChanges();
// If form request type like'GET' we can get parametrs from QueryString
if (Request.QueryString["name"] != null)
{
mhInfo.MovieHouseName = Request.QueryString["name"];
mhInfo.MovieHouseTelephone = Request.QueryString["telephone"];
mhInfo.MovieHouseAdress = Request.QueryString["adress"];
mhInfo.MovieHouseId = 0;
// Write movie house info to DB
rq.MovieHouses.Add(mhInfo);
rq.SaveChanges();
ViewBag.Additional = "with new one";
}
// Write request info to file
Write(rqInfo);
ViewBag.Type = "GET method";
ViewBag.Response = "home page and list of movie houses ";
// ViewBag.Additional = "with new one";
return(View(rq.MovieHouses.ToList()));
}
public JsonResult Sentence(string gifInput)
{
string gifKey = System.Configuration.ConfigurationManager.AppSettings["GKey"];
string gifRequest = "https://api.giphy.com/v1/stickers/translate?api_key=" + gifKey + "&s=" + gifInput;
Debug.WriteLine(gifRequest);
var req = WebRequest.Create(gifRequest);
req.ContentType = "aaplication/json; charset=utf-8";
var res = (HttpWebResponse)req.GetResponse();
string content;
using (var stream = new StreamReader(res.GetResponseStream()))
{
content = stream.ReadToEnd();
stream.Close();
}
string data = JObject.Parse(content)["data"].ToString();
string url = JObject.Parse(data)["embed_url"].ToString();
var gifSticker = new { embed_url = url };
var ip = Request.UserHostAddress;
var browser = Request.Browser.Type;
var model = new Models.Request
{
IPAddress = ip,
Browser = browser,
DateRequested = DateTime.Now,
RequestType = gifInput
};
requestContext.Requests.Add(model);
requestContext.SaveChanges();
return(Json(gifSticker, JsonRequestBehavior.AllowGet));
}
public ActionResult EditRequest(Request request)
{
var search_id = request.ID;
using (RequestContext context = new RequestContext())
{
Request search_request = context.Requests.Where(x => x.ID == search_id).FirstOrDefault();
search_request.Category = request.Category;
search_request.ShortDescription = request.ShortDescription;
search_request.DetailsDescription = request.DetailsDescription;
search_request.IsWarranty = request.IsWarranty;
search_request.ManufacturingFirm = request.ManufacturingFirm;
search_request.ContactData = request.ContactData;
context.SaveChanges();
}
if (User.IsInRole("admin"))
{
return GetAllRequests(null);
}
return GetRequestsById(null);
}
public void Can_Get_All_Orders()
{
//preparation - create new dbcontext with in-memory db
using (var context = new RequestContext(CreateNewContextOptions()))
{
Request request = new Request
{
Id = 1111,
Price = 10,
Quantity = 1,
RequestId = 1,
ClientId = 111,
Name = "product1"
};
DAL.Entities.Order order = new DAL.Entities.Order
{
OrderId = 1,
ClientId = request.ClientId,
RequestId = request.RequestId,
Amount = request.Price * request.Quantity
};
request.Order = order;
//adding order to db
context.Requests.Add(request);
context.Orders.Add(order);
context.SaveChanges();
var service = new OrderService(context);
List <Order> orders = service.GetAllOrders().OrdersList;
//assert - is quantity of orders equal 1
Assert.AreEqual(1, orders.Count);
//assert - check correct of insert data
Assert.AreEqual(111, orders[0].ClientId);
}
}
public void SisTestRing()
{
var form = new Form1();
form.button1_Click_1(null, null);
var form2 = new Form2();
form2.textBox2.Text = "TESTsis";
form2.richTextBox1.Text = "заявка_заявка_заявка";
form2.maskedTextBox1.Text = "5555555555";
form2.radioButton1.Checked = true;
form2.button1_Click(null, null);
form2.Close();
using (RequestContext db = new RequestContext())
{
var blog = db.Requests
.Where(b => b.Name == "TESTsis")
.FirstOrDefault();
Assert.AreEqual("TESTsis", blog.Name);
db.Requests.Remove(blog);
db.SaveChanges();
}
}
public void TestPutMessege()
{
WorkBD.putMessege("Иванов Иван Иванович", "UzverPC", "4815162342", "stNum", "Есть проблема");
using (RequestContext db = new RequestContext())
{
var blog = db.Requests
.Where(b => b.Name == "Иванов Иван Иванович")
.FirstOrDefault();
Assert.AreEqual("Иванов Иван Иванович", blog.Name);
db.Requests.Remove(blog);
db.SaveChanges();
// db.Requests.Find("Иванов Иван Иванович");
// Пытаемся присоединиться к БД.
// Assert, если не получилось установить соединение.
// Извлекаем из БД запись.
// Assert, если записи нет или она отличается от той, что тут уже есть.
// Удаление этой записи из БД (мы же не хотим 100500 тестовых примеров через пару месяцев разработки).
}
}
public void Save()
{
context.SaveChanges();
}
public bool LoadToDb(IFormFile file)
{
//convert csv to list of requests
using (var reader = new StreamReader(file.OpenReadStream()))
using (var csv = new CsvReader(reader))
{
csv.Configuration.Delimiter = ",";
List <RequestCsv> records = null;
try
{
records = csv.GetRecords <RequestCsv>().ToList();
}
catch (HeaderValidationException exception)
{
Debug.WriteLine(exception.Message);
return(false);
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
return(false);
}
//add converted requests to database
if (records != null)
{
foreach (var rq in records)
{
Request request = new Request
{
ClientId = int.Parse(rq.Client_Id),
Name = rq.Name,
Price = Double.Parse(rq.Price, CultureInfo.InvariantCulture),
Quantity = int.Parse(rq.Quantity),
RequestId = long.Parse(rq.Request_id, CultureInfo.InvariantCulture)
};
var order = _context.Orders.Where(m => m.ClientId == request.ClientId &&
m.RequestId == request.RequestId);
if (order.Count() != 0)
{
request.Order = order.First();
order.First().Amount += request.Price * request.Quantity;
}
else
{
var newOrder = new Order
{
ClientId = request.ClientId,
RequestId = request.RequestId,
Amount = request.Price * request.Quantity
};
_context.Orders.Add(newOrder);
_context.SaveChanges();
request.Order = newOrder;
}
_context.Requests.Add(request);
_context.SaveChanges();
}
return(true);
}
return(false);
}
}
public void Can_Get_Client_Orders()
{
//create db context
using (var context = new RequestContext(CreateNewContextOptions()))
{
//create requests to add to db
Request request1 = new Request
{
Id = 2222,
Price = 10,
Quantity = 1,
RequestId = 1,
ClientId = 1,
Name = "product1"
};
Request request2 = new Request
{
Id = 3333,
Price = 10,
Quantity = 1,
RequestId = 1,
ClientId = 22,
Name = "product2"
};
Request request3 = new Request
{
Id = 3334,
Price = 20,
Quantity = 12,
RequestId = 1,
ClientId = 22,
Name = "product3"
};
//create orders to add to db
Order order1 = new Order
{
OrderId = 1,
ClientId = request1.ClientId,
RequestId = request1.RequestId,
Amount = request1.Price * request1.Quantity
};
Order order2 = new Order
{
OrderId = 2,
ClientId = request2.ClientId,
RequestId = request2.RequestId,
Amount = request2.Price * request2.Quantity
};
//assignment orders to requests
request1.Order = order1;
request2.Order = order2;
request3.Order = order2;
//add requests and orders to database
context.Requests.Add(request1);
context.Requests.Add(request2);
context.Requests.Add(request3);
context.Orders.Add(order1);
context.Orders.Add(order2);
context.SaveChanges();
//create tested service
var service = new OrderService(context);
List <Order> orders = service.GetOrdersByClient(22).OrdersList;
//assert - is number of client orders equal 1
Assert.AreEqual(1, orders.Count);
//assert - check valid of retrieved data
Assert.AreEqual("product2", orders[0].Requests[0].Name);
}
}
public void Can_Get_Nr_Of_Product_Orders()
{
//create db context
using (var context = new RequestContext(CreateNewContextOptions()))
{
//create requests to add to db
Request request1 = new Request
{
Id = 2222,
Price = 10,
Quantity = 1,
RequestId = 1,
ClientId = 1,
Name = "product1"
};
Request request2 = new Request
{
Id = 3333,
Price = 10,
Quantity = 1,
RequestId = 2,
ClientId = 22,
Name = "product2"
};
Request request3 = new Request
{
Id = 3334,
Price = 20,
Quantity = 12,
RequestId = 1,
ClientId = 22,
Name = "product3"
};
//create orders to add to db
Order order1 = new Order
{
OrderId = 1,
ClientId = request1.ClientId,
RequestId = request1.RequestId,
Amount = request1.Price * request1.Quantity
};
Order order2 = new Order
{
OrderId = 2,
ClientId = request2.ClientId,
RequestId = request2.RequestId,
Amount = request2.Price * request2.Quantity
};
Order order3 = new Order
{
OrderId = 3,
ClientId = request3.ClientId,
RequestId = request3.RequestId,
Amount = request3.Price * request3.Quantity
};
//assignment orders to requests
request1.Order = order1;
request2.Order = order2;
request3.Order = order3;
//add requests and orders to database
context.Requests.Add(request1);
context.Requests.Add(request2);
context.Requests.Add(request3);
context.Orders.Add(order1);
context.Orders.Add(order2);
context.Orders.Add(order3);
context.SaveChanges();
//create tested service
var service = new ProductService(context);
//action - call tested method
ProductDTO ordersQuantity = service.GetProductsNumberOfOrders();
//assert - is number of products equal 3
Assert.AreEqual(3, ordersQuantity.ProductOrders.Count);
}
}
public void SaveChanges()
{
_requestContext.SaveChanges();
}
public ActionResult Index(Request responseModel)
{
double processDays = 1;
using (RequestContext context = new RequestContext())
{
Request new_request = new Request
{
Category = responseModel.Category,
ShortDescription = responseModel.ShortDescription,
DetailsDescription = responseModel.DetailsDescription,
IsWarranty = responseModel.IsWarranty,
ManufacturingFirm = responseModel.ManufacturingFirm,
ContactData = responseModel.ContactData,
InitialDate = DateTime.Now,
DeadlineRequest = DateTime.Now.AddDays(processDays),
State = "Новая",
MasterID = 1,
ClientID = User.Identity.GetUserId()
};
context.Requests.Add(new_request);
context.SaveChanges();
}
if (User.IsInRole("admin"))
{
return GetAllRequests(null);
}
return GetRequestsById(null);
}
private RequestContext db = new RequestContext(); // brings in dbcontext
// GET: Search
// Gets the API Key and sets up a URL for a request to the other server (GIPHY), reads the response and
// deserializes it to pass it back to javascript to display on the client. Also logs request info in db.
// param termstring: the search terms
// param topResult: if the user only wants the top result
// param rating: the rating the user is requesting (default currently set to Y)
// return JSON object
public ActionResult Index(string termString, string topResult, string rating)
{
// get the api key from a file outside the repo
string apiKey = System.Web.Configuration.WebConfigurationManager.AppSettings["GiphyAPIKey"];
// Debug to Debugger output to confirm things are working
Debug.WriteLine("API key = " + apiKey);
Debug.WriteLine("termString = " + termString);
Debug.WriteLine("topResult = " + topResult);
Debug.WriteLine("rating = " + rating);
// If topResult isn't checked, limit to 18 results for better appearance
if (topResult == "")
{
topResult = "&limit=18";
}
var ratingString = "&rating=" + rating;
// build the requestURL
var requestURL = "http://api.giphy.com/v1/gifs/search?q=" + termString + topResult + ratingString + "&api_key=" + apiKey;
Debug.WriteLine("requestURL = " + requestURL);
// build a WebRequest
WebRequest request = WebRequest.Create(requestURL);
// get the response from the WebRequest via the passed URL
WebResponse response = request.GetResponse();
// build a Stream AND get the Stream Response
Stream dataStream = response.GetResponseStream();
//StreamReader reader = new StreamReader(dataStream);
StreamReader reader = new StreamReader(response.GetResponseStream());
// Read the content.
string responseFromServer = reader.ReadToEnd();
// Display the content.
Debug.WriteLine(responseFromServer);
// Clean up the streams and the response.
reader.Close();
response.Close();
// Create a JObject, using Newtonsoft NuGet package
JObject json = JObject.Parse(responseFromServer);
Debug.WriteLine(json);
// Create a serializer to deserialize the string response (string in JSON format)
JavaScriptSerializer serializer = new JavaScriptSerializer();
// Store JSON results in results to be passed back to client (javascript)
var results = serializer.DeserializeObject(responseFromServer);
// get userIP and userAgent for tracking purposes
string userIP = Request.UserHostAddress;
string userAgent = Request.UserAgent;
Debug.WriteLine(userIP);
Debug.WriteLine(userAgent);
// build new Request to enter into db
Request userInfo = db.Requests.Create();
// add all the attributes of a user request to add it to the db
userInfo.RequestDate = DateTime.Now;
userInfo.RequestString = termString;
userInfo.Rating = rating;
userInfo.UserIP = userIP;
userInfo.UserAgent = userAgent;
// sets empty string or null to ---, allows save to database of emptry string
if (userInfo.RequestString == null || userInfo.RequestString == "")
{
userInfo.RequestString = "---";
}
// add to and save the db
db.Requests.Add(userInfo);
db.SaveChanges();
// return the Json object
return(Json(results, JsonRequestBehavior.AllowGet));
}
public bool LoadToDb(IFormFile file)
{
//RequestRepository repository = new RequestRepository(_context);
OrderService orderService = new OrderService(_context);
var result = string.Empty;
//read json file to string
using (var reader = new StreamReader(file.OpenReadStream()))
{
result = reader.ReadToEnd();
}
RequestsJson rqst;
//convert json to list of requests
try
{
rqst = JsonConvert.DeserializeObject <RequestsJson>(result);
}
catch (JsonReaderException exception)
{
Debug.WriteLine(exception.Message);
return(false);
}
if (rqst != null && rqst.Requests != null)
{
foreach (RequestJson rq in rqst.Requests)
{
Request request = new Request
{
ClientId = int.Parse(rq.ClientId ?? ""),
Name = rq.Name ?? "",
Price = Double.Parse(rq.Price ?? "", CultureInfo.InvariantCulture),
Quantity = int.Parse(rq.Quantity ?? ""),
RequestId = long.Parse(rq.RequestId ?? "", CultureInfo.InvariantCulture)
};
var order = _context.Orders.Where(m => m.ClientId == request.ClientId &&
m.RequestId == request.RequestId);
if (order.Count() != 0)
{
request.Order = order.First();
order.First().Amount += request.Price * request.Quantity;
}
else
{
Order newOrder = new Order
{
ClientId = request.ClientId,
RequestId = request.RequestId,
Amount = request.Price * request.Quantity
};
_context.Add(newOrder);
request.Order = newOrder;
}
_context.Requests.Add(request);
_context.SaveChanges();
}
return(true);
}
return(false);
}