private void AddData()
{
string name = txtName.Text;
string device = txtDevice.Text;
string note = txtNote.Text;
string fault = txtFault.Text;
string number = txtNumber.Text;
string user = txtUser.Text;
string date = DateTime.Now.ToString("yyyy-MM-dd");
if (name == "")
{
ErrorMsg.msg("Please enter name");
Error er = new Error();
er.ShowDialog();
return;
}
if (device == "")
{
ErrorMsg.msg("Please enter device");
Error er = new Error();
er.ShowDialog();
return;
}
if (note == "")
{
note = "No note";
}
if (fault == "")
{
ErrorMsg.msg("Please enter fault");
Error er = new Error();
er.ShowDialog();
return;
}
if (number != "")
{
if (number.Length != 10)
{
ErrorMsg.msg("Number should be 10 digit");
Error er = new Error();
er.ShowDialog();
return;
}
}
else
{
ErrorMsg.msg("Please enter number");
Error er = new Error();
er.ShowDialog();
return;
}
string[] data = { (++no).ToString(), name, device, note, fault, date, number, user };
ADDdataGridView.Rows.Add(data);
resetControl();
}
private void deleteCustomer()
{
try
{
con = new MySqlConnection(cs);
string query = "delete from customer where id=@id";
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", _cust_id);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
ErrorMsg.msg("Delete successfully");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
MessageBox.Show("No internet connection");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
this.Hide();
}
}
}
private void searchByDate_Click(object sender, EventArgs e)
{
DateTime datefrom = dateFrom.Value;
DateTime dateto = dateTo.Value;
if (dateto.ToString() != "" || dateto != null)
{
if (datefrom.ToString() != "" || datefrom != null)
{
if (dateTo.Value >= dateFrom.Value)
{
SearchByDateFun();
}
else
{
ErrorMsg.msg("Invalid date selection");
Error er = new Error();
er.ShowDialog();
}
}
else
{
ErrorMsg.msg("Enter first date");
Error er = new Error();
er.ShowDialog();
}
}
else
{
ErrorMsg.msg("Enter first date");
Error er = new Error();
er.ShowDialog();
}
}
private void btnLogin_ClickAsync(object sender, EventArgs e)
{
string username = txtUsername.Text;
string password = txtPassword.Text;
if (username != "")
{
if (password != "")
{
loginForm(username, password);
}
else
{
ErrorMsg.msg("Enter password");
Error er = new Error();
er.ShowDialog();
return;
}
}
else
{
ErrorMsg.msg("Enter username");
Error er = new Error();
er.ShowDialog();
return;
}
}
private void searchPending()
{
string searchPending = txtPendingSearch.Text;
if (searchPending == "")
{
ErrorMsg.msg("Please enter search name");
Error er = new Error();
er.ShowDialog();
return;
}
con = new MySqlConnection(cs);
string query = "select * from replacement where cust_name like @name";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@name", searchPending + "%");
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
PENDINGdatagrid.Rows.Clear();
while (dr.Read())
{
string[] data = { dr.GetString(1), dr.GetString(2), dr.GetString(8), dr.GetString(3), dr.GetString(9), dr.GetString(7), dr.GetString(10), dr.GetString(13), dr.GetString(4), dr.GetString(5), dr.GetString(6), dr.GetString(14), dr.GetInt32(0).ToString(), dr.GetInt32(11).ToString(), dr.GetInt32(12).ToString() };
PENDINGdatagrid.Rows.Add(data);
}
}
else
{
ErrorMsg.msg("No data found");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void insertData()
{
int a = 0;
try
{
con = new MySqlConnection(cs);
con.Open();
for (int i = 0; i < ADDdataGridView.Rows.Count; i++)
{
string query = "insert into customer( Name,Device, Note, Fault, Number, User,receipt_no) values ( @name, @device, @note, @fault, @number, @user,@receipt_no)";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@name", ADDdataGridView.Rows[i].Cells[1].Value);
cmd.Parameters.AddWithValue("@device", ADDdataGridView.Rows[i].Cells[2].Value);
cmd.Parameters.AddWithValue("@note", ADDdataGridView.Rows[i].Cells[3].Value);
cmd.Parameters.AddWithValue("@fault", ADDdataGridView.Rows[i].Cells[4].Value);
cmd.Parameters.AddWithValue("@number", ADDdataGridView.Rows[i].Cells[6].Value);
cmd.Parameters.AddWithValue("@user", ADDdataGridView.Rows[i].Cells[7].Value);
cmd.Parameters.AddWithValue("@receipt_no", receiptNo.Text);
a += cmd.ExecuteNonQuery();
}
if (a > 0)
{
ErrorMsg.msg("Data insert successfully");
Error er = new Error();
er.ShowDialog();
getPrint();
resetControl();
ADDdataGridView.Rows.Clear();
no = 0;
getReceiptNo();
return;
}
else
{
ErrorMsg.msg("Data insertion failed");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
MessageBox.Show("Check internet connection");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void deleteReplacement()
{
int id;
if (ReplaceNumber.Text == "")
{
ErrorMsg.msg("Please select any row");
Error er = new Error();
er.ShowDialog();
return;
}
else
{
id = Convert.ToInt32(ReplaceNumber.Text);
}
con = new MySqlConnection(cs);
string query = "delete from replacement where id=@id";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", id);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
ErrorMsg.msg("Deleted successfully");
Error er = new Error();
er.ShowDialog();
resetEdit();
ReplaceNumber.Text = "";
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void addWork()
{
string work = txtWork.Text;
string date = DateTime.Now.ToString("dd-MM-yyyy hh:mm");
if (work == "")
{
ErrorMsg.msg("Enter work first");
Error er = new Error();
er.ShowDialog();
return;
}
con = new MySqlConnection(cs);
string query = "insert into user_work(user,user_work,date)values(@user,@work,@date)";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@user", login.id);
cmd.Parameters.AddWithValue("@work", work);
cmd.Parameters.AddWithValue("@date", date);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
ErrorMsg.msg("Work added!!");
Error er = new Error();
er.ShowDialog();
txtWork.Clear();
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void addSaler()
{
string saler = txtSaler.Text;
if (saler == "")
{
ErrorMsg.msg("Enter name");
Error er = new Error();
er.ShowDialog();
return;
}
con = new MySqlConnection(cs);
string query = "insert into to_tbl (to_name) values (@saler)";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@saler", saler);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
ErrorMsg.msg("Add successfully");
Error er = new Error();
er.ShowDialog();
txtSaler.Text = "";
addSALERdatagrid.Rows.Clear();
getToDestination();
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void SearchByDateFun()
{
try
{
con = new MySqlConnection(cs);
string query = "SELECT * FROM customer WHERE RDate BETWEEN @from AND @to";
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@from", dateFrom.Value.ToString("yyyy-MM-dd hh:mm:ss"));
cmd.Parameters.AddWithValue("@to", dateTo.Value.ToString("yyyy-MM-dd hh:mm:ss"));
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
SHOWdataGridView.Rows.Clear();
while (dr.Read())
{
string[] data = { dr.GetInt32(10).ToString(), dr.GetString(1), dr.GetString(2), dr.GetString(3), dr.GetString(4), dr.GetString(5).ToString(), dr.GetInt32(6).ToString(), dr.GetInt64(7).ToString(), dr.GetString(8), dr.GetString(9), dr.GetInt32(0).ToString() };
SHOWdataGridView.Rows.Add(data);
}
}
else
{
ErrorMsg.msg("No data found");
Error er = new Error();
er.ShowDialog();
}
//SHOWdataGridView.DataSource = dt;
}
catch (MySqlException)
{
MessageBox.Show("Connection failed");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
//get to destination
private void getToDestination()
{
con = new MySqlConnection(cs);
string query = "SELECT * FROM `to_tbl` ORDER BY to_name ASC";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
cmbTo.Items.Clear();
cmbEditTo.Items.Clear();
while (dr.Read())
{
cmbTo.Items.Add(dr.GetString(1));
cmbEditTo.Items.Add(dr.GetString(1));
string[] salerData = { dr.GetInt32(0).ToString(), dr.GetString(1) };
addSALERdatagrid.Rows.Add(salerData);
}
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void getWork(string user_id)
{
con = new MySqlConnection(cs);
string query = "SELECT * FROM `user_work` where user=@user";
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@user", Convert.ToInt32(user_id));
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
WORKdatagrid.Rows.Clear();
while (dr.Read())
{
string[] data = { dr.GetString(2), dr.GetString(3) };
WORKdatagrid.Rows.Add(data);
}
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public void getUers()
{
con = new MySqlConnection(cs);
string query = "select * from user where id != @id";
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", login.id);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
USERSdatagrid.Rows.Clear();
while (dr.Read())
{
string[] data = { dr.GetInt32(0).ToString(), dr.GetString(1), dr.GetInt32(5).ToString(), dr.GetString(4), dr.GetString(3) };
USERSdatagrid.Rows.Add(data);
}
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
//get from destination
private void getFromDestination()
{
con = new MySqlConnection(cs);
string query = "SELECT * FROM `from_tbl` ORDER BY from_name ASC";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
cmbFrom.Items.Add(dr.GetString(1));
cmbEditFrom.Items.Add(dr.GetString(1));
}
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public void getPending()
{
con = new MySqlConnection(cs);
PENDINGdatagrid.Rows.Clear();
string query = "SELECT * FROM replacement where status_replace = 0";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
string[] data = { dr.GetString(1), dr.GetString(2), dr.GetString(8), dr.GetString(3), dr.GetString(9), dr.GetString(7), dr.GetString(10), dr.GetString(13), dr.GetString(4), dr.GetString(5), dr.GetString(6), dr.GetString(14), dr.GetInt32(0).ToString(), dr.GetInt32(11).ToString(), dr.GetInt32(12).ToString() };
PENDINGdatagrid.Rows.Add(data);
}
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void updateCustomer()
{
string name = txtNameUP.Text;
string device = txtDevice.Text;
string note = txtNote.Text;
string fault = txtFault.Text;
string number = txtNumber.Text;
string date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
string status = cmbStatus.Text;
string query;
if (name == "")
{
ErrorMsg.msg("Please enter name");
Error er = new Error();
er.ShowDialog();
return;
}
if (device == "")
{
ErrorMsg.msg("Please enter device");
Error er = new Error();
er.ShowDialog();
return;
}
if (note == "")
{
note = "No note";
}
if (fault == "")
{
ErrorMsg.msg("Please enter fault");
Error er = new Error();
er.ShowDialog();
return;
}
if (number != "")
{
if (number.Length != 10)
{
ErrorMsg.msg("Number should be 10 digit");
Error er = new Error();
er.ShowDialog();
return;
}
}
else
{
ErrorMsg.msg("Please enter number");
Error er = new Error();
er.ShowDialog();
return;
}
if (status == "" || status == "--Select--")
{
ErrorMsg.msg("Please select status");
Error er = new Error();
er.ShowDialog();
return;
}
try
{
con = new MySqlConnection(cs);
query = "update customer set Name=@name,Device=@device,Fault=@fault,Paid=@paid,status=@status,number=@number,Close_date=@close where id = @id";
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@device", device);
cmd.Parameters.AddWithValue("@fault", fault);
cmd.Parameters.AddWithValue("@paid", Convert.ToInt32(txtPaid.Text));
if (status == "Complete")
{
cmd.Parameters.AddWithValue("@status", 1);
cmd.Parameters.AddWithValue("@close", date);
}
else
{
cmd.Parameters.AddWithValue("@status", 0);
cmd.Parameters.AddWithValue("@close", "-");
}
cmd.Parameters.AddWithValue("@number", Convert.ToInt64(number));
cmd.Parameters.AddWithValue("@id", _cust_id);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
ErrorMsg.msg("Update successfully");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
MessageBox.Show("No internet connection");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
this.Hide();
}
}
}
private void updateReplacement()
{
string name = txtEditName.Text;
string device = txtEditDevice.Text;
string note = txtEditNote.Text;
string sr = txtEditSR.Text;
string fault = txtEDitFault.Text;
string number = txtEditNumber.Text;
string courier = txtEditCourier.Text;
string from = cmbEditFrom.Text;
string to = cmbEditTo.Text;
string docket = txtEditDocket.Text;
string status = cmbStatus.Text;
string cust_status = cmbCustStatus.Text;
int _status;
int _cust_status;
int id = 0;
if (ReplaceNumber.Text != "")
{
id = Convert.ToInt32(ReplaceNumber.Text);
}
else
{
ErrorMsg.msg("Please select any row");
Error er = new Error();
er.ShowDialog();
return;
}
//valid customer name
if (name == "")
{
ErrorMsg.msg("Please enter customer name");
Error er = new Error();
er.ShowDialog();
return;
}
//valid device
if (device == "")
{
ErrorMsg.msg("Please enter device");
Error er = new Error();
er.ShowDialog();
return;
}
//valid courier
if (courier == "")
{
ErrorMsg.msg("Please enter courier name");
Error er = new Error();
er.ShowDialog();
return;
}
//valid srno
if (sr == "")
{
ErrorMsg.msg("Please enter serial number");
Error er = new Error();
er.ShowDialog();
return;
}
//valid from
if (from == "" || from == "--Select--")
{
ErrorMsg.msg("Please select from destination");
Error er = new Error();
er.ShowDialog();
return;
}
//valid to
if (to == "" || to == "--Select--")
{
ErrorMsg.msg("Please select to destination");
Error er = new Error();
er.ShowDialog();
return;
}
//valid fault
if (fault == "")
{
ErrorMsg.msg("Please enter fault");
Error er = new Error();
er.ShowDialog();
return;
}
//valid number
if (number != "")
{
if (number.Length != 10)
{
ErrorMsg.msg("Please enter valid number");
Error er = new Error();
er.ShowDialog();
return;
}
}
else
{
ErrorMsg.msg("Please enter number");
Error er = new Error();
er.ShowDialog();
return;
}
//valid docket
if (docket == "")
{
ErrorMsg.msg("Please enter docket");
Error er = new Error();
er.ShowDialog();
return;
}
//valid status
if (status == "" || status == "--Select--")
{
ErrorMsg.msg("Please select status");
Error er = new Error();
er.ShowDialog();
return;
}
else
{
if (status == "Pending")
{
_status = 0;
}
else
{
_status = 1;
}
}
//valid status
if (cust_status == "" || cust_status == "--Select--")
{
ErrorMsg.msg("Please select customer status");
Error er = new Error();
er.ShowDialog();
return;
}
else
{
if (cust_status == "Pending")
{
_cust_status = 0;
}
else
{
_cust_status = 1;
}
}
try
{
con = new MySqlConnection(cs);
con.Open();
string query = "UPDATE `replacement` SET `cust_name`= @name,`device`=@device,`serial_no`=@sr,`courier_name`= @courier,`where_from`=@from,`where_to`=@to,`note`=@note,`fault`=@fault,`number`=@number,`status_replace`=@status_replace,`status_cust`=@status_cust,`user`=@user,`docket`=@docket where id = @id";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@device", device);
cmd.Parameters.AddWithValue("@sr", sr);
cmd.Parameters.AddWithValue("@courier", courier);
cmd.Parameters.AddWithValue("@from", from);
cmd.Parameters.AddWithValue("@to", to);
cmd.Parameters.AddWithValue("@note", note);
cmd.Parameters.AddWithValue("@fault", fault);
cmd.Parameters.AddWithValue("@number", Convert.ToInt64(number));
cmd.Parameters.AddWithValue("@status_replace", _status);
cmd.Parameters.AddWithValue("@status_cust", _cust_status);
cmd.Parameters.AddWithValue("@user", login.user_name);
cmd.Parameters.AddWithValue("@docket", docket);
cmd.Parameters.AddWithValue("@id", id);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
ErrorMsg.msg("Update successfully");
Error er = new Error();
er.ShowDialog();
resetEdit();
}
getPending();
getComplete();
}
catch (MySqlException ex)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void insertReplacement()
{
int a = 0;
try
{
con = new MySqlConnection(cs);
con.Open();
for (int i = 0; i < ADDreplacementData.Rows.Count; i++)
{
string query = "INSERT INTO replacement(cust_name, device, serial_no, courier_name,where_from, where_to, date, note, fault, number,user,docket) VALUES(@cust_name,@device, @serial_no, @courier_name, @where_from, @where_to, @date, @note, @fault, @number,@user,@docket)";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@cust_name", ADDreplacementData.Rows[i].Cells[0].Value);
cmd.Parameters.AddWithValue("@device", ADDreplacementData.Rows[i].Cells[1].Value);
cmd.Parameters.AddWithValue("@note", ADDreplacementData.Rows[i].Cells[2].Value);
cmd.Parameters.AddWithValue("@serial_no", ADDreplacementData.Rows[i].Cells[3].Value);
cmd.Parameters.AddWithValue("@fault", ADDreplacementData.Rows[i].Cells[4].Value);
cmd.Parameters.AddWithValue("@date", ADDreplacementData.Rows[i].Cells[5].Value);
cmd.Parameters.AddWithValue("@number", ADDreplacementData.Rows[i].Cells[6].Value);
cmd.Parameters.AddWithValue("@user", ADDreplacementData.Rows[i].Cells[7].Value);
cmd.Parameters.AddWithValue("@courier_name", ADDreplacementData.Rows[i].Cells[8].Value);
cmd.Parameters.AddWithValue("@where_from", ADDreplacementData.Rows[i].Cells[9].Value);
cmd.Parameters.AddWithValue("@where_to", ADDreplacementData.Rows[i].Cells[10].Value);
cmd.Parameters.AddWithValue("@docket", ADDreplacementData.Rows[i].Cells[11].Value);
a += cmd.ExecuteNonQuery();
}
if (a > 0)
{
ErrorMsg.msg("Insert successfuly");
Error er = new Error();
er.ShowDialog();
reset();
getReplaceDataEdit();
ADDreplacementData.Rows.Clear();
}
else
{
ErrorMsg.msg("Insert failed");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void addToGrid()
{
string custName = txtCustName.Text;
string device = txtDevice.Text;
string serial_no = txtSrNo.Text;
string from = cmbFrom.Text;
string to = cmbTo.Text;
string note = txtNote.Text;
string fault = txtFault.Text;
string date = txtDate.Text;
string number = txtNumber.Text;
string courier = txtCourierName.Text;
string docket = txtDocket.Text;
string user = txtUser.Text;
//valid customer name
if (custName == "")
{
ErrorMsg.msg("Please enter customer name");
Error er = new Error();
er.ShowDialog();
return;
}
//valid device
if (device == "")
{
ErrorMsg.msg("Please enter device");
Error er = new Error();
er.ShowDialog();
return;
}
//valid courier
if (courier == "")
{
ErrorMsg.msg("Please enter courier name");
Error er = new Error();
er.ShowDialog();
return;
}
//valid srno
if (serial_no == "")
{
ErrorMsg.msg("Please enter serial number");
Error er = new Error();
er.ShowDialog();
return;
}
//valid from
if (from == "" || from == "--Select--")
{
ErrorMsg.msg("Please select from destination");
Error er = new Error();
er.ShowDialog();
return;
}
//valid to
if (to == "" || to == "--Select--")
{
ErrorMsg.msg("Please select to destination");
Error er = new Error();
er.ShowDialog();
return;
}
//valid fault
if (fault == "")
{
ErrorMsg.msg("Please enter fault");
Error er = new Error();
er.ShowDialog();
return;
}
//valid number
if (number != "")
{
if (number.Length != 10)
{
ErrorMsg.msg("Please enter valid number");
Error er = new Error();
er.ShowDialog();
return;
}
}
else
{
ErrorMsg.msg("Please enter number");
Error er = new Error();
er.ShowDialog();
return;
}
string[] data = { custName, device, note, serial_no, fault, date, number, user, courier, from, to, docket };
ADDreplacementData.Rows.Add(data);
reset();
return;
}
private void loginForm(string user, string pass)
{
con = new MySqlConnection(cs);
string dd = DateTime.Now.ToString("dd-MM-yyyy hh:mm");
string query = "SELECT * FROM user where binary username=@user and binary password=@pass limit 1";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@user", user);
cmd.Parameters.AddWithValue("@pass", pass);
MySqlDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
if (dr.GetInt32(5) == 0)
{
user_name = dr.GetString(1);
id = dr.GetInt32(0);
last_login = dr.GetString(4);
user_type = dr.GetString(3);
MySqlConnection con2 = new MySqlConnection(cs);
con2.Open();
string query1 = "update user set last_login=@dt";
MySqlCommand cd = new MySqlCommand(query1, con2);
cd.Parameters.AddWithValue("dt", dd);
int a = cd.ExecuteNonQuery();
if (a > 0)
{
Form1 f1 = new Form1();
this.Hide();
f1.Show();
}
con2.Close();
}
else
{
ErrorMsg.msg("You are blocked");
Error er = new Error();
er.ShowDialog();
return;
}
}
else
{
ErrorMsg.msg("Enter valid credential");
Error er = new Error();
er.ShowDialog();
return;
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void updateUser()
{
string username = txtUserName.Text;
string role = cmbRole.Text;
string block = cmbBlock.Text;
int block_status = 0;
if (username == "")
{
ErrorMsg.msg("Username can't be empty");
Error er = new Error();
er.ShowDialog();
return;
}
if (role == "")
{
ErrorMsg.msg("Please select role");
Error er = new Error();
er.ShowDialog();
return;
}
if (block == "")
{
ErrorMsg.msg("Please select block status");
Error er = new Error();
er.ShowDialog();
return;
}
else
{
if (block == "Block")
{
block_status = 1;
}
else if (block == "Unblock")
{
block_status = 0;
}
}
con = new MySqlConnection(cs);
string query = "update user set username=@user,block=@block,role=@role where id=@id";
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@user", username);
cmd.Parameters.AddWithValue("@block", block_status);
cmd.Parameters.AddWithValue("@role", role);
cmd.Parameters.AddWithValue("@id", user_id);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
getUers();
resetUser();
ErrorMsg.msg("Update succesfully!!");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void addUser()
{
string username = txtUserName.Text;
string role = cmbRole.Text;
string block = cmbBlock.Text;
string password = "******";
int block_status = 0;
if (username == "")
{
ErrorMsg.msg("Username can't be empty");
Error er = new Error();
er.ShowDialog();
return;
}
if (role == "")
{
ErrorMsg.msg("Please select role");
Error er = new Error();
er.ShowDialog();
return;
}
if (block == "")
{
ErrorMsg.msg("Please select block status");
Error er = new Error();
er.ShowDialog();
return;
}
else
{
if (block == "Block")
{
block_status = 1;
}
else if (block == "Unblock")
{
block_status = 0;
}
}
con = new MySqlConnection(cs);
string query = "insert into user(username,password,role,block)values(@user,@pass,@role,@block)";
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@user", username);
cmd.Parameters.AddWithValue("@block", block_status);
cmd.Parameters.AddWithValue("@role", role);
cmd.Parameters.AddWithValue("@pass", password);
int a = cmd.ExecuteNonQuery();
if (a > 0)
{
getUers();
resetUser();
ErrorMsg.msg("User add succesfully!!");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void changePassword()
{
string old_pass = txtOldPass.Text;
string new_pass = txtNewPass.Text;
string confirm_pass = txtConfirmPass.Text;
if (old_pass == "")
{
ErrorMsg.msg("Please enter old password");
Error er = new Error();
er.ShowDialog();
return;
}
if (new_pass == "")
{
ErrorMsg.msg("Please enter new password");
Error er = new Error();
er.ShowDialog();
return;
}
if (confirm_pass == "")
{
ErrorMsg.msg("Please enter confirm password");
Error er = new Error();
er.ShowDialog();
return;
}
if (confirm_pass != new_pass)
{
ErrorMsg.msg("Password does not match");
Error er = new Error();
er.ShowDialog();
return;
}
con = new MySqlConnection(cs);
string query = "select password from user where id=@id";
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", login.id);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
string password_fetch = dr.GetString(0);
if (old_pass == password_fetch)
{
MySqlConnection con2 = new MySqlConnection(cs);
con2.Open();
string query1 = "update user set password = @pass_new where id=@id";
MySqlCommand cd = new MySqlCommand(query1, con2);
cd.Parameters.AddWithValue("@pass_new", new_pass);
cd.Parameters.AddWithValue("@id", login.id);
int a = cd.ExecuteNonQuery();
if (a > 0)
{
ErrorMsg.msg("Password change successfully!!");
Error er = new Error();
er.ShowDialog();
Application.Exit();
}
con2.Close();
}
else
{
ErrorMsg.msg("Invalid credential");
Error er = new Error();
er.ShowDialog();
}
}
}
catch (MySqlException)
{
ErrorMsg.msg("Check internet connection");
Error er = new Error();
er.ShowDialog();
return;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void SearchCustomer()
{
string searchBox = txtSearch.Text;
string query;
if (searchBox == "" || searchBox == null)
{
ErrorMsg.msg("Please enter receipt no");
Error er = new Error();
er.ShowDialog();
}
else
{
try
{
con = new MySqlConnection(cs);
if (Regex.IsMatch(searchBox, @"^\d+$"))
{
query = "SELECT * FROM customer where receipt_no = @name";
}
else
{
query = "SELECT * FROM customer where Name like @name";
}
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
if (Regex.IsMatch(searchBox, @"^\d+$"))
{
cmd.Parameters.AddWithValue("@name", Convert.ToInt32(searchBox));
}
else
{
cmd.Parameters.AddWithValue("@name", searchBox + "%");
}
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
SHOWdataGridView.Rows.Clear();
while (dr.Read())
{
string[] data = { dr.GetInt32(10).ToString(), dr.GetString(1), dr.GetString(2), dr.GetString(3), dr.GetString(4), dr.GetString(5), dr.GetInt32(6).ToString(), dr.GetInt64(7).ToString(), dr.GetString(8), dr.GetString(9), dr.GetInt32(0).ToString() };
SHOWdataGridView.Rows.Add(data);
}
}
else
{
ErrorMsg.msg("No data found");
Error er = new Error();
er.ShowDialog();
}
}
catch (MySqlException)
{
MessageBox.Show("Connection failed");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}