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);
}
