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);
}
}
}
