protected void btnSave_Click(object sender, EventArgs e) { if (IsValid) { var parameters = SqlDataSource1.UpdateParameters; // ([TenLogo], [HinhAnhLogo]) parameters["ID_Logo"].DefaultValue = txtID_Logo1.Text; parameters["TenLogo"].DefaultValue = txtTenLogo1.Text; parameters["HinhAnhLogo"].DefaultValue = txtHinhAnhLogo1.Text; try { if (txtTenLogo1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else if (txtHinhAnhLogo1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else { SqlDataSource1.Update(); StringBuilder sb = new StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("alert('Records Updated Successfully');"); sb.Append("$('#editModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript", sb.ToString(), false); } } catch (Exception) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Vui lòng kiểm tra lại.');", true); } } }
protected void btnCadastrar_Click(object sender, EventArgs e) { string ope = Request.QueryString["ope"]; Usuarios User = new Usuarios(); User = (Usuarios)Session["usuario"]; if (ope != "E") { SqlDataSource1.InsertParameters["BancoNome"].DefaultValue = txtBanco.Text; SqlDataSource1.InsertParameters["BancoAgencia"].DefaultValue = txtAgencia.Text; SqlDataSource1.InsertParameters["BancoConta"].DefaultValue = txtConta.Text; SqlDataSource1.InsertParameters["BancoGerente"].DefaultValue = txtGerente.Text; SqlDataSource1.InsertParameters["BancoTel"].DefaultValue = txtTelefone.Text; SqlDataSource1.InsertParameters["BancoEmail"].DefaultValue = txtEmail.Text; SqlDataSource1.InsertParameters["BancoResponsavel"].DefaultValue = txtResponsavel.Text; SqlDataSource1.InsertParameters["IDCond"].DefaultValue = Convert.ToString(User.Cond); SqlDataSource1.InsertParameters["BancoCartDeb"].DefaultValue = txtCartDeb.Text; SqlDataSource1.InsertParameters["BancoCartCre"].DefaultValue = txtCartCred.Text; SqlDataSource1.Insert(); } else { SqlDataSource1.UpdateParameters["BancoNome"].DefaultValue = txtBanco.Text; SqlDataSource1.UpdateParameters["BancoAgencia"].DefaultValue = txtAgencia.Text; SqlDataSource1.UpdateParameters["BancoConta"].DefaultValue = txtConta.Text; SqlDataSource1.UpdateParameters["BancoGerente"].DefaultValue = txtGerente.Text; SqlDataSource1.UpdateParameters["BancoTel"].DefaultValue = txtTelefone.Text; SqlDataSource1.UpdateParameters["BancoEmail"].DefaultValue = txtEmail.Text; SqlDataSource1.UpdateParameters["BancoResponsavel"].DefaultValue = txtResponsavel.Text; SqlDataSource1.UpdateParameters["BancoCartDeb"].DefaultValue = txtCartDeb.Text; SqlDataSource1.UpdateParameters["BancoCartCre"].DefaultValue = txtCartCred.Text; SqlDataSource1.Update(); } }
protected void btnCadastrar_Click(object sender, EventArgs e) { string ope = Request.QueryString["ope"]; Usuarios User = new Usuarios(); User = (Usuarios)Session["usuario"]; if (ope != "E") { SqlDataSource1.InsertParameters["ClassiFlag"].DefaultValue = txtFlag.Text; SqlDataSource1.InsertParameters["ClassiTitulo"].DefaultValue = txtTitulo.Text; SqlDataSource1.InsertParameters["ClassiDesc"].DefaultValue = txtDescricao.Text; SqlDataSource1.InsertParameters["ClassiValor"].DefaultValue = txtValor.Text; SqlDataSource1.InsertParameters["ClassiValidade"].DefaultValue = txtValidade.Text; SqlDataSource1.InsertParameters["ClassiData"].DefaultValue = txtDataOferta.Text; SqlDataSource1.InsertParameters["ClassiFoto"].DefaultValue = txtFoto.Text; SqlDataSource1.InsertParameters["ClassiNegociado"].DefaultValue = rblNegocio.SelectedItem.Value; SqlDataSource1.InsertParameters["Login"].DefaultValue = User.Login; SqlDataSource1.InsertParameters["IDCond"].DefaultValue = Convert.ToString(User.Cond); SqlDataSource1.Insert(); } else { SqlDataSource1.UpdateParameters["ClassiFlag"].DefaultValue = txtFlag.Text; SqlDataSource1.UpdateParameters["ClassiTitulo"].DefaultValue = txtTitulo.Text; SqlDataSource1.UpdateParameters["ClassiDesc"].DefaultValue = txtDescricao.Text; SqlDataSource1.UpdateParameters["ClassiValor"].DefaultValue = txtValor.Text; SqlDataSource1.UpdateParameters["ClassiValidade"].DefaultValue = txtValidade.Text; SqlDataSource1.UpdateParameters["ClassiData"].DefaultValue = txtDataOferta.Text; SqlDataSource1.UpdateParameters["ClassiFoto"].DefaultValue = txtFoto.Text; SqlDataSource1.UpdateParameters["ClassiNegociado"].DefaultValue = rblNegocio.SelectedItem.Value; SqlDataSource1.Update(); } }
protected void Page_Load(object sender, EventArgs e) { hfNo.Value = "No"; hfConfirm.Value = "No"; hfDisable.Value = "Yes"; DataView dv = (DataView)SqlDataSource1.Select(new DataSourceSelectArguments()); for (int i = 0; i < dv.Count; i++) { String date = (String)dv[i][0]; int s1 = int.Parse(date.Substring(0, 2)); int s2 = int.Parse(date.Substring(3, 2)); int s3 = int.Parse(date.Substring(6, 4)); DateTime d1 = new DateTime(s3, s2, s1); DateTime d2; if (d1.Month == 12) { s2 = 1; d2 = new DateTime(s3 + 1, s2, s1); } else { if (s2 == 1) { if (s1 > 28) { s1 = 28; } } d2 = new DateTime(s3, s2 + 1, s1); } if (DateTime.Compare(d1, d2) > 0) { hfDate.Value = date; int n = SqlDataSource1.Update(); } } }
protected void Button1_Click(object sender, EventArgs e) { if (DropDownList9.SelectedValue == "0") { Response.Write("<script>alert('Error, favor de seleccionar un motorista!')</script>"); } else { int msj = 0; SqlDataSource1.UpdateParameters["ID_Cotizacion"].DefaultValue = DropDownList2.SelectedValue; SqlDataSource1.UpdateParameters["ID_Empleado"].DefaultValue = DropDownList9.SelectedValue; msj = SqlDataSource1.Update(); if (msj > 0) { Response.Write("<script>alert('Entrega exitosa!')</script>"); Response.Redirect("AsignacionMotorista.aspx"); } else { Response.Write("<script>alert('Error, no se realizo cambio en la Base de datos!')</script>"); } } }
protected void Button1_Click(object sender, EventArgs e) { if (RadioButtonList1.SelectedItem == null) { error.Text = "Please select a candidate!"; return; } else { error.Text = ""; int count = 0; DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); // if(dv == null) DataRow row = dv.Table.Rows[RadioButtonList1.SelectedIndex]; count = (int)row["Votes"]; count++; HiddenField1.Value = count.ToString(); SqlDataSource1.Update(); string url = "Results.aspx"; Response.Redirect(url); RadioButtonList1.ClearSelection(); } }
public void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e) { GridDataItem item1 = (GridDataItem)RadGrid1.MasterTableView.Items[RadGrid1.SelectedItems[0].ItemIndex]; string strVendorName = item1["VendorName"].Text; GridDataItem item2 = (GridDataItem)RadGrid1.MasterTableView.Items[RadGrid1.SelectedItems[0].ItemIndex]; string strVendorQuoteNumber = item2["VendorQuoteNumber"].Text; GridDataItem item3 = (GridDataItem)RadGrid1.MasterTableView.Items[RadGrid1.SelectedItems[0].ItemIndex]; DateTime strQuoteDate = DateTime.Parse(item3["QuoteDate"].Text); string targetFolder = RadAsyncUpload1.TargetFolder; string fileName = strVendorName + strVendorQuoteNumber + strQuoteDate.ToString("yyyyMMdd") + e.UploadResult.FileName; //e.File.SaveAs(Path.Combine(@"\\srvdata1\data\groups\Everyone\VendorQuotes", fileName)); e.File.SaveAs(Path.Combine(Server.MapPath(targetFolder), fileName)); SqlDataSource1.UpdateParameters.Add(new Parameter("VendorQuoteFileName", System.TypeCode.String, fileName)); SqlDataSource1.UpdateParameters.Add(new Parameter("VendorName", System.TypeCode.String, strVendorName)); SqlDataSource1.UpdateParameters.Add(new Parameter("VendorQuoteNumber", DbType.String, strVendorQuoteNumber)); SqlDataSource1.UpdateParameters.Add(new Parameter("QuoteDate", DbType.DateTime, strQuoteDate.ToString())); SqlDataSource1.Update(); }
protected void btnSubmit_Click(object sender, EventArgs e) { Password pwd = new Password(); DataView dv = (DataView)SqlDataSource1.Select(new DataSourceSelectArguments()); if (dv.Count == 1) { String pass = pwd.Decrypt(dv[0][0].ToString()); if (pass == txtOldPassword.Text) { hfPassword.Value = pwd.Encrypt(txtNewPassword.Text); int n = SqlDataSource1.Update(); if (n == 1) { Response.Write("<script>alert('Password Changed Successfully...')</script>"); } } else { Response.Write("<script>alert('Invalid Old Password...')</script>"); } } }
protected void Button1_Click(object sender, EventArgs e) { int id_edit = Convert.ToInt32(DropDownList7.SelectedValue); int id_sub = Convert.ToInt32(DropDownList6.SelectedValue); string period = TextBox1.Text; string ddate = DateTime.Now.Day.ToString() + "." + DateTime.Now.Month.ToString() + "." + DateTime.Now.Year.ToString(); if (id_sub == 0 || id_edit == 0 || period == "") { return; } // строка запроса на добавление данных String query = "INSERT INTO Sub (id_Edition,id_Subscriber,period,Registration_date) VALUES (" + id_edit + "," + id_sub + ",'" + period + "','" + ddate + "')"; //выполнение запроса на добавление данных SqlDataSource1.InsertCommand = query; SqlDataSource1.Insert(); String q = "update sub set cost = (period/e.periodicity*e.price) from edition e where e.id = sub.id_edition and e.id =" + id_edit; SqlDataSource1.UpdateCommand = q; SqlDataSource1.Update(); }
private void UpdateNode(TreeListNode node) { bool isModified = false; foreach (TreeListColumn col in tree.Columns) { if (col is TreeListDataColumn) { TreeListDataColumn dc = (TreeListDataColumn)col; ASPxTextBox tb = (ASPxTextBox)tree.FindDataCellTemplateControl(node.Key, dc, "editor"); if (!tb.Text.Equals(node.GetValue(dc.FieldName))) { isModified = true; } SqlDataSource1.UpdateParameters[dc.FieldName].DefaultValue = tb.Text; } } SqlDataSource1.UpdateParameters[tree.KeyFieldName].DefaultValue = node.Key; if (isModified) { SqlDataSource1.Update(); } }
protected void btnCadastrar_Click(object sender, EventArgs e) { Usuarios User = new Usuarios(); User = (Usuarios)Session["usuario"]; string ope = Request.QueryString["ope"]; if (ope != "E") { SqlDataSource1.InsertParameters["Tipo"].DefaultValue = txtTipo.Text; SqlDataSource1.InsertParameters["HoraAcontecimento"].DefaultValue = txtHora.Text; SqlDataSource1.InsertParameters["Morador"].DefaultValue = txtNome.Text; SqlDataSource1.InsertParameters["Telefone"].DefaultValue = txtTelefone.Text; SqlDataSource1.InsertParameters["Email"].DefaultValue = txtEmail.Text; SqlDataSource1.InsertParameters["DataAcontecimento"].DefaultValue = txtData.Text; SqlDataSource1.InsertParameters["Descrico"].DefaultValue = txtDescricao.Text; SqlDataSource1.InsertParameters["Login"].DefaultValue = User.Login; SqlDataSource1.InsertParameters["IDCond"].DefaultValue = Convert.ToString(User.Cond); SqlDataSource1.InsertParameters["Apartamento"].DefaultValue = Convert.ToString(User.Apart); SqlDataSource1.InsertParameters["Bloco"].DefaultValue = Convert.ToString(User.Bloco); SqlDataSource1.Insert(); } else { SqlDataSource1.UpdateParameters["Tipo"].DefaultValue = txtTipo.Text; SqlDataSource1.UpdateParameters["HoraAcontecimento"].DefaultValue = txtHora.Text; SqlDataSource1.UpdateParameters["Morador"].DefaultValue = txtNome.Text; SqlDataSource1.UpdateParameters["Telefone"].DefaultValue = txtTelefone.Text; SqlDataSource1.UpdateParameters["Email"].DefaultValue = txtEmail.Text; SqlDataSource1.UpdateParameters["DataAcontecimento"].DefaultValue = txtData.Text; SqlDataSource1.UpdateParameters["Descrico"].DefaultValue = txtDescricao.Text; SqlDataSource1.Update(); } }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource1.Update(); MailMessage email = new MailMessage(); email.To.Add(new MailAddress(TextBox2.Text)); email.From = new MailAddress("*****@*****.**"); email.Subject = "Asunto ( " + DateTime.Now.ToString("dd / MMM / yyy hh:mm:ss") + " Solicitud De Ingreso Awies) "; email.Body = "¡Te damos la bienvenida a AWIES! " + "Antes de comenzar, debes finalizar tu registro de ingreso. Inicia sesión y completa tu registro ingresando al siguiente enlace: http://localhost:59792/login.aspx"; email.IsBodyHtml = true; email.Priority = MailPriority.Normal; SmtpClient smtp = new SmtpClient("smtp.gmail.com"); smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; smtp.UseDefaultCredentials = false; smtp.Credentials = new NetworkCredential("*****@*****.**", "Awies 123"); string output = null; try { smtp.Send(email); email.Dispose(); output = "Corre electrónico fue enviado satisfactoriamente."; } catch (Exception ex) { output = "Error enviando correo electrónico: " + ex.Message; } Console.WriteLine(output); GridView1.DataBind(); }
protected void Button2_Click(object sender, EventArgs e) { if (flag == 1 && show == 1) { string new_payment = TextBox3.Text; DatabaseManagement dm = new DatabaseManagement(); OracleConnection conn = dm.dbaseConn(); dm.connOpen(conn); string cost_query = "select * from shop_9 where shopid='" + TextBox1.Text + "' and saleid='" + TextBox2.Text + "'"; string cost = dm.ReadRow(cost_query, conn)["cost"].ToString(); if (new_payment.Equals(cost)) { SqlDataSource1.UpdateCommand = "update shop_9 set payment=" + TextBox3.Text + "where shopid='" + TextBox1.Text + "' and saleid='" + TextBox2.Text + "'"; Label2.Text = " " + flag.ToString(); SqlDataSource1.Update(); /*notification starts here*/ string payment_notify = "insert into notification values(4,'" + Session["rid"].ToString() + "','" + TextBox1.Text + "','" + TextBox2.Text + "'," + int.Parse(new_payment) + ")"; Label2.Text = payment_notify; dm.InsertRow(payment_notify, conn); } else { Label2.Text = "you have to pay full amount"; } dm.connClose(conn); /*redirect*/ /*confirm payment page*/ Response.Redirect("~/Confirmpayment.aspx?shopid=" + TextBox1.Text + "&paidamount=" + new_payment); } else { Label2.Text = "First enter shopid and saleid" + flag.ToString() + show.ToString(); } }
//Checkout button protected void Button1_Click(object sender, EventArgs e) { string id = Convert.ToString(Session["id"]); string[] idler = id.Split('%'); string quantity = Convert.ToString(Session["quantity"]); string[] quantities = quantity.Split('%'); string number = Convert.ToString(Session["number"]); string[] numbers = number.Split('%'); for (int i = 0; i < quantities.Length; i++) { if (numbers[i] != "") { // numbers control if (Convert.ToInt32(quantities[i]) < Convert.ToInt32(numbers[i])) { // error message Label2.Text = "Error checking out the items!Please try again later"; } else { if (quantities[i] != "") { int newnumber = Convert.ToInt32(quantities[i]) - Convert.ToInt32(numbers[i]); string convertnewnumber = Convert.ToString(newnumber); //update query string updateCommand = "UPDATE [items] SET [quantity] ='" + convertnewnumber + "'" + "WHERE id='" + idler[i] + "'"; // double adas = Convert.ToDouble(Session["id"]); SqlDataSource1.UpdateCommand = updateCommand; SqlDataSource1.Update(); } } } } }
protected void gridCheques_RowUpdating(object sender, GridViewUpdateEventArgs e) { // string sql = "update MovimientosCuentasBanco set chequecobrado = @pagado, fechacobrado=@fechacobrado where movbanID = @movbanID"; // SqlConnection conGaribay = new SqlConnection(myConfig.ConnectionInfo); // this.gridCheques.Columns[1].Visible = true; // this.gridCheques.DataBind(); // // SqlCommand cmdupdate = new SqlCommand(sql, conGaribay); // try // { // //cmdupdate.Parameters.Clear(); // conGaribay.Open(); // // string fecha = e.NewValues["movbanID"].ToString(); // cmdupdate.Parameters.Add("@pagado", SqlDbType.Bit).Value = e.NewValues["chequecobrado"]; // cmdupdate.Parameters.Add("@fechacobrado", SqlDbType.DateTime).Value = DateTime.Parse(e.NewValues["fechacobrado"].ToString()); // cmdupdate.Parameters.Add("@movbanID", SqlDbType.Int).Value = this.gridCheques.Rows[e.RowIndex].Cells[1].Text; // int numregistros = cmdupdate.ExecuteNonQuery(); // } // catch(Exception exc){ // } // finally{ // this.gridCheques.EditIndex = -1; // conGaribay.Close(); // this.gridCheques.Columns[1].Visible = false; // this.DataBind(); // } string fecha; //fecha = DateTime.Parse(e.NewValues["fechacobrado"].ToString()).ToString("dd/MM/yyyy HH:mm:ss"); SqlDataSource1.UpdateParameters.Add("@chequecobrado", TypeCode.Boolean, e.NewValues["chequecobrado"].ToString()); SqlDataSource1.UpdateParameters.Add("@fechacobrado", TypeCode.DateTime, Utils.converttoLongDBFormat(e.NewValues["fechacobrado"].ToString())); //.ToString("dd/MM/yyyy HH:mm:ss")); SqlDataSource1.UpdateParameters.Add("@movbanID", TypeCode.Int32, this.gridCheques.Rows[e.RowIndex].Cells[1].Text); SqlDataSource1.Update(); this.gridCheques.EditIndex = -1; this.gridCheques.DataBind(); }
protected void btnupdate_Click(object sender, EventArgs e) { if (fileuploadpicture.HasFile == true) { string filename = fileuploadpicture.FileName.ToString().ToLower(); if (filename.EndsWith("jpg") || filename.EndsWith("jpeg") || filename.EndsWith("bmp") || filename.EndsWith("png")) { fileuploadpicture.SaveAs(Server.MapPath("images/" + filename)); HiddenField1photo.Value = "images/" + filename; SqlDataSource1.Update(); Lblmessage.Text = "Profile Updated Successfully"; } else { Lblmessage.Text = "Please upload picture in correct format"; } } else { SqlDataSource1.Update(); Lblmessage.Text = "Profile Updated Successfully"; } }
protected void SaveChanges(object sender, EventArgs e) { SqlDataSource1.UpdateParameters["MCategoryID"].DefaultValue = category_select.Value.Substring(0, 4); SqlDataSource1.UpdateParameters["MSubCategoryID"].DefaultValue = (subcategory_select.Value == "") ? "0" : subcategory_select.Value.Substring(0, 4); SqlDataSource1.UpdateParameters["ID"].DefaultValue = medicineID.Text; SqlDataSource1.UpdateParameters["IDNote"].DefaultValue = medicineIDNote.Text; SqlDataSource1.UpdateParameters["Name"].DefaultValue = medicineName.Text; SqlDataSource1.UpdateParameters["Name2"].DefaultValue = medicineName2.Text; SqlDataSource1.UpdateParameters["DF_mID"].DefaultValue = (medicineMID.Text == "")? " " : medicineMID.Text; SqlDataSource1.UpdateParameters["DF_subname"].DefaultValue = (medicineSubName1.Text == "")? " " : medicineSubName1.Text; SqlDataSource1.UpdateParameters["DF_subname2"].DefaultValue = (medicineSubName2.Text == "")? " " : medicineSubName2.Text; SqlDataSource1.UpdateParameters["DF_dosage"].DefaultValue = (medicineDosage.Text == "")? " " : medicineDosage.Text; SqlDataSource1.UpdateParameters["DF_form"].DefaultValue = (medicineForm.Text == "")? " " : medicineForm.Text; SqlDataSource1.UpdateParameters["DF_note"].DefaultValue = (medicineDFNote.Text == "") ?" ": medicineDFNote.Text; SqlDataSource1.UpdateParameters["DosFormNote"].DefaultValue = DosageFormNote.Text; SqlDataSource1.UpdateParameters["UsualDose"].DefaultValue = (UsualDose.Text == "") ? " " : UsualDose.Text; SqlDataSource1.UpdateParameters["Category"].DefaultValue = medicineCategory.Value; SqlDataSource1.UpdateParameters["CategoryNote"].DefaultValue = medicineCategoryNote.Text; SqlDataSource1.UpdateParameters["Note"].DefaultValue = medicineNote.Text; SqlDataSource1.UpdateParameters["InternalID"].DefaultValue = internalID.Text; SqlDataSource1.UpdateParameters["ImagePaths"].DefaultValue = ""; SqlDataSource1.Update(); Response.Write("<script>alert('更新成功!');window.location.replace('UpdateMedicine.aspx?id=" + medicineID.Text + "');</script>"); }
protected void btnCadastrar_Click(object sender, EventArgs e) { SqlDataSource2.UpdateParameters["Login"].DefaultValue = txtLogin.Text; SqlDataSource2.UpdateParameters["Senha"].DefaultValue = txtSenha.Text; SqlDataSource2.UpdateParameters["IDCond"].DefaultValue = ddlCond.SelectedItem.Value; SqlDataSource2.UpdateParameters["IDBloco"].DefaultValue = ddlBloco.SelectedItem.Value; SqlDataSource2.UpdateParameters["IDUnit"].DefaultValue = ddlApart.SelectedItem.Value; SqlDataSource1.UpdateParameters["Email"].DefaultValue = txtEmail.Text; SqlDataSource1.UpdateParameters["Telefone"].DefaultValue = txtTelefone.Text; SqlDataSource1.UpdateParameters["Celular"].DefaultValue = txtCelular.Text; SqlDataSource1.UpdateParameters["Email"].DefaultValue = txtEmail.Text; SqlDataSource1.UpdateParameters["Nome"].DefaultValue = txtNome.Text; SqlDataSource1.UpdateParameters["Sexo"].DefaultValue = rblSexo.SelectedItem.Value; SqlDataSource1.UpdateParameters["dtNasc"].DefaultValue = txtdtNasc.Text; SqlDataSource1.UpdateParameters["MorCpf"].DefaultValue = txtCPF.Text; SqlDataSource1.UpdateParameters["MorRg"].DefaultValue = txtRG.Text; SqlDataSource1.UpdateParameters["MorProf"].DefaultValue = txtProfissao.Text; SqlDataSource1.UpdateParameters["MorEmpresa"].DefaultValue = txtEmpresa.Text; SqlDataSource1.UpdateParameters["MorTelEmer"].DefaultValue = txtTelEmer.Text; SqlDataSource1.UpdateParameters["MorEmerContato"].DefaultValue = txtContEmer.Text; SqlDataSource1.Update(); SqlDataSource2.Update(); }
protected void btnNext_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } else { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); SqlParameter pj_cate = new SqlParameter("@pj_category", SqlDbType.NVarChar, 100); pj_cate.Direction = ParameterDirection.Input; pj_cate.Value = radProjectCate.SelectedValue.ToString(); SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int); pj_id.Direction = ParameterDirection.Input; pj_id.Value = ck.pj_id; insertParameters.Add(pj_cate); insertParameters.Add(pj_id); try { SqlDataSource1.Update(); //Response.Redirect("project_type_edit.aspx"); } catch { //ELMA Log } Response.Redirect("project_edit.aspx"); } }
protected void Button_Change_Password_Click(object sender, EventArgs e) { if ((TextBox_new_passward.Text == TextBox_confirm_new_passward.Text)) { SqlConnection conn = new SqlConnection(); SqlCommand con = new SqlCommand(); SqlDataReader reader; string pass = ""; conn.ConnectionString = ConfigurationManager.ConnectionStrings["ElecConnection"].ConnectionString; conn.Open(); con = conn.CreateCommand(); con.CommandText = ("SELECT Password FROM Login WHERE (UserID = " + (Session["UserID"].ToString() + ")")); reader = con.ExecuteReader(); if (reader.Read()) { pass = reader["Password"].ToString(); } reader.Close(); conn.Close(); if (TextBox_old_passward.Text == pass.ToString()) { HiddenField_NewPass.Value = TextBox_confirm_new_passward.Text.ToString(); SqlDataSource1.Update(); Label_Note.Text = "Password Changed Successfuly"; } else { Label_Note.Text = "Enter Correct Old Password"; } } else { Label_Note.Text = "New Password and confirm Passward are not Same"; } }
protected void Button1_Click(object sender, EventArgs e) { if (IsPostBack && Upload.HasFile) { if (Path.GetExtension(Upload.FileName).Equals(".xlsx")) { var excel = new ExcelPackage(Upload.FileContent); var dt = excel.ToDataTable(); var table = "excelimport"; using (var conn = new SqlConnection("Server=yourservername;Database=yourdatabasename;User Id=yourid;Password=yourpassword;Integrated Security=false")) { var bulkCopy = new SqlBulkCopy(conn); bulkCopy.DestinationTableName = table; conn.Open(); var schema = conn.GetSchema("Columns", new[] { null, null, table, null }); foreach (DataColumn sourceColumn in dt.Columns) { foreach (DataRow row in schema.Rows) { if (string.Equals(sourceColumn.ColumnName, (string)row["COLUMN_NAME"], StringComparison.OrdinalIgnoreCase)) { bulkCopy.ColumnMappings.Add(sourceColumn.ColumnName, (string)row["COLUMN_NAME"]); break; } } } SqlDataSource1.Delete(); bulkCopy.WriteToServer(dt); Response.Write("<script>alert('Contribution file as been successfully uploaded..');window.location = 'excelupload.aspx';</script>"); SqlDataSource1.Update(); GridView1.Visible = true; } } } }
protected void btn2_Click(object sender, EventArgs e) { try { int n = SqldsInwardEquip.Insert(); if (n == 1) { int a = SqlDataSource1.Update(); if (a == 1) { Response.Write("<script>alert('Data Inserted Successfully')</script>"); txtBillNo.Text = ""; txtDate.Text = ""; txtDescription.Text = ""; txtEquipmentName.Text = ""; txtPrice.Text = ""; txtPricePs.Text = ""; txtPricePs1.Text = ""; txtQuantity.Text = ""; txtTotalPrice.Text = ""; } else { Response.Write("<script>alert('Please enter correct details..')</script>"); } } else { Response.Write("<script>alert('Please fill the form Correctly')</script>"); } } catch (Exception er) { Response.Write(er.Message); } }
protected void BTN_Modifier_Click(object sender, EventArgs e) { SqlDataSource1.Update(); LBL_Info.Text = "Cheque Modifier avec succes"; }
protected void RichEdit_Saving(object source, DocumentSavingEventArgs e) { // Save document with the Ribbon Save button e.Handled = true; SqlDataSource1.Update(); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource1.Update(); Response.Redirect("ViewCategory.aspx"); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { Session["ID"] = GridView1.SelectedDataKey.Value; SqlDataSource1.Update(); GridView1.DataBind(); }
protected void btnNext_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } else { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); SqlParameter pj_background = new SqlParameter("@pj_background", SqlDbType.NVarChar); pj_background.Direction = ParameterDirection.Input; pj_background.Value = txtBackground.Text; SqlParameter pj_urgency = new SqlParameter("@pj_urgency", SqlDbType.NVarChar); pj_urgency.Direction = ParameterDirection.Input; pj_urgency.Value = txtUrgency.Text; //SqlParameter pj_risk_info = new SqlParameter("@pj_risk_info", SqlDbType.NVarChar); //pj_risk_info.Direction = ParameterDirection.Input; //pj_risk_info.Value = txtRiskInfo.Text; //SqlParameter pj_risk_reduction1 = new SqlParameter("@pj_risk_reduction1", SqlDbType.NVarChar); //pj_risk_reduction1.Direction = ParameterDirection.Input; //pj_risk_reduction1.Value = txtRiskReduction1.Text; //SqlParameter pj_risk_reduction2 = new SqlParameter("@pj_risk_reduction2", SqlDbType.NVarChar); //pj_risk_reduction2.Direction = ParameterDirection.Input; //pj_risk_reduction2.Value = txtRiskReduction2.Text; //SqlParameter pj_eval1 = new SqlParameter("@pj_risk_eval1", SqlDbType.NVarChar); //pj_eval1.Direction = ParameterDirection.Input; //pj_eval1.Value = txtRiskEval1.Text; //SqlParameter pj_eval2 = new SqlParameter("@pj_risk_eval2", SqlDbType.NVarChar); //pj_eval2.Direction = ParameterDirection.Input; //pj_eval2.Value = txtRiskEval2.Text; //SqlParameter pj_eval3 = new SqlParameter("@pj_risk_eval3", SqlDbType.NVarChar); //pj_eval3.Direction = ParameterDirection.Input; //pj_eval3.Value = txtRiskEval3.Text; SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int); pj_id.Direction = ParameterDirection.Input; pj_id.Value = ck.pj_id; insertParameters.Add(pj_background); insertParameters.Add(pj_urgency); //insertParameters.Add(pj_risk_info); //insertParameters.Add(pj_risk_reduction1); //insertParameters.Add(pj_risk_reduction2); //insertParameters.Add(pj_eval1); //insertParameters.Add(pj_eval2); //insertParameters.Add(pj_eval3); insertParameters.Add(pj_id); SqlDataSource1.Update(); //Response.Redirect("project_category_edit.aspx"); Response.Redirect("project_edit.aspx"); } }
protected void btnsalva_Click(object sender, EventArgs e) { SqlDataSource1.Update(); Response.Redirect("Patologie.aspx"); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { SqlDataSource1.Update(); GridView1.DataBind(); }
//([MaSV], [DiaChi], [DiaChiEmail], [SDT], [TrinhDoHocVan], [NgayVaoDang], [NgayVaoDoan], [ChucVu]) protected void btnSave_Click(object sender, EventArgs e) { if (IsValid) { var parameters = SqlDataSource1.InsertParameters; parameters["MaSV"].DefaultValue = txtMaSV1.Text; parameters["DiaChi"].DefaultValue = txtDiaChi1.Text; parameters["DiaChiEmail"].DefaultValue = txtDiaChiEmail1.Text; parameters["SDT"].DefaultValue = txtSDT1.Text; parameters["TrinhDoHocVan"].DefaultValue = txtTrinhDoHocVan1.Text; parameters["NgayVaoDang"].DefaultValue = txtNgayVaoDang1.Text; parameters["NgayVaoDoan"].DefaultValue = txtNgayVaoDoan1.Text; parameters["ChucVu"].DefaultValue = txtChucVu1.Text; try { if (txtMaSV1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else if (txtDiaChi1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else if (txtDiaChiEmail1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else if (txtSDT1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else if (txtTrinhDoHocVan1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else if (txtNgayVaoDang1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else if (txtNgayVaoDoan1.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Các trường (*) không được bỏ trống.');", true); } else { SqlDataSource1.Update(); StringBuilder sb = new StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("alert('Records Updated Successfully');"); sb.Append("$('#editModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript", sb.ToString(), false); } } catch (Exception) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Vui lòng kiểm tra lại.');", true); } } }