public SPO(TypeofAgreementMenu tam)
{
InitializeComponent();
this.tam = tam;
MySqlConnection cnn = new MySqlConnection("server=code4cat.me; user id=jackysc; password=123456; database=procurement;SslMode=none");
cnn.Open();
String query = "select * from SPO ORDER BY SPONo ASC;";
MySqlCommand cmd = new MySqlCommand(query, cnn);
MySqlDataAdapter ada = new MySqlDataAdapter(query, cnn);
DataTable dt = new DataTable();
ada.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
ListViewItem listitem = new ListViewItem(dr["SPONo"].ToString());
listitem.SubItems.Add(dr["SupplierNo"].ToString());
listitem.SubItems.Add(dr["CreationDate"].ToString());
listitem.SubItems.Add(dr["EffectiveDate"].ToString());
listitem.SubItems.Add(dr["BuyerName"].ToString());
listitem.SubItems.Add(dr["BillingAddress"].ToString());
listitem.SubItems.Add(dr["BuyerAccount"].ToString());
listitem.SubItems.Add(dr["RestNo"].ToString());
listitem.SubItems.Add(dr["ExpectedDeliveryDate"].ToString());
listitem.SubItems.Add(dr["TermsAndCondition"].ToString());
listView1.Items.Add(listitem);
}
dateTimeCompare();
}
public Form1(TypeofAgreementMenu tam)
{
InitializeComponent();
this.tam = tam;
MySqlConnection cnn = new MySqlConnection("server=code4cat.me; user id=jackysc; password=123456; database=procurement;SslMode=none");
cnn.Open();
String query = "select * from BlanketPurchaseAgreement ORDER BY BPANo ASC;";
MySqlCommand cmd = new MySqlCommand(query, cnn);
MySqlDataAdapter ada = new MySqlDataAdapter(query, cnn);
DataTable dt = new DataTable();
ada.Fill(dt);
CultureInfo arSA = new CultureInfo("ar-SA");
arSA.DateTimeFormat.Calendar = new UmAlQuraCalendar();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
ListViewItem listitem = new ListViewItem(dr["BPANo"].ToString());
listitem.SubItems.Add(dr["RequestNo"].ToString());
listitem.SubItems.Add(dr["PurchaseOrderRevision"].ToString());
listitem.SubItems.Add(dr["CreationDate"].ToString());
listitem.SubItems.Add(dr["EffectiveDate"].ToString());
listitem.SubItems.Add(dr["BuyerName"].ToString());
listitem.SubItems.Add(dr["BillingAddress"].ToString());
listitem.SubItems.Add(dr["AmountAgreed"].ToString());
listitem.SubItems.Add(dr["Currency"].ToString());
listitem.SubItems.Add(dr["TermsAndCondition"].ToString());
listitem.SubItems.Add(dr["SupplierNo"].ToString());
listView1.Items.Add(listitem);
}
DateTime now = DateTime.Now;
DateTime effectiveDate;
int datecompare;
for (int i = 0; i < listView1.Items.Count; i++)
{
effectiveDate = DateTime.Parse(listView1.Items[i].SubItems[4].Text);
datecompare = DateTime.Compare(now, effectiveDate);
if (datecompare > 0)
{
listView1.Items[i].BackColor = Color.Yellow;
}
else
{
continue;
}
}
//textBox1.Text = datecompare.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
switch (deptCode)
{
case "AM":
this.Hide();
EditMenu em = new EditMenu(this, 0);
em.Show();
break;
case "RM":
this.Hide();
PurchaseRequest pr = new PurchaseRequest(this, restNo, StaffNo);
pr.Show();
break;
case "PM":
this.Hide();
TypeofAgreementMenu tam = new TypeofAgreementMenu(staffName, this);
tam.Show();
break;
case "CM":
this.Hide();
Category cat = new Category(this);
cat.Show();
break;
case "WC":
this.Hide();
WHViewDPI dpi = new WHViewDPI(this);
dpi.Show();
break;
case "AD":
this.Hide();
TypeofAgreementMenu adtam = new TypeofAgreementMenu(staffName, this);
adtam.Show();
break;
}
}