protected void Button1_Click(object sender, EventArgs e) { Session["Now"] = DateTime.Now.ToString(); AccessDataSource3.Insert(); AccessDataSource1.Update(); Response.Redirect("~/Member/ViewHistory.aspx"); }
// hakkımızda protected void ListView1_ItemCommand(object sender, ListViewCommandEventArgs e) { Label IdLabel = e.Item.FindControl("IdLabel") as Label; int id = Convert.ToInt32(IdLabel.Text); if (e.CommandName == "sil") { kurumsalSayfa ur = kurumsalSayfa.Select(id); if (ur == null) { Labelbilgi.Text = "<p class='msg error'><b>KAYIT BULUNAMADI !</b></p>"; return; } Result <int> sonuc = ur.Delete(); if (sonuc.HasError) { Labelbilgi.Text = "<p class='msg error'><b>Hata :" + sonuc.CustomErrorMessage + "</b></p>"; return; } else { Labelbilgi.Text = "<p class='msg done'><b>BAŞARIYLA SİLİNDİ...</b></p>"; AccessDataSource1.Select(DataSourceSelectArguments.Empty); ListView1.DataBind(); } } else if (e.CommandName == "duzenle") { Response.Redirect("kurumsal-duzenle.aspx?Id=" + id.ToString()); } }
protected void LinkButton4_Click(object sender, EventArgs e) { AccessDataSource1.Delete(); Session.Abandon(); Session.RemoveAll(); Response.Redirect("Default.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { Session["aa"] = GridView1.Rows[GridView1.Rows.Count - 1].Cells[3].Text; Session["bb"] = GridView1.Rows[GridView1.Rows.Count - 1].Cells[5].Text; Session["cc"] = GridView1.Rows[GridView1.Rows.Count - 1].Cells[7].Text; Session["dd"] = GridView1.Rows[GridView1.Rows.Count - 1].Cells[9].Text; Session["kimlik"] = GridView1.Rows[GridView1.Rows.Count - 1].Cells[0].Text; if (RadioButtonList1.Items[0].Selected == true) { Session["aa"] = Convert.ToInt32(Session["aa"]) + 1; } if (RadioButtonList1.Items[1].Selected == true) { Session["bb"] = Convert.ToInt32(Session["bb"]) + 1; } if (RadioButtonList1.Items[2].Selected == true) { Session["cc"] = Convert.ToInt32(Session["cc"]) + 1; } if (RadioButtonList1.Items[3].Selected == true) { Session["dd"] = Convert.ToInt32(Session["dd"]) + 1; } AccessDataSource1.Update(); }
private bool isLeafNode(string nodeID) { AccessDataSource1.SelectCommand = string.Format("SELECT [EmployeeID] FROM [Employees] WHERE ([ReportsTo] = {0})", nodeID); DataView dv = (DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty); return(dv.Count == 0); }
protected void RunFilter(String querystring, String col, String val, String includedparts) { //AccessDataSource1.SelectCommand = "SELECT [ProductLine], [Series], [Codename], [ModelName], [ConfigurationNumber], [ReleaseDate], [CodenameInSpareParts] FROM [Products_Basic] WHERE (Series = '" + currentseries + "') AND (" + col + " LIKE '%" + val + "%') ORDER BY [ReleaseDate] DESC, [Codename], [ConfigurationNumber]"; AccessDataSource1.SelectCommand = "SELECT ProductConfiguration.ConfigurationNumber, PartsBOM.PrtNum, PartsBOM.prtperunit, PartsBOM.PrtEURepai, PartsBOM.colval, PartsOrdPart.SANDS_Category, PartsOrdPart.DESCRIPTION, PartsOrdPart.SANDS_MEMO_OrdPart, PartsOrdPart.LOCATION, PartsOrdPart.LISTEACH, PartsOrdPart.QUANTITY FROM ((PartsBOM INNER JOIN PartsOrdPart ON PartsBOM.PrtNum = PartsOrdPart.PARTNUM) INNER JOIN ProductConfiguration ON PartsBOM.MDLCONFIG = ProductConfiguration.ConfigurationNumber) WHERE (PartsOrdPart.DESCRIPTION <> 'ZERO') AND (ProductConfiguration.ConfigurationNumber = '" + querystring + "') AND (" + col + " LIKE '%" + val + "%')" + includedparts + " ORDER BY PartsOrdPart.DESCRIPTION, PartsBOM.PrtNum"; AccessDataSource1.DataBind(); GridView1.DataBind(); }
protected void ListView1_ItemCommand(object sender, ListViewCommandEventArgs e) { int id = Convert.ToInt32(ListView1.DataKeys[e.Item.DataItemIndex].Value); if (e.CommandName == "sil") { ik ur = ik.Select(id); if (ur == null) { Labelbilgi.Text = "<p class='msg error'><b>KAYIT BULUNAMADI !</b></p>"; return; } //ur.Aktif = false; //Result<int> sonuc = ur.Update(); Result <int> sonuc = ur.Delete(); if (sonuc.HasError) { Labelbilgi.Text = "<p class='msg error'><b>Hata :" + sonuc.CustomErrorMessage + "</b></p>"; return; } else { Labelbilgi.Text = "<p class='msg done'><b>BAŞARIYLA SİLİNDİ...</b></p>"; AccessDataSource1.Select(DataSourceSelectArguments.Empty); ListView1.DataBind(); } } }
protected void Button3_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request["Id"]); kategori ur = kategori.Select(id); if (ur == null) { Labelbilgi.Text = "<p class='msg error'><b>KAYIT BULUNAMADI !</b></p>"; return; } Result <int> sonuc = ur.Delete(); if (sonuc.HasError) { Labelbilgi.Text = "<p class='msg error'><b>Hata :" + sonuc.CustomErrorMessage + "</b></p>"; return; } else { Labelbilgi.Text = "<p class='msg done'><b>BAŞARIYLA SİLİNDİ...</b></p>"; AccessDataSource1.Select(DataSourceSelectArguments.Empty); Response.Redirect("kategoriler.aspx"); } }
protected void btnAdd_Click(object sender, EventArgs e) { // If built in validation finds an error if (IsValid != true) { return; } TextBox Qty = MakeList.FooterRow.FindControl("txtQty") as TextBox; TextBox ItemName = MakeList.FooterRow.FindControl("txtItem") as TextBox; DropDownList Category = MakeList.FooterRow.FindControl("lstCategory") as DropDownList; TextBox Aisle = MakeList.FooterRow.FindControl("txtAisle") as TextBox; TextBox Price = MakeList.FooterRow.FindControl("txtPrice") as TextBox; TextBox Notes = MakeList.FooterRow.FindControl("txtNotes") as TextBox; AccessDataSource1.InsertParameters["ItemQuantity"].DefaultValue = Qty.Text; AccessDataSource1.InsertParameters["ItemName"].DefaultValue = ItemName.Text; AccessDataSource1.InsertParameters["ItemCategoryId"].DefaultValue = Category.SelectedValue; AccessDataSource1.InsertParameters["ItemAisle"].DefaultValue = Aisle.Text; AccessDataSource1.InsertParameters["ItemPrice"].DefaultValue = Price.Text; AccessDataSource1.InsertParameters["ItemNotes"].DefaultValue = Notes.Text; AccessDataSource1.Insert(); //btnAddItem.Enabled = true; //MakeList.ShowFooter = false; }
protected void Button1_Click(object sender, EventArgs e) { DataView dv = (DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty); if (dv.Count == 0) { Label1.Text = "Username and Password not match!"; return; } Session["Username"] = dv[0].Row["Username"].ToString(); Session["UserType"] = dv[0].Row["UserType"].ToString(); Session["Password"] = dv[0].Row["Password"].ToString(); if (Session["PID"] != null) { Response.Redirect("~/Products.aspx"); } if (Session["UserType"].ToString().Equals("admin")) { Response.Redirect("~/Admin/Default.aspx"); } if (Session["UserType"].ToString().Equals("user")) { Response.Redirect("~/Member/Default.aspx"); } }
protected void RunFilter(String val) { //AccessDataSource1.SelectCommand = "SELECT Codename, ModelName, ConfigurationNumber, ReleaseDate, Season, dbMemo FROM Products_Basic WHERE ((ReleaseDate LIKE '%2008' OR ReleaseDate LIKE '%2007' OR ReleaseDate LIKE '%2006')) AND (" + col + " LIKE '%" + val + "%') ORDER BY ReleaseDate DESC"; AccessDataSource1.SelectCommand = "SELECT Codename, ModelName, ConfigurationNumber, ReleaseDate, Season, dbMemo FROM Products_Basic WHERE (ModelName LIKE '%" + val + "%') OR (Codename LIKE '%" + val + "%') OR (ConfigurationNumber LIKE '%" + val + "%') OR (Season LIKE '%" + val + "%') OR (dbMemo LIKE '%" + val + "%') ORDER BY ReleaseDate DESC"; AccessDataSource1.DataBind(); GridView1.DataBind(); }
protected void RunFilter(String val, String os, String type, String desc) { //AccessDataSource1.SelectCommand = "SELECT Codename, ModelName, ConfigurationNumber, ReleaseDate, Season, dbMemo FROM Products_Basic WHERE ((ReleaseDate LIKE '%2008' OR ReleaseDate LIKE '%2007' OR ReleaseDate LIKE '%2006')) AND (" + col + " LIKE '%" + val + "%') ORDER BY ReleaseDate DESC"; //AccessDataSource1.SelectCommand = "SELECT Codename, ModelName, ConfigurationNumber, ReleaseDate, Season, dbMemo FROM Products_Basic WHERE (ModelName LIKE '%" + val + "%') OR (Codename LIKE '%" + val + "%') OR (ConfigurationNumber LIKE '%" + val + "%') OR (Season LIKE '%" + val + "%') OR (dbMemo LIKE '%" + val + "%') ORDER BY ReleaseDate DESC"; //AccessDataSource1.SelectCommand = "SELECT [SS-date-created] AS column1, [ModelName], [SS-OS-Abbreviation] AS column2, [SS-Description] AS column3, [SS-Version] AS column4, [SS-Size] AS column5, [SS-URLLocation] AS column6, [SS-Type] AS column7 FROM [LatestSilverStreamDrivers] WHERE ([SS-Type] = "UP") OR (ModelName LIKE '%" + val + "%') ORDER BY ReleaseDate DESC"; AccessDataSource1.SelectCommand = "SELECT DISTINCT [SS-Description] AS column3, [SS-date-created] AS column1, [ModelName], [SS-OS-Abbreviation] AS column2, [SS-Version] AS column4, [SS-Size] AS column5, [SS-URLLocation] AS column6, [SS-Type] AS column7, [SS-URLLocation] AS column8 FROM [LatestSilverStreamDrivers] WHERE (ModelName LIKE '%" + val + "%') AND ([SS-Type] LIKE '" + type + "') AND ([SS-OS-Abbreviation] LIKE '" + os + "') AND ([SS-Description] LIKE '%" + desc + "%') ORDER BY [SS-date-created] DESC"; AccessDataSource1.DataBind(); GridView1.DataBind(); }
protected void btnLogIn_Click(object sender, EventArgs e) { if ((bool)HttpContext.Current.Session["loggedIn"] == false) { try { DataView customerTable = (DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty); customerTable.RowFilter = "UserName = '******'"; DataRowView row = customerTable[0]; if (txtPassword.Text == row["Password"].ToString()) { Customer c = new Customer(); c.CustomerID = (int)row["CustomerID"]; c.Name = row["Name"].ToString(); c.Address = row["Address"].ToString(); c.City = row["City"].ToString(); c.State = row["State"].ToString(); c.ZipCode = row["ZipCode"].ToString(); c.Email = row["Email"].ToString(); c.UserName = row["UserName"].ToString(); c.Password = row["Password"].ToString(); HttpContext.Current.Session["currentUser"] = c; HttpContext.Current.Session["loggedIn"] = true; btnLogIn.Text = "Log Out"; HttpContext.Current.Session["loginButtonText"] = "Log Out"; txtUserName.Enabled = false; txtPassword.Enabled = false; HttpContext.Current.Session["loginTextboxEnabled"] = false; lblError.Text = ""; } else { lblError.Text = "Invalid Password"; } } catch (IndexOutOfRangeException) { lblError.Text = "Invalid Username"; } } else { HttpContext.Current.Session["loggedIn"] = false; btnLogIn.Text = "Log In"; HttpContext.Current.Session["loginButtonText"] = "Log In"; txtUserName.Enabled = true; txtPassword.Enabled = true; HttpContext.Current.Session["loginTextboxEnabled"] = true; } }
private void modificaInregistrare() { AccessDataSource1.UpdateParameters[0].DefaultValue = TxtDProdus.Text; AccessDataSource1.UpdateParameters[1].DefaultValue = DdlUM.Text; AccessDataSource1.UpdateParameters[2].DefaultValue = DdlTVA.Text; AccessDataSource1.UpdateParameters[3].DefaultValue = TxtPretVanzare.Text; AccessDataSource1.UpdateParameters[4].DefaultValue = TxtIdProdus.Text; AccessDataSource1.Update(); }
private void adaugaInregistrare() { AccessDataSource1.InsertParameters[0].DefaultValue = TxtDProdus.Text; AccessDataSource1.InsertParameters[1].DefaultValue = DDLUM.Text; AccessDataSource1.InsertParameters[2].DefaultValue = DDLTVA.Text; AccessDataSource1.InsertParameters[3].DefaultValue = TxtPret.Text; AccessDataSource1.InsertParameters[4].DefaultValue = TxtCategorie.Text; AccessDataSource1.Insert(); nullControale(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int sid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); data(); query = "delete from studet where id=" + sid + ""; AccessDataSource1.DeleteCommand = query; AccessDataSource1.Delete(); con.Close(); GridView1.DataBind(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string cname = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); data(); query = "delete from compcreate where compname='" + cname + "'"; AccessDataSource1.DeleteCommand = query; AccessDataSource1.Delete(); con.Close(); GridView1.DataBind(); }
protected void ASPxUploadControl1_FileUploadComplete(object sender, FileUploadCompleteEventArgs e) { string path = "~/ImagesDB/" + e.UploadedFile.FileName; e.UploadedFile.SaveAs(Server.MapPath(path)); AccessDataSource1.InsertParameters["Model"].DefaultValue = "New Model"; AccessDataSource1.InsertParameters["Pixels"].DefaultValue = "0"; AccessDataSource1.InsertParameters["ImageFileName"].DefaultValue = e.UploadedFile.FileName; AccessDataSource1.Insert(); }
void bindData() { PagedDataSource pds = new PagedDataSource(); pds.AllowPaging = true; pds.PageSize = AspNetPager1.PageSize; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; DataView dv = (DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty); pds.DataSource = dv; Repeater1.DataSource = pds; Repeater1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath(Request.ApplicationPath.ToString()) + "//Images//" + FileUpload1.FileName); } Session["PImagePath"] = "~/Images/" + FileUpload1.FileName; AccessDataSource1.Insert(); }
protected void btnCheckout_Click(object sender, EventArgs e) { Customer currentUser = (Customer)HttpContext.Current.Session["currentUser"]; AccessDataSource1.InsertParameters["CustomerID"].DefaultValue = currentUser.CustomerID.ToString(); AccessDataSource1.InsertParameters["OrderDate"].DefaultValue = DateTime.Now.ToString(); AccessDataSource1.InsertParameters["TotalCost"].DefaultValue = cart.TotalCost.ToString(); AccessDataSource1.Insert(); cart.Clear(); Response.Redirect("Orders.aspx"); }
private int BindPagedData(int pageIndex) { // Here you can put your custom code to fetch a portion of data from your datasource PagedDataSource pds = new PagedDataSource(); pds.AllowPaging = true; pds.PageSize = 10; pds.CurrentPageIndex = pageIndex; pds.DataSource = AccessDataSource1.Select(new DataSourceSelectArguments()); Repeater1.DataSource = pds; Repeater1.DataBind(); return(pds.PageCount); }
protected void ASPxCallbackPanel1_Callback(object source, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e) { String param = e.Parameter.Replace("'", "''"); AccessDataSource1.SelectCommand = "SELECT * FROM [Products] WHERE ProductName = '" + param + "'"; IEnumerable data = AccessDataSource1.Select(DataSourceSelectArguments.Empty); foreach (DataRowView row in data) { ASPxLabel1.Text = "Price: " + row["UnitPrice"].ToString(); ASPxLabel2.Text = "Units in Stock: " + row["UnitsInStock"].ToString(); headerText = row["ProductName"].ToString(); break; } }
private DataTable CreatePivotData() { DataTable dt = new DataTable(); if (Session["PivotData"] != null) { dt = (DataTable)Session["PivotData"]; } else { dt = ((DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty)).Table; Session["PivotData"] = dt; } return(dt); }
protected void Button1_Click(object sender, EventArgs e) { DataView dv = (DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty); if (dv.Count == 1) { Label2.Visible = true; return; } else { AccessDataSource1.Insert(); Response.Redirect("~/Login.aspx"); } }
protected void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { string[] param = e.Parameters.Split('|'); if (param[0] == "oneRow") { int visibleIndex = int.Parse(param[1]); ASPxGridView grid = sender as ASPxGridView; ASPxTextBox tbCategoryName = grid.FindRowCellTemplateControl(visibleIndex, grid.Columns["CategoryName"] as GridViewDataColumn, "txtBox") as ASPxTextBox; ASPxTextBox tbDescription = grid.FindRowCellTemplateControl(visibleIndex, grid.Columns["Description"] as GridViewDataColumn, "txtBox") as ASPxTextBox; AccessDataSource1.UpdateParameters["CategoryName"].DefaultValue = tbCategoryName.Text; AccessDataSource1.UpdateParameters["Description"].DefaultValue = tbDescription.Text;; AccessDataSource1.UpdateParameters["CategoryID"].DefaultValue = grid.GetRowValues(visibleIndex, "CategoryID").ToString(); AccessDataSource1.Update(); } ASPxGridView1.DataBind(); }
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e) { AccessDataSource1.UpdateParameters["EmployeeID"].DefaultValue = ASPxTextBoxEmployeeID.Value.ToString(); AccessDataSource1.UpdateParameters["LastName"].DefaultValue = ASPxTextBoxLastName.Value.ToString(); AccessDataSource1.UpdateParameters["FirstName"].DefaultValue = ASPxTextBoxFirstName.Value.ToString(); AccessDataSource1.UpdateParameters["BirthDate"].DefaultValue = Convert.ToDateTime(ASPxDateEditBirthDate.Value).ToShortDateString(); //for example purpose only, because online editing is not supported throw new Exception("Editing in online example is not supported"); //remove this line when testing the project AccessDataSource1.Update(); //Uncomment this line ASPxGridView gridView = (ASPxGridView)sender; gridView.DataBind(); }
protected void ASPxImageGallery1_CustomCallback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e) { string[] parts = e.Parameter.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); string command = parts[0]; if (command.Equals("REMOVE", StringComparison.InvariantCultureIgnoreCase)) { File.Delete(string.Format(Server.MapPath(ASPxImageGallery1.ImageUrlFormatString), GetImageFileNameById(parts[1]))); AccessDataSource1.DeleteParameters["ID"].DefaultValue = parts[1]; AccessDataSource1.Delete(); ASPxImageGallery1.UpdateImageCacheFolder(); } else if (command.Equals("REFRESH", StringComparison.InvariantCultureIgnoreCase)) { ASPxImageGallery1.UpdateImageCacheFolder(); } }
protected void btnGetIncidents_Click(object sender, EventArgs e) { incidentsTable = (DataView) AccessDataSource1.Select(DataSourceSelectArguments.Empty); incidentsTable.RowFilter = "CustomerID = " + txtCustomerID.Text + " And DateClosed Is Not Null"; if (incidentsTable.Count > 0) { this.DisplayClosedIncidents(); this.EnableControls(true); lstIncidents.Focus(); } else { lblNoIncidents.Text = "There are no incidents for that customer."; this.EnableControls(false); } }
protected void Button3_Click(object sender, EventArgs e) { List <int> islenecekler = islenecekMesajlar(); if (islenecekler == null || islenecekler.Count == 0) { Labelbilgi.Text = "<p class='msg warning'><b>Hiçbir kayıt seçmediniz!</b></p>"; return; } foreach (int id in islenecekler) { iletisimmesaj mesaj = iletisimmesaj.Select(id); mesaj.Delete(); } AccessDataSource1.Select(DataSourceSelectArguments.Empty); ListView1.DataBind(); }