public void CheckOutItem(short memberNumber, int isbn, short copyNumber) { try { DBInteraction db = new DBInteraction(); db.CheckOutItem(memberNumber, isbn, copyNumber); } catch (LibraryException ex) { if (ex.LibraryErrorCode == ErrorCode.CheckOutFailed) { throw new SoapException(ex.Message, ExceptionCodes.CheckOutFailed); } if (ex.LibraryErrorCode == ErrorCode.ItemAlreadyOnLoan) { throw new SoapException(ex.Message, ExceptionCodes.ItemAlreadyOnLoan); } if (ex.LibraryErrorCode == ErrorCode.GenericException) { throw new SoapException(ex.Message, ExceptionCodes.GenericException); } if (ex.LibraryErrorCode == ErrorCode.ItemNotFound) { throw new SoapException(ex.Message, ExceptionCodes.ItemNotFound); } if (ex.LibraryErrorCode == ErrorCode.ItemNotLoanable) { throw new SoapException(ex.Message, ExceptionCodes.ItemNotLoanable); } } }
public JsonResult DecksList() { var userIdentityId = db.Users.FirstOrDefault(users => users.Login == User.Identity.Name).Id; var resultList = DBInteraction.GetUserDecks(userIdentityId, db); return(resultList.Count == 0 ? new JsonResult("Decks not found") : new JsonResult(resultList)); }
static void AddBonus(double productivityThreshold, int maxBonussableEmpoyees, int bonus) { DBInteraction dBInter = new DBInteraction(); var employees = dBInter.ReadEmployeesFromDB(); var employeesAboveProductivityThreshold = employees .Where(emp => emp.Productivity > productivityThreshold) .ToList(); if (employeesAboveProductivityThreshold.Count > maxBonussableEmpoyees) { /* Troppi impegati bravi. -> Riduci il numero d' impiegati da premiare a maxBonussableEmpoyees. */ employeesAboveProductivityThreshold = employeesAboveProductivityThreshold .OrderByDescending(emp => emp.Productivity) // Pari all'«ORDER BY Productivity DESC» dell'SQL. .Take(maxBonussableEmpoyees) // Pari all'«TOP(maxBonussableEmpoyees)» dell'SQL. .ToList(); } employeesAboveProductivityThreshold.ForEach(goodE => goodE.TotalBonus += bonus); #region foreach_Standard /* Non tutti considerano buona la sintassi in stile LinQ, quindi è preferiible con il «foreach» standard ("foreach" in minuscolo = quello std, .ForEach() per quello in LinQ). Vedi: blogs.msdn.microsoft.com/ericlippert/2009/05/18/foreach-vs-foreach */ //foreach (Employee goodE in employeesAboveProductivityThreshold) //{ // goodE.TotalBonus += bonus; //} #endregion return; }
public void CheckDBConnectionAfterEstablishingConnectionTest() { Assert.AreEqual(false, DBInteraction.CheckDBConnection()); var connectedToDBFlag = DBInteraction.SetUpDBConnection(); Assert.AreEqual(true, connectedToDBFlag); }
public static void databaseWordTransaction(String[] words, DBInteraction _DB) { //Persist word/char stats for (int i = 0; i < words.Length; i++) { _DB.AddUsedWord(words[i]); } }
/* Carica la tabella degl'impiegati. */ private void BtnLoad_Click(object sender, RoutedEventArgs e) { DBInteraction dBInter = new DBInteraction(); DtGEmployeesGrid.ItemsSource = dBInter.ReadEmployeesFromDB(); MessageBox.Show("Employees loaded!"); }
public void ExecuteSelectWithValidSPAndNoParametersTest() { var spName = "[TelephoneSystem].[uspGetAllCustomers]"; var spParameterList = new List <SqlParameter>(); var queryResult = DBInteraction.ExecuteSelect(spName, spParameterList); Assert.IsInstanceOfType(queryResult, typeof(SqlDataReader)); queryResult.Close(); }
public JsonResult UpdateDeck() { var stream = new StreamReader(Request.Body); var body = stream.ReadToEndAsync().Result; UserDeckAndCards newUserDeck = JsonConvert.DeserializeObject <UserDeckAndCards>(body); var userIdentityId = db.Users.FirstOrDefault(users => users.Login == User.Identity.Name).Id; var removeStatus = DBInteraction.RemoveDeck(userIdentityId, newUserDeck.Deck[0].DeckId.ToString(), db); return(new JsonResult(removeStatus == 0 ? DBInteraction.StatusCode[DBInteraction.AddDeck(newUserDeck, db, userIdentityId)] : DBInteraction.StatusCode[removeStatus])); }
public void GenerateSQLCommandWithNoSqlParamtersTest() { var spName = "HelloWorld"; var spParameterList = new List <SqlParameter>(); var expectedSqlCommandText = "EXEC HelloWorld"; var sqlCommand = DBInteraction.GenerateSQLCommand(spName, spParameterList); Assert.AreEqual(spParameterList.Count, sqlCommand.Parameters.Count); Assert.AreEqual(expectedSqlCommandText, sqlCommand.CommandText); }
private void DeleteVoyage(int VoyageId) { DBInteraction dinteract = new DBInteraction(); dinteract.DeleteVoyage(VoyageId); SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA]; LoadData(searchCriteria.SortExpression, searchCriteria.SortDirection); ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('" + ResourceManager.GetStringWithoutName("ERR00010") + "');</script>", false); }
public void ExecuteSelectWithInvalidSPTest() { var spName = "HelloWorld"; var spParameterList = new List <SqlParameter>(); spParameterList.Add(new SqlParameter("@spVar1", 123)); spParameterList.Add(new SqlParameter("@spVar2", "Hello")); spParameterList.Add(new SqlParameter("@spVar3", false)); var queryResult = DBInteraction.ExecuteSelect(spName, spParameterList); }
public void ExecuteSelectWithValidSPAndValidParameterValueTest() { var spName = "[TelephoneSystem].[uspGetCustomerById]"; var spParameterList = new List <SqlParameter>(); spParameterList.Add(new SqlParameter("@customerMobileNumer", 01)); var queryResult = DBInteraction.ExecuteSelect(spName, spParameterList); Assert.IsInstanceOfType(queryResult, typeof(SqlDataReader)); queryResult.Close(); }
public void ExecuteNonSelectWithValidSPAndInvalidParameterValueTest() { var spName = "[TelephoneSystem].[uspUpdateCustomer]"; var spParameterList = new List <SqlParameter>(); spParameterList.Add(new SqlParameter("@customerMobileNumer", "abc")); spParameterList.Add(new SqlParameter("@CustomerEmailAddress", "*****@*****.**")); var updateCount = DBInteraction.ExecuteNonSelect(spName, spParameterList); Assert.IsInstanceOfType(updateCount, typeof(int)); }
public Item GetItem(int isbn, short copyNumber) { try { DBInteraction db = new DBInteraction(); return(db.GetItem(isbn, copyNumber)); } catch (LibraryException ex) { throw new SoapException(ex.Message, ExceptionCodes.ItemNotFound); } }
public void AddAdultMember(ref AdultMember member) { try { DBInteraction db = new DBInteraction(); db.AddMember(member); } catch (LibraryException ex) { throw new SoapException(ex.Message, ExceptionCodes.AddAdultFailed); } }
public void ConvertJuvenile(short memberNumber) { try { DBInteraction db = new DBInteraction(); db.ConvertJuvenile(memberNumber); } catch (LibraryException ex) { throw new SoapException(ex.Message, ExceptionCodes.ConvertJuvenileFailed); } }
public void RenewMember(short memberNumber) { try { DBInteraction db = new DBInteraction(); db.RenewMember(memberNumber); } catch (LibraryException ex) { throw new SoapException(ex.Message, ExceptionCodes.RenewMemberFailed); } }
public JsonResult GetUserDeckAndCardsByDeckId() { var userIdentityId = db.Users.FirstOrDefault(users => users.Login == User.Identity.Name).Id; if ((Int32.TryParse(Request.Query["deckid"].ToString(), out int userDeckId) == false) || (userDeckId < 1)) { return(new JsonResult("Incorrect Deck Id")); } var result = DBInteraction.GetUserDeckAndCards(userIdentityId, userDeckId, db); return(result.Deck.Count == 0 ? new JsonResult("Deck Not Fount") : new JsonResult(result)); }
public void AddItem(int isbn, string title, string author, string loanable) { DBInteraction db = new DBInteraction(); try { db.AddItem(isbn, title, author, loanable); } catch (LibraryException ex) { throw new SoapException(ex.Message, ExceptionCodes.AddItemFailed); } }
public Member GetMember(short memberNumber) { try { DBInteraction db = new DBInteraction(); Member m = db.GetMember(memberNumber); return(m); } catch (LibraryException ex) { throw new SoapException(ex.Message, ExceptionCodes.None); } }
public void GenerateSQLCommandWithListOfSqlParamtersTest() { var spName = "HelloWorld"; var spParameterList = new List <SqlParameter>(); spParameterList.Add(new SqlParameter("@spVar1", 123)); spParameterList.Add(new SqlParameter("@spVar2", "Hello")); spParameterList.Add(new SqlParameter("@spVar3", false)); var expectedSqlCommandText = "EXEC HelloWorld @spVar1, @spVar2, @spVar3"; var sqlCommand = DBInteraction.GenerateSQLCommand(spName, spParameterList); Assert.AreEqual(spParameterList.Count, sqlCommand.Parameters.Count); Assert.AreEqual(expectedSqlCommandText, sqlCommand.CommandText); }
public ItemsDataSet GetItems(short memberNumber) { ItemsDataSet myDataSet = new ItemsDataSet(); DBInteraction myDb = new DBInteraction(); try { myDataSet = myDb.GetItems(memberNumber); return(myDataSet); } catch (LibraryException ex) { throw new SoapException(ex.Message, ExceptionCodes.None); } }
private void loadDDL(DateTime?dateTime) { DBInteraction dbInteract = new DBInteraction(); //GeneralFunctions.PopulateDropDownList(ddlTaxDate, dbInteract.GetSTaxDate(dateTime)); System.Data.DataSet ds = dbInteract.GetSTaxDate(dateTime); ddlTaxDate.Items.Add("All"); ddlTaxDate.Items[0].Value = "1900-1-1"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ddlTaxDate.Items.Add(ds.Tables[0].Rows[i][0].ToString().Split(' ')[0]); ddlTaxDate.Items[i + 1].Value = ds.Tables[0].Rows[i][0].ToString(); } }
public void Post(Request arg) //Recieves forms from client, writes data to datamodel and database. { if (arg == null) { throw new ArgumentNullException(paramName: nameof(arg)); } var comment = new Comment(arg); var user = new User(arg); var data = DataSingleton.GetInstance(); lock (DataSingleton.Locker) { try { data.Users.Add(user); } catch (Exception) { throw; } try { if (comment.ParentId == null) { data.Comments.Add(comment); } else { data.Comments.Find(x => x.Article == comment.Article) .AddCommentRecursive(comment, Recursion.Limit); } } catch (Exception) { data.Users.RemoveAll(x => x.Id == user.Id); } DBInteraction Interactor = new DBInteraction(); try { Interactor.AddNewUserAndHisComment(user.Name, comment); } catch { } } }
public JsonResult UpdateDeckProgress() { var stream = new StreamReader(Request.Body); var body = stream.ReadToEndAsync().Result; var userIdentityId = db.Users.FirstOrDefault(users => users.Login == User.Identity.Name).Id; UserDeck updateDeck = JsonConvert.DeserializeObject <UserDeck>(body); UserDeck userdbdeck = DBInteraction.GetUserDeck(userIdentityId, updateDeck.DeckId, db)[0]; if (userdbdeck == null) { return(new JsonResult("Such a deck does not exist")); } userdbdeck.Progress = updateDeck.Progress; db.UsersDecks.Update(userdbdeck); db.SaveChanges(); return(new JsonResult("success")); }
/* Crea un nuovo impiegato e lo salva sul DB. */ private void BtnNew_Click(object sender, RoutedEventArgs e) { MessageBox.Show("Employee add mode."); /* Nel caso non ci sia stato un load della tabella. */ DBInteraction dBInter = new DBInteraction(); DtGEmployeesGrid.ItemsSource = dBInter.ReadEmployeesFromDB(); /* Apertura finestra d'aggiunta. */ Window employeeDetailWindow = new EmployeeDetail(); employeeDetailWindow.Show(); /* Aggiorno la tabella a schermo. */ DtGEmployeesGrid.ItemsSource = dBInter.ReadEmployeesFromDB(); }
public ExampleController(ICapitalize cap, DBInteraction db, ILowercase low, IBinary bin, IAscii ascii, IFilter fil, IThesaurus thesaurus, IHex hex) { _cap = cap; _DB = db; _low = low; _bin = bin; _ascii = ascii; _filter = fil; _thesaurus = thesaurus; _hex = hex; }
public ActionResult Signup([Bind(Include = "LastName,FirstMidName,Login,Password,Discriminator")] UserLoginInfo userLoginInfo) { //if signup info is correct if (ModelState.IsValid) { //if login is not already taken if (!db.People.Any(x => x.Login == userLoginInfo.Login)) { DBInteraction.AddPerson(userLoginInfo.Discriminator, userLoginInfo.LastName, userLoginInfo.FirstMidName, DateTime.Now, userLoginInfo.Login, userLoginInfo.Password); return(RedirectToAction("Index")); } else { ViewData["Erreur"] = "This login already exists."; return(View()); } } return(View()); }
protected void Page_Load(object sender, EventArgs e) { ((AjaxControlToolkit.TextBoxWatermarkExtender)AutoCompleteCountry1.FindControl("txtWMEName")).WatermarkText = "TYPE VESSEL FLAG"; SetAttributes(); RetriveParameters(); CheckUserAccess(); if (!IsPostBack) { RetrieveSearchCriteria(); DBInteraction dbInteract = new DBInteraction(); //GeneralFunctions.PopulateDropDownList(ddlLocation, dbInteract.PopulateDDLDS("mstCountry", "pk_countryid", "CountryName")); //ddlLocation.Items[0].Text = "Select Country"; GeneralFunctions.PopulateDropDownList(ddlVesselPrefix, dbInteract.PopulateDDLDS("mstVesselPrefix", "pk_VesselPrefixID", "VesselPrefix")); ddlVesselPrefix.Items[0].Text = "Select Prefix"; SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA]; LoadData(searchCriteria.SortExpression, searchCriteria.SortDirection); } }
private void GenerateReport() { string pod = ((TextBox)AutoCompletepPort1.FindControl("txtPort")).Text; pod = pod.Contains(',') ? pod.Split(',')[1] : ""; if (pod.Trim() == "") { lblError.Attributes.Add("Style", "display:block"); return; } else { lblError.Attributes.Add("Style", "display:none"); } ReportBLL cls = new ReportBLL(); LocalReportManager reportManager = new LocalReportManager(rptViewer, "IGMCargoDesc", ConfigurationManager.AppSettings["ReportNamespace"].ToString(), ConfigurationManager.AppSettings["ReportPath"].ToString()); string rptName = "IGMCargoDesc.rdlc"; int vesselId = Convert.ToInt32(ddlVessel.SelectedValue); int voyageId = ddlVoyage.SelectedIndex > 0 ? Convert.ToInt32(ddlVoyage.SelectedValue) : 0; DBInteraction dbinteract = new DBInteraction(); DataSet ds = EMS.BLL.IGMReportBLL.GetRptCargoDesc(vesselId, voyageId, dbinteract.GetId("Port", pod)); try { rptViewer.Reset(); rptViewer.LocalReport.Dispose(); rptViewer.LocalReport.DataSources.Clear(); rptViewer.LocalReport.ReportPath = this.Server.MapPath(this.Request.ApplicationPath) + ConfigurationManager.AppSettings["ReportPath"].ToString() + "/" + rptName; rptViewer.LocalReport.SetParameters(new ReportParameter("ReportName", "C A R G O D E C L A R A T I O N")); rptViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", ds.Tables[0])); rptViewer.LocalReport.Refresh(); } catch { } }