public void readData()
{
using (MySqlConnection conn = connect.connector())
{
string query = "SELECT * FROM orderlist INNER JOIN itemdetails ON orderlist.item_id = itemdetails.itemID" +
" WHERE status = 1";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Columns["item_id"].Visible = false;
dataGridView1.Columns["quantity"].Visible = false;
dataGridView1.Columns["status"].Visible = false;
dataGridView1.Columns["id"].Visible = false;
dataGridView1.Columns["quantity_delivered"].Visible = false;
dataGridView1.Columns["date_of_creation"].Visible = false;
dataGridView1.Columns["itemstatus"].Visible = false;
dataGridView1.Columns["item_code"].Visible = true;
dataGridView1.Columns["itemID"].Visible = false;
dataGridView1.Columns["date"].HeaderText = "Date To Be Delivered";
dataGridView1.Columns["item_code"].HeaderText = "Item Code";
dataGridView1.Columns["date_created"].Visible = false;
dataGridView1.Columns["vendor"].HeaderText = "Vendor";
dataGridView1.Columns["description"].HeaderText = "Item Desc.";
dataGridView1.Columns["itemname"].HeaderText = "Item Name.";
dataGridView1.Columns["date_modified"].Visible = false;
}
}
private void idfinder(string x)
{
using (MySqlConnection conn = connect.connector())
{
string query = "SELECT * FROM sectionnames WHERE section_name = '" + x + "';";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
sectionid = dt.Rows[0]["idsnames"].ToString();
}
}
private void btnconfirm_Click(object sender, EventArgs e)
{
if (!itemcheck(txtitemname.Text, txtdesc.Text))
{
DialogResult res = MessageBox.Show("CONFIRM ITEM CREATION!", "CONFIRM!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
using (var command = new MySqlCommand("INSERT INTO itemdetails(item_code, date_of_creation, description, itemstatus, itemname) VALUES(@item_code, @date_of_creation, @description, @itemstatus, @itemname);", dbconnection))
{
dbconnection.Open();
command.Parameters.AddWithValue("@item_code", txtitemcode.Text);
command.Parameters.AddWithValue("@date_of_creation", DateTime.Now.ToString("yyyy-MM-dd"));
command.Parameters.AddWithValue("@description", txtdesc.Text);
command.Parameters.AddWithValue("@itemstatus", 1);
command.Parameters.AddWithValue("@itemname", txtitemname.Text);
command.ExecuteNonQuery();
}
}
MessageBox.Show("Item Successfully Created!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
reference.Show();
reference.readData();
}
}
}
private void flagtoclearorderlist()
{
var a = 0;
var b = 0;
using (MySqlConnection conn = connect.connector())
{
conn.Open();
string query = "SELECT * FROM orderlist WHERE id = '" + orderlistID + "';";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
a = Convert.ToInt32(dt.Rows[0]["quantity_delivered"].ToString());
b = Convert.ToInt32(dt.Rows[0]["quantity"].ToString());
}
if (a == b)
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
using (var com = new MySqlCommand("UPDATE orderlist SET status = @stat WHERE id = '" + orderlistID + "';", dbconnection))
{
com.Parameters.AddWithValue("@stat", 2);
com.ExecuteNonQuery();
}
}
MessageBox.Show("ORDER DELIVERY HAS BEEN COMPLETED!, PLEASE REFER TO ORDER LIST MANAGEMENT FOR LIST OF COMPELETED ORDERS", "ATTENTION!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
}
}
private void updater2()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
string query2 = "UPDATE payment SET paymentStatus = @status WHERE pid = @ayd";
using (var command2 = new MySqlCommand(query2, dbconnection))
{
if (comboBox1.Text == "Validated")
{
command2.Parameters.AddWithValue("@status", 1);
}
else if (comboBox1.Text == "Pending")
{
command2.Parameters.AddWithValue("@status", 2);
}
else
{
command2.Parameters.AddWithValue("@status", 3);
}
command2.Parameters.AddWithValue("@ayd", dict["pid"]);
command2.ExecuteNonQuery();
}
}
}
private Boolean studentcheck2(string fn, string ln, string mn)
{
var connect = new dbConnector();
using (MySqlConnection conn = connect.connector())
{
string query = "SELECT * FROM studentprofile WHERE FirstName = '" + fn + "' " +
"AND idstudentprofile <> '" + idstud + "' " +
"AND MiddleName = '" + mn + "' " +
"AND idstudentprofile <> '" + idstud + "' " +
"AND LastName = '" + ln + "' " +
"AND idstudentprofile <> '" + idstud + "';";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
MessageBox.Show("STUDENT WITH THE SAME NAME HAS ALREADY BEEN ENROLLED!", "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(true);
}
else
{
return(false);
}
}
}
private void button6_Click(object sender, EventArgs e)
{
if (checkifcheckerchecked())
{
DialogResult res = MessageBox.Show("SELECTED STUDENT/S WILL BE REMOVED FROM CURRENT SECTIONS!", "WARNING!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (res == DialogResult.OK)
{
idlistgrabber();
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
foreach (string id in stdlistid)
{
string query2 = "UPDATE studdetails SET section = @sec, sectionid = @secid WHERE idstddet = @idstud;";
using (var command2 = new MySqlCommand(query2, dbconnection))
{
command2.Parameters.AddWithValue("@sec", null);
command2.Parameters.AddWithValue("@secid", null);
command2.Parameters.AddWithValue("@idstud", id);
command2.ExecuteNonQuery();
}
}
}
loadData();
loadData2();
}
}
}
private void btnAdd2_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("Confirm Order Creation!", "CONFIRM ACTION!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (res == DialogResult.OK)
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
using (var command = new MySqlCommand("INSERT INTO orderlist(date_created, date, vendor, quantity, quantity_delivered, status, item_id) VALUES(@date_created, @date, @vendor, @quantity, @quantity_delivered, @status, @item_id);", dbconnection))
{
dbconnection.Open();
command.Parameters.AddWithValue("@item_name", itemname);
command.Parameters.AddWithValue("@date_created", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
command.Parameters.AddWithValue("@date", dateDate.Value.Date.ToString("yyyy-MM-dd"));
command.Parameters.AddWithValue("@vendor", txtvendor.Text);
command.Parameters.AddWithValue("@quantity", txtquantity2.Text);
command.Parameters.AddWithValue("@quantity_delivered", 0);
command.Parameters.AddWithValue("@status", 1);
command.Parameters.AddWithValue("@item_id", itemid);
command.ExecuteNonQuery();
}
}
MessageBox.Show("Order Succssesfully Created!");
txtboxdeleter();
readData();
readDataOrderList();
}
}
public void readData()
{
using (MySqlConnection conn = connect.connector())
{
string query = "SELECT * FROM itemdetails WHERE itemstatus = 0;";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Columns["itemID"].Visible = false;
dataGridView1.Columns["itemstatus"].Visible = false;
dataGridView1.Columns["date_modified"].HeaderText = "Date Modified";
dataGridView1.Columns["item_code"].HeaderText = "Item Code";
dataGridView1.Columns["date_of_creation"].HeaderText = "Date of Creation";
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
if (dataOrderList.SelectedRows.Count > 0)
{
DialogResult res = MessageBox.Show("Confirm Order Cancellation!", "CONFIRM ACTION!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (res == DialogResult.OK)
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
using (var command = new MySqlCommand("UPDATE orderlist SET status = @stat WHERE id = @ayd;", dbconnection))
{
dbconnection.Open();
command.Parameters.AddWithValue("@stat", 0);
command.Parameters.AddWithValue("@ayd", ordid);
command.ExecuteNonQuery();
}
}
MessageBox.Show("Order Succssesfully Cancelled!");
readData();
readDataOrderList();
readDataOrderListCanceled();
readDataOrderListCompl();
dataOrderList.ClearSelection();
}
}
else
{
MessageBox.Show("There is no item currently selected", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void editData()
{
if (!itemchecker(txtitemname.Text, txtdesc.Text))
{
MySqlConnection conn = connect.connector();
String query = "UPDATE itemdetails SET item_code ='" + txtitemcode.Text +
"', description ='" + txtdesc.Text +
"', itemname ='" + txtitemname.Text +
"', date_modified = '" + DateTime.Now.ToString("yyyy-MM-dd") +
"' WHERE itemID ='" + dic["ayd"] + "'";
MySqlCommand command = new MySqlCommand(query, conn);
try
{
conn.Open();
command.ExecuteNonQuery();
MessageBox.Show("Successfully Updated");
this.Close();
reference.Show();
reference.readData();
reference.dataGridView1.ClearSelection();
}
catch (Exception)
{
MessageBox.Show("Invalid");
}
}
}
public void loadData()
{
var dbconnect = new dbConnector();
string query = "select * from studentprofile inner join studdetails on studentprofile.idstudentprofile = studdetails.idstddet WHERE studentprofile.Status = 1;";
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
MySqlDataAdapter ad = new MySqlDataAdapter(query, dbconnection);
DataSet data = new DataSet();
ad.Fill(data);
dataGridView1.DataSource = data.Tables[0];
dataGridView1.Columns["idstudentprofile"].Visible = true;
dataGridView1.Columns["FirstName"].Visible = true;
dataGridView1.Columns["LastName"].Visible = true;
dataGridView1.Columns["MiddleName"].Visible = true;
dataGridView1.Columns["DateOfBirth"].Visible = true;
dataGridView1.Columns["PlaceOfBirth"].Visible = false;
dataGridView1.Columns["Sex"].Visible = true;
dataGridView1.Columns["Religion"].Visible = false;
dataGridView1.Columns["Nickname"].Visible = false;
dataGridView1.Columns["idstuddet"].Visible = false;
dataGridView1.Columns["Status"].Visible = false;
dataGridView1.Columns["department"].Visible = false;
dataGridView1.Columns["level"].Visible = false;
dataGridView1.Columns["school_year"].Visible = false;
dataGridView1.Columns["idstddet"].Visible = false;
dataGridView1.Columns["section"].Visible = true;
dataGridView1.Columns["sectionid"].Visible = false;
dataGridView1.Columns["image_path"].Visible = false;
dataGridView1.Columns["idstudentprofile"].ReadOnly = true;
dataGridView1.Columns["FirstName"].ReadOnly = true;
dataGridView1.Columns["LastName"].ReadOnly = true;
dataGridView1.Columns["MiddleName"].ReadOnly = true;
dataGridView1.Columns["DateOfBirth"].ReadOnly = true;
dataGridView1.Columns["PlaceOfBirth"].ReadOnly = true;
dataGridView1.Columns["Sex"].ReadOnly = true;
dataGridView1.Columns["Religion"].ReadOnly = true;
dataGridView1.Columns["Nickname"].ReadOnly = true;
dataGridView1.Columns["idstuddet"].ReadOnly = true;
dataGridView1.Columns["Status"].ReadOnly = true;
dataGridView1.Columns["department"].ReadOnly = true;
dataGridView1.Columns["level"].ReadOnly = true;
dataGridView1.Columns["school_year"].ReadOnly = true;
dataGridView1.Columns["idstddet"].ReadOnly = true;
dataGridView1.Columns["section"].ReadOnly = true;
dataGridView1.Columns["sectionid"].ReadOnly = true;
dataGridView1.Columns["image_path"].ReadOnly = true;
dataGridView1.Columns["idstudentprofile"].HeaderText = "Student ID No.";
dataGridView1.Columns["level_dummyval"].HeaderText = "Level";
dataGridView1.Columns["FirstName"].HeaderText = "First Name";
dataGridView1.Columns["LastName"].HeaderText = "Last Name";
dataGridView1.Columns["MiddleName"].HeaderText = "Middle Name";
dataGridView1.Columns["DateOfBirth"].HeaderText = "Date of Birth";
}
dbconnection.Close();
}
public Boolean statusFlag()
{
var dbconnector = new dbConnector();
using (dbconnect = dbconnector.connector())
{
dbconnect.Open();
MySqlCommand query = new MySqlCommand("SELECT * from usertable inner join employee on " +
"usertable.idemp = employee.empID " +
"where usertable.username = '******' " +
"and usertable.password = '******' and usertable.status = 1;", dbconnect);
MySqlDataAdapter listener = new MySqlDataAdapter(query);
DataTable holder = new DataTable();
listener.Fill(holder);
//MessageBox.Show(perm.Substring(0,1));
if (holder.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
private void btnAddFee_Click(object sender, EventArgs e)
{
if (textboxvalidate())
{
DialogResult res = MessageBox.Show("PROCEED WITH CREATING VOUCHER?", "WARNING!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
string query2 = "INSERT INTO disbursement(Voucher_Number, Amount, Details, Date_recorded, empID, syear) VALUES(@vn, @amnt, @details, @date, @eid, @syear);";
using (var command2 = new MySqlCommand(query2, dbconnection))
{
command2.Parameters.AddWithValue("@vn", SerialMaker());
command2.Parameters.AddWithValue("@amnt", textBox2.Text);
command2.Parameters.AddWithValue("@details", textBox1.Text);
command2.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd"));
command2.Parameters.AddWithValue("@eid", empId);
command2.Parameters.AddWithValue("@syear", syear);
command2.ExecuteNonQuery();
}
}
MessageBox.Show("Voucher Created Sucessfully");
this.Close();
reference.loadDisbursementtbl();
}
}
else
{
MessageBox.Show("PLEASE FILL ALL NECESSARY FIELDS!", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void readData()
{
using (MySqlConnection conn = connect.connector())
{
string query = "SELECT invID, item_code, itemname, description, stock_in_date, stock_out_date, Quantity, Status FROM inventory INNER JOIN itemdetails ON inventory.item_id = itemdetails.itemID WHERE inventory.status = 1;";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
dgvInventory.DataSource = dt;
}
dgvInventory.Columns["invID"].Visible = false;
dgvInventory.Columns["Status"].Visible = false;
dgvInventory.Columns["stock_in_date"].HeaderText = "Stock In Date";
dgvInventory.Columns["stock_out_date"].HeaderText = "Stock Out Date";
dgvInventory.Columns["item_code"].HeaderText = "Item Code";
dgvInventory.Columns["itemname"].HeaderText = "Item Name";
dgvInventory.Columns["description"].HeaderText = "Item Description";
}
public void readData()
{
using (MySqlConnection conn = connect.connector())
{
conn.Open();
string query = "SELECT * FROM itemdetails";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
dataItemCreation.DataSource = dt;
dataItemCreation.Columns["itemID"].Visible = false;
dataItemCreation.Columns["itemstatus"].Visible = false;
dataItemCreation.Columns["item_code"].HeaderText = "Item Code";
dataItemCreation.Columns["date_of_creation"].HeaderText = "Date Created";
dataItemCreation.Columns["description"].HeaderText = "Item Description";
dataItemCreation.Columns["itemname"].HeaderText = "Item Name";
dataItemCreation.Columns["date_modified"].HeaderText = "Date Modified";
}
}
private Int32 counters()
{
var dbconnect = new dbConnector();
string query = "SELECT COUNT(idstudentprofile) FROM studentprofile;";
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
var cmd = new MySqlCommand(query, dbconnection);
return(Convert.ToInt32(cmd.ExecuteScalar()));
}
}
private void updater()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
string query2 = "UPDATE payment SET paymentStatus = @status WHERE pid = @ayd";
using (var command2 = new MySqlCommand(query2, dbconnection))
{
if (comboBox1.Text == "Validated")
{
command2.Parameters.AddWithValue("@status", 1);
}
else if (comboBox1.Text == "Pending")
{
command2.Parameters.AddWithValue("@status", 2);
}
else
{
command2.Parameters.AddWithValue("@status", 3);
}
command2.Parameters.AddWithValue("@ayd", dict["pid"]);
command2.ExecuteNonQuery();
}
}
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
string queryy = "UPDATE accountdetails SET paid_amount = @paidamount WHERE adid = @ayd;";
using (var command2 = new MySqlCommand(queryy, dbconnection))
{
command2.Parameters.AddWithValue("@ayd", dict["adid"]);
command2.Parameters.AddWithValue("@paidamount", amnt.Text.TrimStart('₱'));
command2.ExecuteNonQuery();
}
}
}
private void deactivator()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
using (var command = new MySqlCommand("UPDATE inventory SET status = 0, invID = @ayd;", dbconnection))
{
dbconnection.Open();
command.Parameters.AddWithValue("@ayd", invid);
command.ExecuteNonQuery();
}
}
}
public void getsyear()
{
using (MySqlConnection conn = connect.connector())
{
conn.Open();
string query = "SELECT * FROM schoolyear WHERE statussyear = 'OPEN';";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
lblsy.Text = dt.Rows[0]["syear"].ToString();
}
}
}
private void updateorderlist()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
using (var com = new MySqlCommand("UPDATE orderlist SET quantity_delivered = @qdel WHERE id = '" + orderlistID + "';", dbconnection))
{
com.Parameters.AddWithValue("@qdel", solver().ToString());
com.Parameters.AddWithValue("@status", 1);
com.ExecuteNonQuery();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (lblsy.Text != "NO S.Y. SELECTED")
{
var dbconnector = new dbConnector();
using (dbconnect = dbconnector.connector())
{
dbconnect.Open();
MySqlCommand query = new MySqlCommand("SELECT * from usertable inner join employee on " +
"usertable.idemp = employee.empID " +
"where usertable.username = '******' " +
"and usertable.password = '******';", dbconnect);
MySqlDataAdapter listener = new MySqlDataAdapter(query);
DataTable holder = new DataTable();
listener.Fill(holder);
//MessageBox.Show(perm.Substring(0,1));
if (holder.Rows.Count > 0)
{
string perm = holder.Rows[0]["restrictions"].ToString();
//string[] split = perm.Split(' ')
if (statusFlag())
{
uname = holder.Rows[0]["last_name"].ToString() + ", " + holder.Rows[0]["first_name"].ToString();
MessageBox.Show("WELCOME TO SILA SCHOOL MANAGEMENT SYSTEM!", "WELCOME!", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmmain = new frmMain(uname, perm);
frmmain.schoolyear = lblsy.Text;
frmmain.Show();
frmmain.reference = this;
this.Hide();
}
else
{
MessageBox.Show("This Account is no longer active", "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("WRONG CREDENTIALS!", "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("There is no currently opened School Year!", "WARNING!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void updatevalue()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
studdetails(comboBox3.Text, comboBox2.Text);
//MessageBox.Show(studdet["dept"]);
using (var command = new MySqlCommand("UPDATE studentprofile set FirstName = @fn, LastName = @ln, MiddleName = @mn, DateOfBirth = @dof, PlaceOfBirth = @pof, Sex = @sex, Religion = @rel, Nickname = @nickname, image_path = @imgpt WHERE idstudentprofile = @ayd;", dbconnection))
{
command.Parameters.AddWithValue("@ayd", idstud);
command.Parameters.AddWithValue("@fn", txtfn.Text);
command.Parameters.AddWithValue("@ln", txtln.Text);
command.Parameters.AddWithValue("@mn", txtmn.Text);
command.Parameters.AddWithValue("@dof", dateTimePicker1.Value.ToString("yyyy-MM-dd"));
command.Parameters.AddWithValue("@pof", txtbp.Text);
command.Parameters.AddWithValue("@sex", comboBox1.Text);
if (comboBox4.Text == "Others")
{
command.Parameters.AddWithValue("@rel", textBox1.Text);
}
else
{
command.Parameters.AddWithValue("@rel", comboBox4.Text);
}
command.Parameters.AddWithValue("@nickname", txtnn.Text);
command.Parameters.AddWithValue("@imgpt", imgpath);
command.ExecuteNonQuery();
}
using (var command = new MySqlCommand("UPDATE studdetails SET level_dummyval = @lvldval, department = @dept, level = @lvl WHERE idstddet = @ayd", dbconnection))
{
command.Parameters.AddWithValue("@ayd", idstud);
command.Parameters.AddWithValue("@dept", studdet["dept"]);
command.Parameters.AddWithValue("@lvl", studdet["level"]);
//command.Parameters.AddWithValue("@sy", lblsy.Text);
command.Parameters.AddWithValue("@lvldval", comboBox2.Text);
//need to update query to insert department integer value
command.ExecuteNonQuery();
}
using (var command = new MySqlCommand("UPDATE accountdetails SET fid = @fid WHERE spid = @ayd", dbconnection))
{
command.Parameters.AddWithValue("@ayd", idstud);
command.Parameters.AddWithValue("@fid", studdet["feelevel"]);
command.ExecuteNonQuery();
}
}
}
private Boolean doublenamecheck(string fn, string ln, string mn)
{
var connect = new dbConnector();
using (MySqlConnection conn = connect.connector())
{
string query = "";
dt = new DataTable();
adapter = new MySqlDataAdapter(query, conn);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
}
}
return(false);
}
private void updateinv()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
using (var command = new MySqlCommand("UPDATE inventory SET quantity = @quantity, stock_out_date = @sod WHERE invID = @ayd;", dbconnection))
{
dbconnection.Open();
command.Parameters.AddWithValue("@quantity", quantityadder());
command.Parameters.AddWithValue("@sod", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
command.Parameters.AddWithValue("@ayd", invid);
command.ExecuteNonQuery();
}
}
}
private void updateInventory()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
using (var com = new MySqlCommand("UPDATE inventory SET stock_in_date = @stock_in_date, Quantity = @Quantity, status = @status WHERE item_id = @itemayd AND status <> 0;", dbconnection))
{
com.Parameters.AddWithValue("@itemayd", itemid);
com.Parameters.AddWithValue("@stock_in_date", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
com.Parameters.AddWithValue("@Quantity", inventorysolver().ToString());
com.Parameters.AddWithValue("@status", 1);
com.ExecuteNonQuery();
}
}
}
private void insertintoInventory()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
using (var com = new MySqlCommand("INSERT INTO inventory(item_id, stock_in_date, Quantity, status) VALUES(@item_id, @stock_in_date, @Quantity, @status)", dbconnection))
{
com.Parameters.AddWithValue("@item_id", itemid);
com.Parameters.AddWithValue("@stock_in_date", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
com.Parameters.AddWithValue("@Quantity", txtEnter.Text);
com.Parameters.AddWithValue("@status", 1);
com.ExecuteNonQuery();
}
}
}
private string SerialMaker()
{
Int32 a;
string date = DateTime.Now.ToString("yyyyMMdd");
string query2 = "SELECT COUNT(*) FROM disbursement";
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
using (var command2 = new MySqlCommand(query2, dbconnection))
{
dbconnection.Open();
a = Convert.ToInt32(command2.ExecuteScalar().ToString());
}
}
return(date + a.ToString("20000"));
}
private void createfunction2()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
string query3 = "INSERT INTO accountdetails(paid_amount, spid, fid) VALUES(@paid_amount, @spid, @fid);";
IDictionary <string, string> dic = comboboxpicker();
using (var command3 = new MySqlCommand(query3, dbconnection))
{
command3.Parameters.AddWithValue("@paid_amount", 0);
command3.Parameters.AddWithValue("@spid", counters().ToString());
command3.Parameters.AddWithValue("@fid", dic["feelevel"]);
command3.ExecuteNonQuery();
}
}
}
private void insertstkout()
{
var dbconnect = new dbConnector();
using (dbconnection = dbconnect.connector())
{
dbconnection.Open();
using (var com = new MySqlCommand("INSERT INTO stkout(inventory_id, stockout_date, quantity, statusout) VALUES(@invid, @date, @quan, @sout)", dbconnection))
{
com.Parameters.AddWithValue("@invid", invid);
com.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
com.Parameters.AddWithValue("@quan", textBox2.Text);
com.Parameters.AddWithValue("@sout", comboBox1.Text);
com.ExecuteNonQuery();
}
}
}