public void CapacityDoubledWith10ItemsInList_Removing5Items_5ItemsRemainingAndshiftedOver() { //arrange int one = 1; int two = 2; int three = 3; int four = 4; int five = 5; int six = 6; int expected; int actual; myList <int> andrewsList = new myList <int>(); //act andrewsList.AddToMyList(one); andrewsList.AddToMyList(two); andrewsList.AddToMyList(three); andrewsList.AddToMyList(four); andrewsList.AddToMyList(five); andrewsList.AddToMyList(five); andrewsList.AddToMyList(five); andrewsList.AddToMyList(five); andrewsList.AddToMyList(five); andrewsList.AddToMyList(six); andrewsList.RemoveItemFromList(five); expected = 6; actual = andrewsList[8]; //Assess Assert.AreEqual(expected, actual); }
public void RemovingItemFromList_Removingindex3fromList_ListMovesDownAnIndexAt3() { //Arrange myList <double> andrewsList = new myList <double>(); double twenty = 20; double thirty = 30; double ten = 10; double fourty = 40; double fifty = 50; double expected; double actual; //act andrewsList.AddToMyList(ten); andrewsList.AddToMyList(twenty); andrewsList.AddToMyList(thirty); andrewsList.AddToMyList(fourty); andrewsList.AddToMyList(fifty); andrewsList.RemoveItemFromList(thirty); expected = fifty; actual = andrewsList[3]; //Assert Assert.AreEqual(expected, actual); }
public iTextSharp.text.Document faturalariGetir() { iTextSharp.text.Document pdf = null; DataTable dt = db.exReaderDT(CommandType.Text, "select ca.cari_vergiDairesi,ca.cari_vergiNo, ca.cari_unvan,ca.cari_adres, ch.chh_tarihi,sum(ch.chh_aratoplam) as aratoplam,sum(ch.chh_ft_kdv) as kdv,sum(ch.chh_geneltoplam) as geneltoplam,ch.chh_evrakno_sira from cari_hesap_hareketleri ch,cariler ca where ca.cari_kodu=ch.chh_cari_kodu and ch.chh_evrakno_sira in(select distinct(chh_evrakno_sira) from cari_hesap_hareketleri where chh_evrakno_sira>=@evrakno1 and chh_evrakno_sira<=@evrakno2) group by chh_evrakno_sira,chh_cari_kodu,chh_tarihi,cari_unvan,cari_adres,ca.Cari_VergiDairesi,ca.cari_vergiNO", "evrakno1=" + Request.QueryString["evrakno1"].ToString() + ",evrakno2=" + Request.QueryString["evrakno2"]); if (dt != null && dt.Rows.Count > 0) { myList lst = pdfOlustur(); pdf = lst.pdf; PdfWriter writer = lst.writer; int sayac = 0; foreach (DataRow item in dt.Rows) { if (sayac > 0) { pdf.NewPage(); } PdfPTable tblUst = ustTableGetir(item["cari_unvan"].ToString(), item["cari_adres"].ToString(), item["chh_tarihi"].ToString().Split(' ')[0], item["chh_evrakno_sira"].ToString(), item["cari_vergiDairesi"].ToString(), item["cari_vergiNo"].ToString()); pdf.Open(); pdf.Add(tblUst); PdfPTable tblSatirlar = fatura_bagla(item["chh_evrakno_sira"].ToString()); if (tblSatirlar != null) { pdf.Add(tblSatirlar); } PdfPTable tblAltSatir = footerTableGEtir((float)Convert.ToDouble(item["aratoplam"]), (float)Convert.ToDouble(item["kdv"]), (float)Convert.ToDouble(item["geneltoplam"])); tblAltSatir.WriteSelectedRows(0, -1, (int)((pdf.PageSize.Width - tblAltSatir.TotalWidth) / 2), (pdf.Bottom + 65), writer.DirectContent); sayac++; } pdf.Close(); } return(pdf); }
//this method will get the items from the database and return them as a list of items public void getList() { //will need to query for all of the items with a matching user id, obtained from sign in and register pages nameLabel.Text = "hello user " + userID; try { //get the assigned and owned lists string connectionString = "datasource=127.0.0.1;port=3306;username=root;password=;database=tms;"; string queryString = "select * from itemTable where itemCreateUserID = '" + userID + "'"; MySqlConnection conn = new MySqlConnection(connectionString); MySqlCommand com = new MySqlCommand(queryString, conn); conn.Open(); MySqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { myList m = new myList(); // arr)ay for holding the old items m.listName = dr.GetString(1); m.listDescription = dr["itemDetail"].ToString(); listBox1.Items.Insert(0, m.listName); listLog.Insert(0, m); } } catch (Exception e) { errorLabel.Text = e.Message; } //probably make a for loop to insert the items at beginning of list, in case someone added an item and then signed in //listBox1.Items.Insert(0, username); }
// Constructor public MainPage() { myList list1 = new myList() { Name = "First"}; for (int i = 0; i < 100; i++) list1.Items.Add(new myItems() { Title = (i + 1).ToString() }); myList list2 = new myList() { Name = "Second" }; for (int i = 100; i < 200; i++) list2.Items.Add(new myItems() { Title = (i + 1).ToString() }); myList list3 = new myList() { Name = "Third" }; for (int i = 200; i < 300; i++) list3.Items.Add(new myItems() { Title = (i + 1).ToString() }); myList list4 = new myList() { Name = "Fourth" }; for (int i = 300; i < 400; i++) list4.Items.Add(new myItems() { Title = (i + 1).ToString() }); Lists.Add(list1); Lists.Add(list2); Lists.Add(list3); Lists.Add(list4); InitializeComponent(); this.DataContext = this; PivotControl.ItemsSource = Lists; myButton.Click += first_Click; }
private void lstAccNo_SelectedIndexChanged(object sender, EventArgs e) { myList lstParent = sender as myList; if (lstParent.SelectedValue == null || strDataFromDataSource == true) { return; } if (lstParent.SelectedValue.ToString() != "System.Data.DataRowView" && lstParent.SelectedValue.ToString() != "") { lstAccNo.SelectedValue = lstAccName.SelectedValue = lstParent.SelectedValue; txtCostCenterId.Text = ""; txtCostCenterName.Text = ""; for (int i = 0; i < dtAccData.Rows.Count; i++) { if (dtAccData.Rows[i]["swid"].ToString() == lstParent.SelectedValue.ToString()) { iRowAccData = i; return;//use break if you have code after for loop } } } }
public string MyListToString(myList <int> ml) { string s = ""; foreach (int x in ml) { s += x + " "; } return(s); }
private void lstAccNo_SelectedIndexChanged(object sender, EventArgs e) { myList LstAcc = sender as myList; string str = LstAcc.Name; if (LstAcc.SelectedValue == null) { return; } if (LstAcc.SelectedValue.ToString() != "System.Data.DataRowView" && LstAcc.SelectedValue.ToString() != "") { lstAccNo.SelectedIndex = lstAccName.SelectedIndex = LstAcc.SelectedIndex; ConnectionToDB cnn = new ConnectionToDB(); DataTable dtCasherAcc = cnn.GetDataTable("select the_value from DEFAULT_VALUES t where value_name ='الرتبة" + iAccLevel + "'"); iLastLevelValue = Convert.ToInt16(dtCasherAcc.Rows[0][0].ToString()); if (dtCasherAcc == null || dtCasherAcc.Rows.Count <= 0) { glb_function.MsgBox("الرجاء تحديد عدد الرتبة الاخيرة للحسابات الفرعية"); return; } dtCasherAcc.Rows.Clear(); dtCasherAcc = cnn.GetDataTable("select to_number( substr(acc_no,-" + iLastLevelValue + ")) from accounts " + " where acc_parent = " + LstAcc.SelectedValue.ToString() + " order by 1"); txtAccNo.Text = ""; int i = 0; for (i = 0; i < dtCasherAcc.Rows.Count; i++) { if ((i + 1) != Convert.ToInt16(dtCasherAcc.Rows[i][0].ToString())) { txtAccNo.Text = (i + 1).ToString(); break; } } if (txtAccNo.Text == "") { txtAccNo.Text = (i + 1).ToString(); } // txtAccNo.Text = dtCasherAcc.Rows[0][0].ToString(); txtAccNo.Text = lstAccNo.Text + txtAccNo.Text.PadLeft(iLastLevelValue, '0'); lstAccName.SelectedValue = LstAcc.SelectedValue; lstAccNo.SelectedValue = LstAcc.SelectedValue; iRow_Parent = GetParentRow(lstAccNo.SelectedValue.ToString()); txtACC_SUBJECT.Text = dtAccData.Rows[iRow_Parent]["ACC_SUBJECT"].ToString(); } }
public void ChangeToString_ChangingListObjectsToString_ChangedAllObjectsToStrings() { string expected = " 1 "; myList <int> andrewslist = new myList <int>(); andrewslist[0] = 1; string actual = andrewslist.ToString(); Assert.AreNotEqual(expected, actual); }
public void Send(myList<byte> message) { if (_bUseTls == false) { _networkStream.Write(message.ToArray(), 0, message.Count); } else { _sslStream.Write(message.ToArray()); } }
public void ChangeToString_UsingToStringMethodWithNothingAddedToList_ResultOfNull() { // Arrange myList <int> andrewslist = new myList <int>(); string expected = " "; // Act string actual = andrewslist.ToString(); // Assert Assert.AreEqual(expected, actual); }
static void Main(string[] args) { myList <int> mylist = new myList <int>(new int[] { 23, 34, 987, 425, 246, 57764, 246, 75324, 6, 796758 }); Console.WriteLine(mylist[3]); mylist.Add(14); Console.WriteLine("Lenght: " + mylist.Length); foreach (var item in mylist) { Console.WriteLine(item); } Console.ReadKey(); }
public void TestingZipperMethod_AddingTwoEmptyListsTogether_RecieveEmptyArray() { //arrange myList <int> andrewslist = new myList <int>(); myList <int> andrewslist2 = new myList <int>(); myList <int> andrewslist3 = new myList <int>(); //act andrewslist3.ZipperDeeDooDah(andrewslist, andrewslist2); //assert Assert.AreEqual(andrewslist.ToString(), andrewslist2.ToString()); }
public void Insert_ElementsInList() { myList <int> ml = new myList <int>(); for (int i = 0; i < 3; i++) { ml.Insert(i, i); } string expected = "0 1 2 "; string actual = MyListToString(ml); Assert.AreEqual(expected, actual); }
public void Clear_ElementsInList() { myList <int> ml = new myList <int>(); for (int i = 0; i < 3; i++) { ml.Add(i); } ml.Clear(); string expected = ""; string actual = MyListToString(ml); Assert.AreEqual(expected, actual); }
public myList<byte> GetMessages() { myList<byte> ret = null; if (_messagesMutex.WaitOne(1000) == true) { if (_incomingMessages.Count > 0) { ret = new myList<byte>(_incomingMessages); _incomingMessages.Clear(); } _messagesMutex.ReleaseMutex(); } return ret; }
public myList pdfOlustur() { if (File.Exists(Server.MapPath("~/images/" + dosya))) { File.Delete(Server.MapPath("~/images/" + dosya)); } Rectangle mySize = new Rectangle(PageSize.A4.Width, 297.5f); iTextSharp.text.Document pdfDosya = new iTextSharp.text.Document(mySize, 0, 0, 28, 0); PdfWriter writer = PdfWriter.GetInstance(pdfDosya, new FileStream(Server.MapPath("~/images/" + dosya), FileMode.CreateNew)); myList lst = new myList(writer, pdfDosya); return(lst); }
public void Contains_ElementsInList() { myList <int> ml = new myList <int>(); for (int i = 0; i < 3; i++) { ml.Add(i); } bool result_1 = ml.Contains(1); bool result_2 = ml.Contains(3); string expected = "True False"; string actual = result_1 + " " + result_2; Assert.AreEqual(expected, actual); }
public void AddStringValueToIndex_AddStringAndrewtoindex_AddedAndrewToListIndex0() { //Arrange myList <string> andrewsList = new myList <string>(); string myName = "andrew"; string actual; string expected; //Act andrewsList.AddToMyList(myName); actual = andrewsList[0]; expected = "andrew"; //Assert Assert.AreEqual(expected, actual); }
private void lstAccNo_SelectedIndexChanged(object sender, EventArgs e) { myList lstParent = sender as myList; if (lstParent.SelectedValue == null || bLoad == true) { return; } if (lstParent.SelectedValue.ToString() != "System.Data.DataRowView" && lstParent.SelectedValue.ToString() != "") { lstAccNo.SelectedValue = lstAccName.SelectedValue = lstParent.SelectedValue; } }
public void Remove_ElementsFromList() { myList <int> ml = new myList <int>(); for (int i = 0; i < 5; i++) { ml.Add(4 - i); } //4 3 2 1 0 ml.Remove(3); ml.Remove(0); string expected = "4 2 1 "; string actual = MyListToString(ml); Assert.AreEqual(expected, actual); }
public void IndexOf_ElementsInList() { myList <int> ml = new myList <int>(); for (int i = 0; i < 3; i++) { ml.Add(2 - i); } //2 1 0 int result_1 = ml.IndexOf(1); int result_2 = ml.IndexOf(2); string expected = "1 0"; string actual = result_1 + " " + result_2; Assert.AreEqual(expected, actual); }
public void AddedIntValueToList_AddingInt7ToIndex_Added7ToListIndex0() { //Arrange myList <int> andrewsList = new myList <int>(); int newNumber = 7; int actual; int expected; //Act andrewsList.AddToMyList(newNumber); actual = andrewsList[0]; expected = 7; //Assert Assert.AreEqual(expected, actual); }
public void AddingDoubleToList_AddedDouble21ToString_Added21ToIndex1() { //arrange myList <double> andrewsList = new myList <double>(); double number = 21; double expected; double actual; //act andrewsList.AddToMyList(number); actual = andrewsList[0]; expected = 21; //assert Assert.AreEqual(expected, actual); }
public void Replace_ElementsInList() { myList <int> ml = new myList <int>(); for (int i = 0; i < 3; i++) { ml.Add(i); } for (int i = 0; i < 3; i++) { ml[i] = 2 - i; } string expected = "2 1 0 "; string actual = MyListToString(ml); Assert.AreEqual(expected, actual); }
public static void Main() { myList<int> lst = new myList<int>(); lst.addItem(10); lst.addItem(20); lst.addItem(30); foreach (var i in lst.getItems()) { Console.WriteLine(i); } lst.removeItem(20); foreach (var i in lst.getItems()) { Console.WriteLine(i); } Console.ReadLine(); }
private void Groups_SelectionChanged(object sender, SelectionChangedEventArgs e) { Students.Items.Clear(); string groupId = ""; foreach (myList g in groups) { Console.WriteLine(g.name + "\t" + Groups.SelectedValue.ToString()); if (g.name == Groups.SelectedValue.ToString()) { groupId = g.id.ToString(); } } MySqlConnection conn = new MySqlConnection(myConnStr); try { conn.Open(); string sql = "SELECT id, surname FROM students WHERE Groups_id = " + groupId; Console.WriteLine(sql); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { myList it = new myList(); try { it.id = Convert.ToInt32(rdr[0].ToString()); it.name = rdr[1].ToString(); students.Add(it); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } Students.Items.Add(rdr[1].ToString()); } rdr.Close(); conn.Close(); } catch (MySqlException ex) { Console.WriteLine(ex.ToString()); } }
private void Subjects_SelectionChanged(object sender, SelectionChangedEventArgs e) { // SELECT id, name FROM mydb.themes WHERE Subjects_id = {var}; Themes.Items.Clear(); string subjectId = ""; foreach (myList s in subjects) { Console.WriteLine(s.name + "\t" + Subjects.SelectedValue.ToString()); if (s.name == Subjects.SelectedValue.ToString()) { subjectId = s.id.ToString(); } } MySqlConnection conn = new MySqlConnection(myConnStr); try { conn.Open(); string sql = "SELECT id, name FROM themes WHERE Subjects_id = " + subjectId; Console.WriteLine(sql); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { myList it = new myList(); try { it.id = Convert.ToInt32(rdr[0].ToString()); it.name = rdr[1].ToString(); themes.Add(it); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } Themes.Items.Add(rdr[1].ToString()); } rdr.Close(); conn.Close(); } catch (MySqlException ex) { Console.WriteLine(ex.ToString()); } }
private void submit_Click(object sender, EventArgs e) { var item1 = new myList { listName = tName.Text, listDescription = tDescription.Text, assigned = tAssigned.Text, state = tCompleted.Text }; listBox1.Items.Add(item1.listName); listLog.Add(item1); tName.Text = ""; tDescription.Text = ""; tAssigned.Text = ""; tCompleted.Text = ""; //put created item in the database try { if (userID != "")//if there is a valid user id { nameLabel.Text = userID; string connectionString2 = "datasource=127.0.0.1;port=3306;username=root;password=;database=tms;"; string insertItem = "insert into itemTable(itemName, itemDetail, itemAssignedUserID, itemCreateUserID, itemCreateDT, itemUpdateUserID, itemState) " + "values( '" + item1.listName + "', '" + item1.listDescription + "', '" + userID + "', '" + userID + "', '" + DateTime.Now + "', '" + userID + "', 'O') ;"; MySqlConnection dbConnect = new MySqlConnection(connectionString2); MySqlCommand myCommand = new MySqlCommand(insertItem, dbConnect); dbConnect.Open(); MySqlDataReader myReader = myCommand.ExecuteReader(); while (myReader.Read()) { } dbConnect.Close(); } else { errorLabel.Text = "Sign in to save items"; } } catch (Exception ex) { errorLabel.Text = ex.Message; } }
public void AddingTwoStringsToList_Adding_pizza_chickenToList_Index2ShouldBeChicken() { //Arrange myList <string> andrewsList = new myList <string>(); string pizza = "pizza"; string chicken = "chicken"; string actual; string expected; //Act andrewsList.AddToMyList(pizza); andrewsList.AddToMyList(chicken); actual = andrewsList[0]; expected = "pizza"; //Assert Assert.AreEqual(expected, actual); }
public void AddingNewNumberToIndex_AddingInt9toIndex1_Added9ToIndex1() { //Arrange myList <int> andrewsList = new myList <int>(); int newNumber = 7; int newNumber1 = 9; int actual; int expected; //Act andrewsList.AddToMyList(newNumber); andrewsList.AddToMyList(newNumber1); actual = andrewsList[1]; expected = 9; //Assert Assert.AreEqual(expected, actual); }
public void TestingZipperMethod_AddingTwoListsTogether_ZippingTwoLists() { //arrange myList <int> andrewslist = new myList <int>(); myList <int> andrewslist2 = new myList <int>(); myList <int> andrewslist3 = new myList <int>(); andrewslist[0] = 1; andrewslist[1] = 3; andrewslist2[0] = 2; andrewslist2[1] = 4; //act andrewslist3.ZipperDeeDooDah(andrewslist, andrewslist2); //Assert Assert.AreNotEqual(andrewslist3[1].ToString(), "3"); }
public void AddingTwoStrings_AddedString1AndString2Together_SumofString1AndString2() { //arrange myList <int> andrewslist = new myList <int>(); myList <int> andrewslist2 = new myList <int>(); myList <int> andrewslist3 = new myList <int>(); andrewslist[0] = 1; andrewslist[1] = 2; andrewslist2[0] = 3; andrewslist2[1] = 4; //act andrewslist3 = andrewslist + andrewslist2; //assert Assert.AreNotEqual(andrewslist3, andrewslist + andrewslist2); }
static string ConvertMsgToString(myList<byte> msgs) { return Encoding.UTF8.GetString(msgs.ToArray(), 0, msgs.Count); }