private void button1_Click(object sender, EventArgs e) { String loggduser = Formlogin.loggdin; u.First_name = firstname.Text; u.Last_name = lastname.Text; u.email = Email.Text; u.username = Username.Text; u.password = Password.Text; u.contact = Contact.Text; u.Address = address.Text; u.user_type = UserType.Text; u.added_date = DateTime.Now; userbll v = dal.getid(loggduser); u.added_by = v.id; bool success = dal.Insert(u); if (success == true) { MessageBox.Show("USER CREATED SUCCESFULLY"); clear(); } else { MessageBox.Show("FAILED TO ADD NEW USER"); } DataTable dt = dal.Select(); dataGridView1.DataSource = dt; }
protected void Button1_Click(object sender, EventArgs e) { if (Request.QueryString["name"] != null) { userbll bll = new userbll(); userModel model = new userModel(); model.name = TextBox1.Text; model.pwd = TextBox2.Text; int num = bll.updata(model); if (num > 0) { ClientScript.RegisterStartupScript(GetType(), "", "alert('添加成功');window.location='index.aspx';", true); } else { ClientScript.RegisterStartupScript(GetType(), "", "alert('失败');", true); } } else { userModel model = new userModel(); model.name = TextBox1.Text; model.pwd = TextBox2.Text; userbll bll = new userbll(); int num = bll.add(model); if (num > 0) { ClientScript.RegisterStartupScript(GetType(), "", "alert('添加成功');window.location='index.aspx';", true); } else { ClientScript.RegisterStartupScript(GetType(), "", "alert('失败');", true); } } }
private void button1_Click(object sender, EventArgs e) { v.Type = comboType.Text; v.Name = nme.Text; v.Email = email1.Text; v.Contact = contact1.Text; v.Address = address1.Text; v.added_date = DateTime.Now; string loggduser = Formlogin.loggdin; userbll u = udal.getid(loggduser); v.added_by = u.id; bool success = s.Insert(v); if (success == true) { MessageBox.Show("USER CREATED SUCCESFULLY"); clear(); } else { MessageBox.Show("FAILED TO ADD NEW USER"); } DataTable dt = s.Select(); dataGridView8.DataSource = dt; }
public userbll getid(string name) { userbll dc = new userbll(); SqlConnection conn = new SqlConnection(myconnstring); DataTable dt = new DataTable(); try { String sql = "SELECT id FROM users_tbl WHERE username='******'"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); conn.Open(); adapter.Fill(dt); if (dt.Rows.Count > 0) { dc.id = int.Parse(dt.Rows[0]["id"].ToString()); } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(dc); }
public bool Delete(userbll u) { bool issuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "DELETE FROM users_tbl where id=@id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id", u.id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { issuccess = true; } else { issuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(issuccess); }
private void button1_Click(object sender, EventArgs e) { u2.Name = name.Text; u2.Category = categorycmb.Text; u2.Description = description.Text; u2.Rate = Decimal.Parse(rate.Text); u2.Qty = Decimal.Parse(qty.Text); u2.added_date = DateTime.Now; string loggduser = Formlogin.loggdin; userbll u = udal.getid(loggduser); u2.added_by = u.id; bool success = dal2.Insert(u2); if (success == true) { MessageBox.Show("Products added successfullY"); clear(); } else { MessageBox.Show("FAILED TO ADD NEW PRODUCT"); } DataTable dt = dal2.Select(); dataGridView1.DataSource = dt; }
protected void Page_Load(object sender, EventArgs e) { userbll bll = new userbll(); Repeater1.DataSource = bll.sel(); Repeater1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { userbll bll = new userbll(); if (Request.QueryString["name"] != null) { userModel model = bll.selname(Request.QueryString["name"].ToString()); TextBox1.Text = model.name; TextBox2.Text = model.pwd; } } }
protected void Button1_Click(object sender, EventArgs e) { //账号 密码 string name = TextBox1.Text; string pwd = TextBox2.Text; userbll bll = new userbll(); object result = bll.login(name, pwd); if (result == null) { TextBox1.Text = "错误"; } else { TextBox1.Text = "成功"; } }
public bool Update(userbll u) { bool issuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "UPDATE users_tbl SET First_name=@First_name,Last_name=@Last_name,email=@email,username=@username,password=@password,contact=@contact,Address=@Address,user_type=@user_type,added_date=@added_date,added_by=@added_by WHERE id=@id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@First_name", u.First_name); cmd.Parameters.AddWithValue("@Last_name", u.Last_name); cmd.Parameters.AddWithValue("@email", u.email); cmd.Parameters.AddWithValue("@username", u.username); cmd.Parameters.AddWithValue("@password", u.password); cmd.Parameters.AddWithValue("@contact", u.contact); cmd.Parameters.AddWithValue("@Address", u.Address); cmd.Parameters.AddWithValue("@user_type", u.user_type); cmd.Parameters.AddWithValue("@added_date", u.added_date); cmd.Parameters.AddWithValue("@added_by", u.added_by); cmd.Parameters.AddWithValue("@id", u.id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { issuccess = true; } else { issuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(issuccess); }
public bool Insert(userbll u) { bool issuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "INSERT INTO users_tbl(First_name,Last_name,email,username,password,contact,Address,user_type,added_date,added_by) VALUES (@First_name,@Last_name,@email,@username,@password,@contact,@Address,@user_type,@added_date,@added_by)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@First_name", u.First_name); cmd.Parameters.AddWithValue("@Last_name", u.Last_name); cmd.Parameters.AddWithValue("@email", u.email); cmd.Parameters.AddWithValue("@username", u.username); cmd.Parameters.AddWithValue("@password", u.password); cmd.Parameters.AddWithValue("@contact", u.contact); cmd.Parameters.AddWithValue("@Address", u.Address); cmd.Parameters.AddWithValue("@user_type", u.user_type); cmd.Parameters.AddWithValue("@added_date", u.added_date); cmd.Parameters.AddWithValue("@added_by", u.added_by); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { issuccess = true; } else { issuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(issuccess); }
private void button1_Click(object sender, EventArgs e) { u1.Title = title.Text; u1.Description = description.Text; u1.added_date = DateTime.Now; string loggduser = Formlogin.loggdin; userbll u = udal.getid(loggduser); u1.added_by = u.id; bool success = dal1.Insert(u1); if (success == true) { MessageBox.Show("CATEGORY CREATED SUCCESFULLY"); clear(); } else { MessageBox.Show("FAILED "); } }
private void button2_Click(object sender, EventArgs e) { Transactionbll transaction = new Transactionbll(); transaction.Type = label1.Text; string dea_csname = dcname.Text; DCbll dc = dcdal.getid(dea_csname); transaction.dea_cust_id = dc.id; transaction.Grand_total = Math.Round(decimal.Parse(grandtotal.Text), 2); transaction.transaction_date = DateTime.Now; transaction.tax = decimal.Parse(vat.Text); transaction.discount = decimal.Parse(discount.Text); string usrname = Formlogin.loggdin; userbll u = udal.getid(usrname); transaction.added_by = u.id; transaction.transactiondetails = transactiondt; bool success = false; //inserting transaction and transaction details using (TransactionScope scope = new TransactionScope()) { int transactionid = -1; bool w = tdal.Insert(transaction, out transactionid); for (int i = 0; i < transactiondt.Rows.Count; i++) { trnsctiondetailbll tddetail = new trnsctiondetailbll(); String prdname = transactiondt.Rows[i][0].ToString(); productsbll p = pdal.getpid(prdname); tddetail.pid = p.id; tddetail.rate = decimal.Parse(transactiondt.Rows[i][1].ToString()); tddetail.qty = decimal.Parse(transactiondt.Rows[i][2].ToString()); tddetail.Total = Math.Round(decimal.Parse(transactiondt.Rows[i][3].ToString()), 2); tddetail.dea_cust_id = dc.id; tddetail.added_date = DateTime.Now; tddetail.added_by = u.id; //INC OR DEC QTY string ttype = label1.Text; bool x = false; if (ttype == "PURCHASE") { x = pdal.increaseqty(tddetail.pid, tddetail.qty); } else if (ttype == "SALES") { x = pdal.decreaseqty(tddetail.pid, tddetail.qty); } bool y = tddal.Insert(tddetail); success = w && y && x; } if (success == true) { scope.Complete(); DGVPrinter print = new DGVPrinter(); print.Title = "\r\n\r\n MIKE'S STORES PVT LTD \r\n"; print.SubTitle = "KOCHI ,KERALA ,phone - +919537583616\r\n\r\n"; print.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip; print.PageNumbers = true; print.PageNumberInHeader = false; print.PorportionalColumns = true; print.HeaderCellAlignment = StringAlignment.Near; print.Footer = "Discount :" + discount.Text + "% \r\n" + "vat :" + vat.Text + "%\r\n" + "GRAND_TOTAL:" + grandtotal.Text + "\r\n" + "Date & time of purchase:" + dateTimePicker1.Value + "\r\n\r" + " THANK YOU"; print.FooterSpacing = 40; print.PrintDataGridView(dgvproducts); MessageBox.Show("TRANSACTION C0MPLETED SUCCESSFULLY"); dgvproducts.DataSource = null; dgvproducts.Rows.Clear(); dgvproducts.DataSource = null; dgvproducts.Rows.Clear(); dcsearch.Text = ""; dcname.Text = ""; dcemail.Text = ""; dccontact.Text = ""; dcaddress.Text = ""; clear(); sbtotal.Text = ""; discount.Text = "0"; grandtotal.Text = "0"; vat.Text = "0"; PA.Text = "0"; RA.Text = "0"; } else { MessageBox.Show("TRANSACTION FAILED"); } } }