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
{
}
}
