protected void RadGrid1_DeleteCommand(object source, Telerik.WebControls.GridCommandEventArgs e) { //Get the GridDataItem of the RadGrid GridDataItem item = (GridDataItem)e.Item; //Get the primary key value using the DataKeyValue. string EmployeeID = item.OwnerTableView.DataKeyValues[item.ItemIndex]["EmployeeID"].ToString(); try { //Open the SqlConnection SqlConnection.Open(); string deleteQuery = "DELETE from Employees where EmployeeID='" + EmployeeID + "'"; SqlCommand.CommandText = deleteQuery; SqlCommand.Connection = SqlConnection; SqlCommand.ExecuteNonQuery(); //Close the SqlConnection SqlConnection.Close(); } catch (Exception ex) { RadGrid1.Controls.Add(new LiteralControl("Unable to delete Employee. Reason: " + ex.Message)); e.Canceled = true; } }
protected void RadGrid1_UpdateCommand(object source, Telerik.WebControls.GridCommandEventArgs e) { //Get the GridEditableItem of the RadGrid GridEditableItem eeditedItem = e.Item as GridEditableItem; //Get the primary key value using the DataKeyValue. string EmployeeID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["EmployeeID"].ToString(); //Access the textbox from the edit form template and store the values in string variables. string LastName = (editedItem["LastName"].Controls[0] as TextBox).Text; string FirstName = (editedItem["FirstName"].Controls[0] as TextBox).Text; string Title = (editedItem["Title"].Controls[0] as TextBox).Text; string Address = (editedItem["Address"].Controls[0] as TextBox).Text; string City = (editedItem["City"].Controls[0] as TextBox).Text; try { //Open the SqlConnection SqlConnection.Open(); //Update Query to update the Datatable string updateQuery = "UPDATE Employees set LastName='" + LastName + "',FirstName='" + FirstName + "',Title='" + Title + "',Address='" + Address + "',City='" + City + "' where EmployeeID='" + EmployeeID + "'"; SqlCommand.CommandText = updateQuery; SqlCommand.Connection = SqlConnection; SqlCommand.ExecuteNonQuery(); //Close the SqlConnection SqlConnection.Close(); } catch (Exception ex) { RadGrid1.Controls.Add(new LiteralControl("Unable to update Employee. Reason: " + ex.Message)); e.Canceled = true; } }
protected void RadGrid1_InsertCommand(object source, Telerik.WebControls.GridCommandEventArgs e) { //Get the GridEditFormInsertItem of the RadGrid GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item; //string EmployeeID = (insertedItem["EmployeeID"].Controls[0] as TextBox).Text; string LastName = (insertedItem["LastName"].Controls[0] as TextBox).Text; string FirstName = (insertedItem["FirstName"].Controls[0] as TextBox).Text; string Title = (insertedItem["Title"].Controls[0] as TextBox).Text; string Address = (insertedItem["Address"].Controls[0] as TextBox).Text; string City = (insertedItem["City"].Controls[0] as TextBox).Text; try { //Open the SqlConnection SqlConnection.Open(); //Update Query to insert into the database string insertQuery = "INSERT into Employees(LastName,FirstName,Title,Address,City) values('" + LastName + "','" + FirstName + "','" + Title + "','" + Address + "','" + City + "')"; SqlCommand.CommandText = insertQuery; SqlCommand.Connection = SqlConnection; SqlCommand.ExecuteNonQuery(); //Close the SqlConnection SqlConnection.Close(); } catch (Exception ex) { RadGrid1.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message)); e.Canceled = true; }
protected void grdImportDetails_ItemCommand(object source, Telerik.WebControls.GridCommandEventArgs e) { try { if (e.CommandName == "UpdateAll") { List <ImportDetails> imList = new List <ImportDetails>(); //First store modifications made in this page to the dataset StoreValuesToDataSet(); //populate list for modified or deleted rows PopulateImportDetailsList(imList); //send modifications to the DB image of the import ImportDetails importDetails = new ImportDetails(CurrentConnectionManager); DataSet dsNewCreatedFile = importDetails.UpdateBatchImportDetails(imList, IdImport); //create new file with current state of import bool result = CreateNewFile(dsNewCreatedFile); if (result) { if (!Page.ClientScript.IsClientScriptBlockRegistered(this.Page.GetType(), "ButtonUpdateClick")) { Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "ButtonUpdateClick", "window.returnValue = 1; window.close();", true); } } else { //After saving, if something went wrong re-load the grid DsLogs = null; LoadEditableGrid(); } } //When changing the page, we need to store any possible modifications made to the current page in the underlying datasource of the //grid if (e.CommandName == "Page") { StoreValuesToDataSet(); } } catch (IndException indExc) { SaveSuccessful = false; ShowError(indExc); } catch (Exception exc) { SaveSuccessful = false; ShowError(new IndException(exc)); } finally { if (!ClientScript.IsClientScriptBlockRegistered(this.GetType(), "ResizePopUp")) { ClientScript.RegisterClientScriptBlock(this.GetType(), "ResizePopUp", "SetPopUpHeight();", true); } } }
protected void grdImportDetails_ItemCommand(object source, Telerik.WebControls.GridCommandEventArgs e) { try { if (e.CommandName == "UpdateAll") { //First store modifications made in this page to the dataset StoreValuesToDataSet(); List <AnnualImportDetails> imList = new List <AnnualImportDetails>(); foreach (DataRow row in DsLogs.Tables[0].Rows) { AnnualImportDetails importDetails = new AnnualImportDetails(CurrentConnectionManager); importDetails.IdImport = (int)row["IdImport"]; importDetails.IdRow = (int)row["IdRow"]; importDetails.CostCenter = (row["CostCenter"] == DBNull.Value) ? string.Empty : row["CostCenter"].ToString(); importDetails.ProjectCode = (row["ProjectCode"] == DBNull.Value) ? string.Empty : row["ProjectCode"].ToString(); importDetails.WPCode = (row["WPCode"] == DBNull.Value) ? string.Empty : row["WPCode"].ToString(); importDetails.AccountNumber = (row["AccountNumber"] == DBNull.Value) ? string.Empty : row["AccountNumber"].ToString(); if (row["Quantity"] != DBNull.Value) { importDetails.Quantity = (decimal)row["Quantity"]; } if (row["Value"] != DBNull.Value) { importDetails.Value = (decimal)row["Value"]; } if (row["CurrencyCode"] != DBNull.Value) { importDetails.CurrencyCode = row["CurrencyCode"].ToString(); } if (row["Date"] != DBNull.Value) { importDetails.ImportDate = (DateTime)row["Date"]; } imList.Add(importDetails); } if (imList.Count > 0) { AnnualImportDetails annualImportDetails = new AnnualImportDetails(CurrentConnectionManager); DataSet dsNewCreatedFile = annualImportDetails.UpdateBatchImportDetails(imList); //After saving, remove the previous information from the session so that the old data (from the annual logs) //is loaded from the db DsLogs = null; LoadEditableGrid(); CreateNewFile(dsNewCreatedFile); } if (!Page.ClientScript.IsClientScriptBlockRegistered(this.Page.GetType(), "ButtonUpdateClick")) { Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "ButtonUpdateClick", "window.returnValue = 1; window.close();", true); } } //When changing the page, we need to store any possible modifications made to the current page in the underlying datasource of the //grid if (e.CommandName == "Page") { StoreValuesToDataSet(); } } catch (IndException indExc) { SaveSuccessful = false; ShowError(indExc); } catch (Exception exc) { SaveSuccessful = false; ShowError(new IndException(exc)); } finally { if (!ClientScript.IsClientScriptBlockRegistered(this.GetType(), "ResizePopUp")) { ClientScript.RegisterClientScriptBlock(this.GetType(), "ResizePopUp", "SetPopUpHeight();", true); } } }