private void btn_Submit_Click(object sender, EventArgs e)
{
if (tb_Password.Text == tb_C_Password.Text)
{
obj.openconnection();
obj.cmd = new SqlCommand("insert into Login Values ( '" + tb_Username.Text + "' , '" + tb_Password.Text + "' ) ", obj.con);
if (Convert.ToInt32(obj.cmd.ExecuteNonQuery()) > 0)
{
MessageBox.Show("User Added Succefully...");
obj.cmd.Dispose();
obj.closeconnection();
obj.ClearTextBoxes(this);
}
else
{
MessageBox.Show("ReEnter Correct Password...");
}
}
}
private void btn_delete_row_Click(object sender, EventArgs e)
{
try
{
DialogResult result = MessageBox.Show("Do you want to delete these entry...?", "Confirmation", MessageBoxButtons.YesNoCancel);
if (result == DialogResult.Yes)
{
//...
SqlDataReader dr;
Common_Class obj = new Common_Class();
obj.openconnection();
int i;
i = dgv_cust_master.SelectedCells[0].RowIndex;
obj.cmd = new SqlCommand("Select * from Customer_Master where Customer_ID = " + dgv_cust_master.SelectedRows[i].Cells[0].Value.ToString() + " ", obj.con);
dr = obj.cmd.ExecuteReader();
if (dr.Read())
{
tempid = (int)dr["Customer_ID"];
dr.Close();
}
obj.cmd = new SqlCommand("Delete from Customer_Purchase_Detail where Customer_ID = " + tempid + " ", obj.con);
obj.cmd.ExecuteNonQuery();
obj.cmd = new SqlCommand("Delete from Customer_Master where Customer_ID = " + tempid + " ", obj.con);
if (obj.cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Row Deleted");
// TODO: This line of code loads data into the 'mobile_Shoppee_DBDataSet.Customer_Purchase_Detail' table. You can move, or remove it, as needed.
this.customer_Purchase_DetailTableAdapter.Fill(this.mobile_Shoppee_DBDataSet.Customer_Purchase_Detail);
// TODO: This line of code loads data into the 'mobile_Shoppee_DBDataSet.Customer_Master' table. You can move, or remove it, as needed.
this.customer_MasterTableAdapter.Fill(this.mobile_Shoppee_DBDataSet.Customer_Master);
}
else
{
MessageBox.Show("Record Are Not Deleted");
}
obj.closeconnection();
obj.cmd.Dispose();
dr.Close();
}
}
catch (Exception ex)
{
// Block of code to handle errors
MessageBox.Show(ex.Message);
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (tb_Total_Bill.Text != "")
{
obj.openconnection();
obj.globalVal_Custid(0, int.Parse(tb_Customer_ID.Text));
obj.cmd = new SqlCommand(" insert into Customer_Master values (" + tb_Customer_ID.Text + " , '" + tb_Customer_Name.Text + "' , '" + dtp_Bill_Date.Text + "' , " + tb_Customer_Mob_No.Text + ",'" + tb_Cust_GSTIN.Text + "' , " + tb_Bill.Text + " , " + tb_Discount.Text + " , " + tb_Total_Bill.Text + " )", obj.con);
if (obj.cmd.ExecuteNonQuery() > 0)
{
goto nxtquery;
}
else
{
MessageBox.Show("Record are Not saved Successfully");
}
nxtquery :;
obj.cmd.Dispose();
int i = 0;
foreach (DataGridViewRow row in dgv_new_bill.Rows)
{
if (i == (dgv_new_bill.Rows.Count - 1))
{
goto nxt;
}
// int Mob_id = 0;
obj.cmd = new SqlCommand(" Insert into Customer_Purchase_Detail values(" + dgv_new_bill.Rows[i].Cells[0].Value + ",'" + dgv_new_bill.Rows[i].Cells[1].Value + "','" + dgv_new_bill.Rows[i].Cells[2].Value + "','" + dgv_new_bill.Rows[i].Cells[3].Value + "'," + dgv_new_bill.Rows[i].Cells[4].Value + "," + dgv_new_bill.Rows[i].Cells[5].Value + "," + dgv_new_bill.Rows[i].Cells[6].Value + " ," + dgv_new_bill.Rows[i].Cells[7].Value + "," + dgv_new_bill.Rows[i].Cells[8].Value + "," + dgv_new_bill.Rows[i].Cells[9].Value + "," + dgv_new_bill.Rows[i].Cells[10].Value + " )", obj.con);
obj.cmd.ExecuteNonQuery();
obj.cmd.Dispose();
i = i + 1;
}
nxt :;
if (i > 0)
{
//obj.globalVal_Custid(0,int.Parse(tb_Customer_ID.Text));
MessageBox.Show("Record Added Successfully...");
frm_Bill_History_by_Cust_Name obj1 = new frm_Bill_History_by_Cust_Name();
obj1.Show();
}
else
{
MessageBox.Show("Server Error..");
}
tb_Customer_Name.Text = "";
tb_Customer_Mob_No.Text = "";
tb_Bill.Text = "";
tb_Discount.Text = "0";
tb_Price.Text = "";
tb_Quantity.Text = "";
tb_Total_Bill.Text = "";
tb_Customer_Mob_No.Text = "";
cb_Brand_Name.Text = "";
cb_Model_Name.Text = "";
tb_Total_Price.Text = "";
dgv_new_bill.DataSource = "";
int f = 0;
f = obj.Auto_Increment("select count(Customer_ID) from Customer_Master", 1);
tb_Customer_ID.Text = Convert.ToString(f);
}
else
{
MessageBox.Show("Please fill all fields");
}
}
catch (Exception ex)
{
// Block of code to handle errors
MessageBox.Show(ex.Message);
}
}