protected override bool OnBubbleEvent(object sender, EventArgs e) { CommandEventArgs ce = e as CommandEventArgs; if (ce != null) { ListViewCommandEventArgs lce = new ListViewCommandEventArgs(this, sender, ce); RaiseBubbleEvent(this, lce); return true; } return false; }
/// <summary> /// Toggle time series for soil /// </summary> protected void OnItemCommandSOIL(object sender, ListViewCommandEventArgs e) { onItemCommand(sender, e, MediumFilter.Medium.Soil); }
protected void lstChildMyTag_ItemCommand(object sender, ListViewCommandEventArgs e) { HiddenField hdnPkId = (HiddenField)e.Item.FindControl("hdnPkId"); HiddenField hdnTableName = (HiddenField)e.Item.FindControl("hdnTableName"); Label lblEmailId = (Label)e.Item.FindControl("lblEmailId"); Label lblGroupName = (Label)e.Item.FindControl("lblGroupName"); HiddenField hdnrequserid = (HiddenField)e.Item.FindControl("hdnrequserid"); HiddenField hdnRegistrationId = (HiddenField)e.Item.FindControl("hdnRegID"); LinkButton lnkstrLink = (LinkButton)e.Item.FindControl("lnkstrLink"); HiddenField hdnShareInvitee = (HiddenField)e.Item.FindControl("hdnShareInvitee"); ViewState["lblGroupName"] = lblGroupName.Text; hdnEmailId.Value = lblEmailId.Text; if (e.CommandName == "Details") { Response.Redirect(lnkstrLink.Text); } else if (e.CommandName == "ShareDetails") { if (hdnRegistrationId.Value != Convert.ToString(ViewState["UserID"])) { Response.Redirect("Group-Home.aspx?GrpId=" + hdnrequserid.Value); } } else if (e.CommandName == "Confirm") { if (hdnTableName.Value == "Scrl_UserRequestInvitationTbl") { objRegistration.intRequestInvitaionId = Convert.ToInt32(hdnPkId.Value); objRegistration.AddedBy = Convert.ToInt32(Session["ExternalUserId"].ToString()); objRegistration.IpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (objRegistration.IpAddress == null) { objRegistration.IpAddress = Request.ServerVariables["REMOTE_ADDR"]; } objRegistrationDB.AddEditDel_Request(objRegistration, DA_Registrationdetails.RegistrationDetails.Update); SendMail(e.CommandName, hdnTableName.Value); } else if (hdnTableName.Value == "Scrl_UserGroupJoiningTbl") { objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value); objGrpJoinDO.intAddedBy = Convert.ToInt32(Session["ExternalUserId"].ToString()); objGrpJoinDO.isAccepted = 1; objGrpJoinDO.strIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (objGrpJoinDO.strIpAddress == null) { objGrpJoinDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"]; } objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Update); SendMail(e.CommandName, hdnTableName.Value); } else if (hdnTableName.Value == "Scrl_UserRecommendationTbl") { objRecmndDO.intRecommendationId = Convert.ToInt32(hdnPkId.Value); objRecmndDO.intAddedBy = Convert.ToInt32(Session["ExternalUserId"].ToString()); objRecmndDO.strIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (objRecmndDO.strIpAddress == null) { objRecmndDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"]; } objRecmndDA.Scrl_AddEditDelRecommendations(objRecmndDO, DA_Scrl_UserRecommendation.Scrl_UserRecommendation.Update); SendMail(e.CommandName, hdnTableName.Value); } else if (hdnTableName.Value == "Scrl_RequestGroupJoin") { objgrp.intAddedBy = Convert.ToInt32(Session["ExternalUserId"].ToString()); objgrp.inGroupId = Convert.ToInt32(hdnShareInvitee.Value); DataSet ds = new DataSet(); ds = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetOtherGroupDetailsByGroupId); if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "A") { if (ds.Tables[1].Rows.Count > 0) { if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "0") { objGrpJoinDO.isAccepted = 1; } else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "1") { objGrpJoinDO.isAccepted = 2; } else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "2") { objGrpJoinDO.isAccepted = 1; } } else { if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "A") { objGrpJoinDO.isAccepted = 1; } } } else if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "R") { if (ds.Tables[1].Rows.Count > 0) { if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "0") { objGrpJoinDO.isAccepted = 1; lblSuccess.Text = "You have already send the group joining request."; lblSuccess.ForeColor = System.Drawing.Color.Red; divSuccess.Style.Add("display", "block"); return; } else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "1") { objGrpJoinDO.isAccepted = 2; } else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "2") { objGrpJoinDO.isAccepted = 0; } } } objGrpJoinDO.isAccepted = 1; objGrpJoinDO.inGroupId = Convert.ToInt32(hdnShareInvitee.Value); objGrpJoinDO.intInvitedUserId = Convert.ToInt32(ds.Tables[0].Rows[0]["intRegistrationId"]); string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (ip == null) { ip = Request.ServerVariables["REMOTE_ADDR"]; } objGrpJoinDO.strIpAddress = ip; objGrpJoinDO.intAddedBy = Convert.ToInt32(Session["ExternalUserId"].ToString()); objGrpJoinDO.intRegistrationId = Convert.ToInt32(Session["ExternalUserId"].ToString()); objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Insert); objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value); objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.UpdateGroupMember); } BindAllRequest(); } else if (e.CommandName == "Delete") { ViewState["hdnTableName"] = hdnTableName.Value; ViewState["intRequestInvitaionId"] = hdnPkId.Value; divSuccess.Style.Add("display", "block"); } }
protected void lvMDAsset_ItemCommand(object sender, ListViewCommandEventArgs e) { }
protected void lstProductDetails_ItemCommand(object sender, ListViewCommandEventArgs e) { var item = e.Item as ListViewDataItem; var cmd = e.CommandName; var ProductOptionCategoryID = ""; //(item.FindControl("hdnProductOptionCategoryID") as HiddenField).Value; var ProductOptionCategoryName = ""; //(item.FindControl("hdnProductOptionCategoryName") as HiddenField).Value; var ProductID = (item.FindControl("hdnProductID") as HiddenField).Value; var ProductName = (item.FindControl("lblProductName") as Label).Text; var ProductNameEn = ""; //(item.FindControl("lblProductNameEn") as Label).Text; var ImageName = (item.FindControl("hdnImageName") as HiddenField).Value; var ProductCode = ""; //(item.FindControl("hdnProductCode") as HiddenField).Value; var ProductLengthID = ""; //(item.FindControl("hdnProductLengthID") as HiddenField).Value; var ProductLengthName = ""; //(item.FindControl("hdnProductLengthName") as HiddenField).Value; var Quantity = "1"; double Price = Convert.ToDouble((item.FindControl("hdnPrice") as HiddenField).Value); string ProductSizeColorID1 = ""; string QuantityList = ""; int SizeColorQuantity1 = 0; var oProductSizeColor = new ProductSizeColor(); var oShoppingCart = new ShoppingCart(); if (cmd == "AddToCart") { //try //{ // if (ProductID != "") // { // if (oShoppingCart.CartSelectOne(ProductID).DefaultView.Count > 0) // { // //var dv = oProductSizeColor.ProductSizeColorSelectAll(ProductLengthID, ProductOptionCategoryID, ProductID, "True", // // "True", "", "True").DefaultView; // //ProductSizeColorID1 = dv[0]["ProductSizeColorID"].ToString(); // //SizeColorQuantity1 = Convert.ToInt32(dv[0]["Quantity"].ToString()) - Convert.ToInt32(dv[0]["QuantitySale"].ToString()); // //for (int i = 1; i <= SizeColorQuantity1; i++) // //{ // // QuantityList = QuantityList + i + ","; // //} // var dv = oShoppingCart.CartSelectOne(ProductID).DefaultView; // int iQuantityAdd = Convert.ToInt32(dv[0]["Quantity"].ToString()) + 1; // oShoppingCart.UpdateQuantity(ProductID, ProductLengthID, ProductOptionCategoryID, // iQuantityAdd.ToString()); // } // else // { // oShoppingCart.CreateCart(ProductID, // ImageName, // ProductName, // ProductNameEn, // ProductCode, // ProductOptionCategoryID, // ProductOptionCategoryName, // ProductLengthID, // ProductLengthName, // ProductSizeColorID1, // Quantity, // SizeColorQuantity1.ToString(), // Price, // false // ); // } // } //} //catch (Exception ex) //{ //} oShoppingCart.CreateCart(ProductID, ImageName, ProductName, ProductNameEn, ProductCode, ProductOptionCategoryID, ProductOptionCategoryName, ProductLengthID, ProductLengthName, ProductSizeColorID1, Quantity, SizeColorQuantity1.ToString(), Price, false ); //ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "runtime", "myconfirmPopup('" + "<strong>" + ProductName + " - " + ProductCode + " - " + ProductOptionCategoryName + "</strong><br/> đã được thêm vào giỏ hàng" + "')", true); Response.Redirect("thong-tin-dat-hang.aspx"); } }
protected void uoListViewHotelHeader_ItemCommand(object sender, ListViewCommandEventArgs e) { uoHiddenFieldOrder.Value = e.CommandName; BindVehicleManifestWithOrder(); }
protected void GridView1_ItemCommand(object sender, ListViewCommandEventArgs e) { // Separate the command arguments string[] commandArguments = e.CommandArgument.ToString().Split(Common.separator, StringSplitOptions.None); string fileName = commandArguments[0]; // File or folder name bool isFolder = bool.Parse(commandArguments[1]); // is Folder? if (e.CommandName == "OpenFolder") { // If it is a folder if (isFolder == true) { if (string.CompareOrdinal(fileName, "..") == 0) { var currentFullPath = this.CurrentFolder; if (currentFullPath.EndsWith("\\") || currentFullPath.EndsWith("/")) { currentFullPath = currentFullPath.Substring(0, currentFullPath.Length - 1); } currentFullPath = currentFullPath.Replace("/", "\\"); var folders = currentFullPath.Split("\\".ToCharArray()); this.CurrentFolder = string.Join("\\", folders, 0, folders.Length - 1); } else { this.CurrentFolder = Path.Combine(this.CurrentFolder, fileName as string); } PopulateFoldersAndFiles(); } } else if (e.CommandName == "DownloadFile") { // Only download the file if (isFolder == false) { Response.ContentType = ContentType; Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(fileName)); Response.WriteFile(fileName); Response.End(); } } else if (e.CommandName == "DeleteFile") { // Handle delete file if (isFolder == false && File.Exists(fileName)) { File.Delete(fileName); //PopulateFoldersAndFiles(); } // Handle delete folder else { if (Directory.Exists(fileName)) { Directory.Delete(fileName, true); } } // Delete works in thread, sleep for .5 sec, to give it time to delete the files // Otherwise, populate method fetches the files, which were just deleted. System.Threading.Thread.Sleep(500); // Refresh the files and folders list after deleting PopulateFoldersAndFiles(); } }
protected void CenterLView_ItemCommand(object sender, ListViewCommandEventArgs e) { string c_id = e.CommandArgument.ToString(); Response.Redirect("Detail.aspx?centerid=" + c_id + "&type=ss"); }
protected void SeminarLView_ItemCommand(object sender, ListViewCommandEventArgs e) { string s_id = e.CommandArgument.ToString(); Response.Redirect("Detail.aspx?seminarid=" + s_id + "&type=sem"); }
protected void ItemLView_ItemCommand(object sender, ListViewCommandEventArgs e) { string item_id = e.CommandArgument.ToString(); Response.Redirect("ItemDetail.aspx?itemid=" + item_id); }
protected void JobLView_ItemCommand(object sender, ListViewCommandEventArgs e) { string j_id = e.CommandArgument.ToString(); Response.Redirect("Detail.aspx?jobid=" + j_id + "&type=jv"); }
public void lvwClasses_ItemCommand(object sender, ListViewCommandEventArgs e) { string commandName = e.CommandName.ToLower(); if (!commandName.StartsWith("x")) { return; } ScheduleBLL scheduleDB = new ScheduleBLL(); bool dbModified = false; string xPath = (string)e.CommandArgument; if (commandName.Equals("xdelete")) { if (scheduleDB.deleteItem(xPath)) { lvwClasses.DataBind(); dbModified = true; } } else { ClassInfo classInfo = new ClassInfo(); TextBox txtStartsDate = (TextBox)e.Item.FindControl("txtStartsDate"); HiddenField hidMandatoryDateArray = (HiddenField)e.Item.FindControl("hidMandatoryDateArray"); TextBox txtMandatoryDate = (TextBox)e.Item.FindControl("txtMandatoryDate"); HiddenField hidSkipDateArray = (HiddenField)e.Item.FindControl("hidSkipDateArray"); TextBox txtSkipDate = (TextBox)e.Item.FindControl("txtSkipDate"); TextBox txtEndsDate = (TextBox)e.Item.FindControl("txtEndsDate"); TextBox txtDays = (TextBox)e.Item.FindControl("txtDays"); TextBox txtTime = (TextBox)e.Item.FindControl("txtTime"); TextBox txtArea = (TextBox)e.Item.FindControl("txtArea"); CheckBox chkFilled = (CheckBox)e.Item.FindControl("chkFilled"); CheckBox chkCancelled = (CheckBox)e.Item.FindControl("chkCancelled"); classInfo.StartDate = DateTime.Parse(txtStartsDate.Text); classInfo.EndDate = DateTime.Parse(txtEndsDate.Text); classInfo.Days = txtDays.Text; classInfo.Time = txtTime.Text; classInfo.Area = txtArea.Text; classInfo.Filled = chkFilled.Checked; classInfo.Cancelled = chkCancelled.Checked; // If hidMandatoryDateArray is blank, then only set the MandatoryDate, // otherwise set the MandatoryDateArray, which uses the first Date from the array as MandatoryDate if (string.IsNullOrEmpty(hidMandatoryDateArray.Value)) { classInfo.MandatoryDate = (string.IsNullOrEmpty(txtMandatoryDate.Text) ? DateTime.MinValue : DateTime.Parse(txtMandatoryDate.Text)); } else { classInfo.MandatoryDateArray = hidMandatoryDateArray.Value; } // If hidSkipDateArray is blank, then only set the SkipDate, // otherwise set the SkipDateArray, which uses the first Date from the array as SkipDate if (string.IsNullOrEmpty(hidSkipDateArray.Value)) { classInfo.SkipDate = (string.IsNullOrEmpty(txtSkipDate.Text) ? DateTime.MinValue : DateTime.Parse(txtSkipDate.Text)); } else { classInfo.SkipDateArray = hidSkipDateArray.Value; } // Update or save the series info based on the command name if (commandName.Equals("xupdate")) { if (scheduleDB.saveChanges(xPath, classInfo)) { lvwClasses.EditIndex = -1; dbModified = true; } } else // xinsert { if (scheduleDB.saveNewItem(xPath, classInfo)) { lvwClasses.DataBind(); dbModified = true; } } if (dbModified) { string strScript = "highLightClass('" + classInfo.ID.ToString() + "');"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "hlClass", strScript, true); } } displayDbError(dbModified, scheduleDB.Error, commandName); }
public void lvwSchedule_ItemCommand(object sender, ListViewCommandEventArgs e) { string commandName = e.CommandName.ToLower(); if (!commandName.StartsWith("x")) { return; } ScheduleBLL scheduleDB = new ScheduleBLL(); bool dbModified = false; string xPath = (string)e.CommandArgument; if (commandName.Equals("xdelete")) { if (scheduleDB.deleteItem(xPath)) { lvwSchedule.DataBind(); dbModified = true; } } else { SeriesInfo seriesInfo = new SeriesInfo(); DropDownList ddlMonth = (DropDownList)e.Item.FindControl("ddlMonth"); DropDownList ddlYear = (DropDownList)e.Item.FindControl("ddlYear"); TextBox txtTitle = (TextBox)e.Item.FindControl("txtTitle"); CheckBox chkCustomTitle = (CheckBox)e.Item.FindControl("chkCustomTitle"); CheckBox chkVisible = (CheckBox)e.Item.FindControl("chkVisible"); // Set the new series information data seriesInfo.Date = new DateTime(int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), 1); seriesInfo.Title = txtTitle.Text; seriesInfo.CustomTitle = chkCustomTitle.Checked; seriesInfo.Visible = chkVisible.Checked; // Update or save the series info based on the command name if (commandName.Equals("xupdate")) { if (scheduleDB.saveChanges(xPath, seriesInfo)) { lvwSchedule.EditIndex = -1; dbModified = true; } } else // xinsert { if (scheduleDB.saveNewItem(seriesInfo)) { lvwSchedule.DataBind(); dbModified = true; } } if (dbModified) { string strScript = "highLightSeries('" + seriesInfo.Date.ToShortDateString() + "');"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "hlSeries", strScript, true); } } displayDbError(dbModified, scheduleDB.Error, commandName); }
protected void ConfirmData_ItemCommand(object sender, ListViewCommandEventArgs e) { try { string commandName = e.CommandName; object commandArg = e.CommandArgument; ListViewItem selectedItem = e.Item; int dataItemIndex = selectedItem.DataItemIndex; int HID = Convert.ToInt32(commandArg); if (commandName == "RentApartment") { Session["HID"] = HID; Response.Redirect("~/Models/Member/PropertyRent.aspx"); } else if (commandName == "SellApartment") { Session["HID"] = HID; Response.Redirect("~/Models/Member/PropertySell.aspx"); } else if (commandName == "DeleteRent") { Label Apartment = (Label)e.Item.FindControl("lblApartmentNo"); if (Page.IsValid) { string sql = null; try { SqlConnection cnn = new SqlConnection("Data Source = JARVIS; Initial Catalog = HousingMSdb; User ID = sa; Password = 2411"); cnn.Open(); sql = "DELETE FROM Rent WHERE HID=@HID; DBCC CHECKIDENT ('Rent', RESEED, 0);"; using (SqlCommand cmd = new SqlCommand(sql, cnn)) { cmd.Parameters.Add("@HID", SqlDbType.Int).Value = HID; if (cmd.ExecuteNonQuery() == 1) { string notiftype = "Property Rent Ad"; string notif = "Apartment " + Apartment.Text + " Rent Ad has been deleted."; Notification(cnn, notiftype, notif); Response.Redirect(Request.RawUrl, false); } else { System.Windows.Forms.MessageBox.Show("Rent could not be deleted, please try again."); } } } catch (System.Data.SqlClient.SqlException sqlException) { System.Windows.Forms.MessageBox.Show("SQL: " + sqlException.Message); } } } else if (commandName == "DeleteSell") { Label Apartment = (Label)e.Item.FindControl("lblApartmentNo"); if (Page.IsValid) { string sql = null; try { SqlConnection cnn = new SqlConnection("Data Source = JARVIS; Initial Catalog = HousingMSdb; User ID = sa; Password = 2411"); cnn.Open(); sql = "DELETE FROM Sell WHERE HID=@HID; DBCC CHECKIDENT ('Sell', RESEED, 0);"; using (SqlCommand cmd = new SqlCommand(sql, cnn)) { cmd.Parameters.Add("@HID", SqlDbType.Int).Value = HID; if (cmd.ExecuteNonQuery() == 1) { string notiftype = "Property Sale Ad"; string notif = "Apartment " + Apartment.Text + " Sale Ad has been deleted."; Notification(cnn, notiftype, notif); Response.Redirect(Request.RawUrl, false); } else { System.Windows.Forms.MessageBox.Show("Sale could not be deleted, please try again."); } } } catch (System.Data.SqlClient.SqlException sqlException) { System.Windows.Forms.MessageBox.Show("SQL: " + sqlException.Message); } } } else if (commandName == "Images") { } } catch (FormatException) { System.Windows.Forms.MessageBox.Show("Please enter the price."); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } }
protected void ListView1_ItemCommand(object sender, ListViewCommandEventArgs e) { Guid post_id = Guid.Empty; String like_Id = ""; String post_userId = ""; Guid currentUserId = Guid.Empty; String user_Id = ""; try { like_Id = ListView1.DataKeys[e.Item.DataItemIndex].Values[1].ToString(); post_userId = ListView1.DataKeys[e.Item.DataItemIndex].Values[2].ToString(); MembershipUser currentUser = Membership.GetUser(); post_id = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[0]; currentUserId = (Guid)currentUser.ProviderUserKey; user_Id = currentUserId.ToString(); } catch { } if (String.Equals(e.CommandName, "allcomment")) { //Panel cp= ListView1.FindControl("PanelPostComment") as Panel; //string cpanel = cp.ClientID; postId = post_id; //PostCommentDataSource.SelectCommand = "SELECT * FROM [UserComments] WHERE ([PostId] = @PostId) ORDER BY [CommentDate]"; //PostCommentDataSource.SelectParameters.Clear(); //PostCommentDataSource.SelectParameters.Add("PostId", post_id.ToString()); PostCommentDataSource.DataBind(); //return; } if (String.Equals(e.CommandName, "LikeButton")) { //ListViewDataItem dataItem = (ListViewDataItem)e.Item; //Guid code = (Guid)ListView1.DataKeys[dataItem.DisplayIndex].Value; likeId_in = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[1]; //if (String.Equals(lbtn.Text , "Like")) //{ ImageButton lb = e.Item.FindControl("LinkButtonLike") as ImageButton; LinkButton lbviewallcomment = e.Item.FindControl("LinkViewAllComment") as LinkButton; System.Data.SqlClient.SqlDataReader rdr = null; System.Data.SqlClient.SqlConnection conn = null; System.Data.SqlClient.SqlCommand sqlcmd = null; try { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [UserLikes]", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); //if (rdr.HasRows) //{ while (rdr.Read()) { String usrid = rdr["UserId"].ToString(); String lkid = rdr["LikeId"].ToString(); if (user_Id == usrid && like_Id == lkid) { string connectionString10 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; //string selectSql = "SELECT * FROM UserLikes WHERE UserId = @UserId"; string Sql = "delete from [UserLikes] WHERE LikeId=@LikeId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString10)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(Sql, myConnection); myCommand.Parameters.AddWithValue("@LikeId", new Guid(like_Id)); myCommand.Parameters.AddWithValue("@UserId", new Guid(user_Id)); myCommand.ExecuteNonQuery(); myConnection.Close(); } return; //rdr.NextResult(); } } string connectionString11 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql = "INSERT INTO UserLikes(LikeId,LikeUser,UserId) VALUES(@LikeId,@LikeUser,@UserId)"; using (SqlConnection myConnection = new SqlConnection(connectionString11)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@LikeId", like_Id); myCommand.Parameters.AddWithValue("@LikeUser", HttpContext.Current.Session["user"]); myCommand.Parameters.AddWithValue("@UserId", user_Id); myCommand.ExecuteNonQuery(); myConnection.Close(); } string connectionString5 = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [Notifications]", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); //if (rdr.HasRows) //{ while (rdr.Read()) { String usrid = rdr["UserId"].ToString(); String lkid = rdr["LikeId"].ToString(); String notify = rdr["NotifyTo"].ToString(); if (user_Id == usrid && like_Id == lkid && notify == post_userId) { return; } } if (user_Id != post_userId) { string connectionString12 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql2 = "INSERT INTO Notifications(UserId,LikeId,Type,NotifyTo,PostId) VALUES(@UserId,@LikeId,@Type,@NotifyTo,@PostId)"; using (SqlConnection myConnection = new SqlConnection(connectionString12)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql2, myConnection); myCommand.Parameters.AddWithValue("@LikeId", like_Id); myCommand.Parameters.AddWithValue("@Type", "Post_Like"); myCommand.Parameters.AddWithValue("@UserId", user_Id); myCommand.Parameters.AddWithValue("@NotifyTo", post_userId); ListView lstview = sender as ListView; Guid post__id = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[0]; myCommand.Parameters.AddWithValue("@PostId", post__id); myCommand.ExecuteNonQuery(); myConnection.Close(); } } if (rdr != null) { rdr.Close(); } } catch (Exception ex) { } finally { if (conn != null) { conn.Close(); } this.DataBind(); } } if (String.Equals(e.CommandName, "SharePostId")) { sharepostId = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[0]; //((AjaxControlToolkit.ModalPopupExtender)(ListView1.FindControl("MPEShare"))).Show(); //MPEShare.Show(); } if (String.Equals(e.CommandName, "Updatepost")) { Label lbl = ListView1.EditItem.FindControl("PostIdLabel") as Label; if (lbl != null) { postId_edit = new Guid(lbl.Text); } TextBox txt = ListView1.EditItem.FindControl("PostTextBox") as TextBox; String edit_text = txt.Text; string connectionString = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string updateSql = "UPDATE [UserPosts] SET [Post] = @Post WHERE [PostId] = @PostId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(updateSql, myConnection); myCommand.Parameters.AddWithValue("@Post", edit_text); myCommand.Parameters.AddWithValue("@PostId", postId_edit); myCommand.Parameters.AddWithValue("@UserId", currentUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } ListView1.EditIndex = -1; Button btnCancel = (ListView1.Items[e.Item.DataItemIndex].FindControl("CancelButton")) as Button; //Button btnCancel= ListView1.EditItem.FindControl("CancelButton") as Button; //CancelButton_Click(btnCancel, EventArgs.Empty); //btnCancel.Visible = true; //Type t = typeof(Button); //object[] p = new object[1]; //p[0] = EventArgs.Empty; //MethodInfo m = t.GetMethod("OnClick", BindingFlags.NonPublic | BindingFlags.Instance); //m.Invoke(btnCancel, p); ListView1.DataBind(); } if (String.Equals(e.CommandName, "Deletepost")) { Guid post_Id = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[0]; string connectionString = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string Sql = "delete from [UserPosts] WHERE [PostId]=@PostId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(Sql, myConnection); myCommand.Parameters.AddWithValue("@PostId", post_Id); myCommand.Parameters.AddWithValue("@UserId", currentUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } //ListView2.DataBind(); //UpdatePanel1.Update(); } ListView1.DataBind(); }
protected void ExhibitionLView_ItemCommand(object sender, ListViewCommandEventArgs e) { string ex_id = e.CommandArgument.ToString(); Response.Redirect("Detail.aspx?ewid=" + ex_id + "&type=expo"); }
protected void LVPatientDetailDetails_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "EditData") { //PageReset(); Label lblPHCID = (Label)e.Item.FindControl("lblPHCID"); Label lblPatientID = (Label)e.Item.FindControl("lblPatientID"); Label lblPatientName = (Label)e.Item.FindControl("lblPatientName"); Label lblECNumber = (Label)e.Item.FindControl("lblECNumber"); Label lblBloodGroup = (Label)e.Item.FindControl("lblBloodGroup"); Label lblGender = (Label)e.Item.FindControl("lblGender"); Label lblAge = (Label)e.Item.FindControl("lblAge"); Label lblDOB = (Label)e.Item.FindControl("lblDOB"); Label lblPlace = (Label)e.Item.FindControl("lblPlace"); Label lblContactNo = (Label)e.Item.FindControl("lblContactNo"); Label lblRefPhoneNo = (Label)e.Item.FindControl("lblRefPhoneNo"); Label lblAddress = (Label)e.Item.FindControl("lblAddress"); Label lblVillageID = (Label)e.Item.FindControl("lblVillageID"); Label lblEducationID = (Label)e.Item.FindControl("lblEducationID"); Label lblReligionID = (Label)e.Item.FindControl("lblReligionID"); Label lblIsMarried = (Label)e.Item.FindControl("lblIsMarried"); Label lblHusbandName = (Label)e.Item.FindControl("lblHusbandName"); Label lblFatherName = (Label)e.Item.FindControl("lblFatherName"); string PatientID = lblPatientID.Text; btnSave.Visible = false; btnUpdate.Visible = true; txtPatientName.Text = lblPatientName.Text; txtECNo.Text = lblECNumber.Text; if (!string.IsNullOrEmpty(txtECNo.Text)) { ViewState[VSECNo] = txtECNo.Text; } else { ViewState[VSECNo] = null; } ddlBloodGroup.SelectedValue = lblBloodGroup.Text; if (lblGender.Text == PHCConstant.Male) { rbMale.Checked = true; } else { rbFemale.Checked = true; } if (lblIsMarried.Text == PHCConstant.Married) { rbMale.Checked = true; } else if (lblIsMarried.Text == PHCConstant.Single) { rbUnmarried.Checked = true; } txtHusbandName.Text = lblHusbandName.Text; txtFatherName.Text = lblFatherName.Text; txtAge.Text = lblAge.Text; txtDOB.Text = lblDOB.Text; BindVillages(); ddlVillages.SelectedValue = lblVillageID.Text; BindReligion(); ddlReligion.SelectedValue = lblReligionID.Text; BindEducation(); ddlEducation.SelectedValue = lblEducationID.Text; txtAddress.Text = lblAddress.Text; txtContactNo.Text = lblContactNo.Text; txtPhoneNo.Text = lblRefPhoneNo.Text; ViewState[VSPatientID] = PatientID; } }
protected void lvBDProjectCollectedDocumentCategoryInfo_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 ProjectCollectedDocumentCategoryInfoID; Int64.TryParse(e.CommandArgument.ToString(), out ProjectCollectedDocumentCategoryInfoID); if (ProjectCollectedDocumentCategoryInfoID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _ProjectCollectedDocumentCategoryInfoID = ProjectCollectedDocumentCategoryInfoID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(BDProjectCollectedDocumentCategoryInfoEntity.FLD_NAME_ProjectCollectedDocumentCategoryInfoID, ProjectCollectedDocumentCategoryInfoID.ToString(), SQLMatchType.Equal); BDProjectCollectedDocumentCategoryInfoEntity bDProjectCollectedDocumentCategoryInfoEntity = new BDProjectCollectedDocumentCategoryInfoEntity(); result = FCCBDProjectCollectedDocumentCategoryInfo.GetFacadeCreate().Delete(bDProjectCollectedDocumentCategoryInfoEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _ProjectCollectedDocumentCategoryInfoID = 0; _BDProjectCollectedDocumentCategoryInfoEntity = new BDProjectCollectedDocumentCategoryInfoEntity(); PrepareInitialView(); BindBDProjectCollectedDocumentCategoryInfoList(); MiscUtil.ShowMessage(lblMessage, "Project Collected Document Category Info has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Project Collected Document Category Info.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
protected void lvPRMWorkOrder_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 WorkOrderID; Int64.TryParse(e.CommandArgument.ToString(), out WorkOrderID); if (WorkOrderID > 0) { if (string.Equals(e.CommandName, "EditItem")) { String url = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrder.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, WorkOrderID.ToString()).ToString(); Response.Redirect(url); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, WorkOrderID.ToString(), SQLMatchType.Equal); PRMWorkOrderEntity pRMWorkOrderEntity = new PRMWorkOrderEntity(); result = FCCPRMWorkOrder.GetFacadeCreate().Delete(pRMWorkOrderEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _WorkOrderID = 0; _PRMWorkOrderEntity = new PRMWorkOrderEntity(); PrepareInitialView(); BindPRMWorkOrderList(); MiscUtil.ShowMessage(lblMessage, "Work Order has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Work Order.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } else if (string.Equals(e.CommandName, "UpdateItem")) { try { #region Approval Process Boolean apResult = APRobot.ResetApprovalProcessForWorkOrder(WorkOrderID); if (apResult == true) { MiscUtil.ShowMessage(lblMessage, "Approval Process has been reset successfully.", UIConstants.MessageType.GREEN); } else { MiscUtil.ShowMessage(lblMessage, "Failed to reset approval process.", UIConstants.MessageType.RED); } // EnableDisableApprovalProcessCheck(); BindList(); #endregion //Int64 result = -1; //String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, WorkOrderID.ToString(), SQLMatchType.Equal); //PRMWorkOrderEntity pRMWorkOrderEntity = new PRMWorkOrderEntity(); //result = FCCPRMWorkOrder.GetFacadeCreate().Delete(pRMWorkOrderEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); //if (result == 0) //{ // _WorkOrderID = 0; // _PRMWorkOrderEntity = new PRMWorkOrderEntity(); // PrepareInitialView(); // BindPRMWorkOrderList(); // MiscUtil.ShowMessage(lblMessage, "Work Order has been successfully deleted.", true); //} //else //{ // MiscUtil.ShowMessage(lblMessage, "Failed to delete Work Order.", true); //} } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
protected void uoListViewDashboard_ItemCommand(object sender, ListViewCommandEventArgs e) { }
protected void RevListView_ItemCommand(object sender, ListViewCommandEventArgs e) { }
//protected void AuctionGridView_SelectedIndexChanged(object sender, EventArgs e) //{ // GridViewRow row = AuctionGridView.Rows[AuctionGridView.SelectedIndex]; // Session["Auction"] = row.Cells[3].Text; // Response.Redirect("Auction.aspx"); //} protected void SelectAuctionBtn_Click(object sender, ListViewCommandEventArgs e) { Session["Auction"] = e.CommandArgument; Response.Redirect("Auction.aspx"); }
protected void lvPRMMaterialReceiveItemMap_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 MaterialReceiveItemMapID; Int64.TryParse(e.CommandArgument.ToString(), out MaterialReceiveItemMapID); if (e.CommandName == "FloorWiseRateAndQty") { CurrentWorkOrderItemIDPopup = MaterialReceiveItemMapID; Label lblItemLV = (Label)e.Item.FindControl("lblItemLV"); Label lblRequisitionIDLV = (Label)e.Item.FindControl("lblRequisitionIDLV"); Label lblRequisitionItemIDLV = (Label)e.Item.FindControl("lblRequisitionItemIDLV"); Label lblWorkOrderItemMapIDLV = (Label)e.Item.FindControl("lblWorkOrderItemMapIDLV"); Label lblProjectIDLV = (Label)e.Item.FindControl("lblProjectIDLV"); Label lblWorkOrderIDLV = (Label)e.Item.FindControl("lblWorkOrderIDLV"); Int64 itemID; Int64.TryParse(lblItemLV.Text.Trim(), out itemID); String fe_floor = SqlExpressionBuilder.PrepareFilterExpression(BDProjectFloorEntity.FLD_NAME_ProjectID, lblProjectIDLV.Text.ToString(), SQLMatchType.Equal); IList <BDProjectFloorEntity> lstBDProjectFloor = FCCBDProjectFloor.GetFacadeCreate().GetIL(null, null, String.Empty, fe_floor, DatabaseOperationType.LoadWithFilterExpression); if (lstBDProjectFloor != null && lstBDProjectFloor.Count > 0) { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, lblProjectIDLV.Text.ToString(), SQLMatchType.Equal); IList <PRMPreBOQEntity> preBOQList = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (preBOQList != null && preBOQList.Count > 0) { Int64 preBOQID = preBOQList[0].PreBOQID; switch (preBOQList[0].IsLocked) { case true: #region GET Item From BOQ String fe_boq = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal); IList <PRMBOQEntity> lstPRMBOQ = FCCPRMBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_boq, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMBOQ != null && lstPRMBOQ.Count > 0) { String fe_BOQDetail1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_BOQID, lstPRMBOQ[0].BOQID.ToString(), SQLMatchType.Equal); String fe_BOQDetail2 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal); String fe_BOQDetail = SqlExpressionBuilder.PrepareFilterExpression(fe_BOQDetail1, SQLJoinType.AND, fe_BOQDetail2); IList <PRMBOQDetailEntity> lstPRMBOQDetail = FCCPRMBOQDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_BOQDetail, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMBOQDetail != null && lstPRMBOQDetail.Count > 0) { String fe_floorDetail = SqlExpressionBuilder.PrepareFilterExpression("PRMBOQFloorDetail." + PRMBOQFloorDetailEntity.FLD_NAME_BOQDetailID, lstPRMBOQDetail[0].BOQDetailID.ToString(), SQLMatchType.Equal); IList <PRMBOQFloorDetail_DetailedEntity> lstPRMPreBOQFloorDetail = FCCPRMBOQFloorDetail_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe_floorDetail); lvREQRequisitionItemFloorDetail.DataSource = lstPRMPreBOQFloorDetail; lvREQRequisitionItemFloorDetail.DataBind(); } } #endregion break; case false: #region Get Item From Pre-BOQ String fe_preBOQDetail1 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal); String fe_preBOQDetail2 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal); String fe_preBOQDetail = SqlExpressionBuilder.PrepareFilterExpression(fe_preBOQDetail1, SQLJoinType.AND, fe_preBOQDetail2); IList <PRMPreBOQDetailEntity> lstPRMPreBOQDetail = FCCPRMPreBOQDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_preBOQDetail, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMPreBOQDetail != null && lstPRMPreBOQDetail.Count > 0) { String fe_floorDetail = SqlExpressionBuilder.PrepareFilterExpression("PRMPreBOQFloorDetail." + PRMPreBOQFloorDetailEntity.FLD_NAME_PreBOQDetailID, lstPRMPreBOQDetail[0].PreBOQDetailID.ToString(), SQLMatchType.Equal); IList <PRMPreBOQFloorDetail_DetailedEntity> lstPRMPreBOQFloorDetail = FCCPRMPreBOQFloorDetail_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_floorDetail); lvREQRequisitionItemFloorDetail.DataSource = lstPRMPreBOQFloorDetail; lvREQRequisitionItemFloorDetail.DataBind(); } #endregion break; default: break; } } } Label lblItemNameLV = (Label)e.Item.FindControl("lblItemNameLV"); //BindREQRequisitionFloorDetailList(); //lblFloorWiseItemName.Text = lblItemNameLV.Text.ToString(); this.ModalPopupExtender2.Show(); if (lvREQRequisitionItemFloorDetail.DataSource != null) { btnFloorPopupSave.Enabled = true; } else { btnFloorPopupSave.Enabled = false; } if (CurrentPRMWorkOrderEntity.WorkOrderStatusID != MasterDataConstants.WorkOrderStatus.APPROVED) { lblLockMessage.Visible = false; } else if (CurrentPRMWorkOrderEntity.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED) { btnFloorPopupSave.Enabled = false; lblLockMessage.Visible = true; } } if (MaterialReceiveItemMapID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _MaterialReceiveItemMapID = MaterialReceiveItemMapID; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_MaterialReceiveItemMapID, MaterialReceiveItemMapID.ToString(), SQLMatchType.Equal); PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMapEntity = new PRMMaterialReceiveItemMapEntity(); result = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Delete(pRMMaterialReceiveItemMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _MaterialReceiveItemMapID = 0; _PRMMaterialReceiveItemMapEntity = new PRMMaterialReceiveItemMapEntity(); PrepareInitialView(); BindPRMMaterialReceiveItemMapList(); MiscUtil.ShowMessage(lblMessage, "Material Receive Item Map has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Material Receive Item Map.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
protected void lvStudents_ItemCommand(object sender, ListViewCommandEventArgs e) { }
/// <summary> /// Toggle time series for water /// </summary> protected void OnItemCommandWATER(object sender, ListViewCommandEventArgs e) { onItemCommand(sender, e, MediumFilter.Medium.Water); }
protected void uoListViewVehicleHeader_ItemCommand(object sender, ListViewCommandEventArgs e) { uoHiddenFieldOrder.Value = e.CommandName; //BindVehicleManifestWithOrder(); //uoListviewVehicleInfoPager.SetPageProperties(0, uoListviewVehicleInfoPager.PageSize, false); }
protected void ManageOrg_ListView_OnItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "Update") { // Find Controls in ListView var txt_OrgName = (TextBox)e.Item.FindControl("txt_OrgName"); var txt_OrgAddress = (TextBox)e.Item.FindControl("txt_OrgAddress"); var txt_OrgCity = (TextBox)e.Item.FindControl("txt_OrgCity"); var txt_OrgState = (TextBox)e.Item.FindControl("txt_OrgState"); var txt_OrgZip = (TextBox)e.Item.FindControl("txt_OrgZip"); var txt_OrgPhone = (TextBox)e.Item.FindControl("txt_OrgPhone"); var txt_OrgPhone2 = (TextBox)e.Item.FindControl("txt_OrgPhone2"); var txt_OrgFax = (TextBox)e.Item.FindControl("txt_OrgFax"); var txt_OrgEmail = (TextBox)e.Item.FindControl("txt_OrgEmail"); var txt_OrgContact = (TextBox)e.Item.FindControl("txt_OrgContact"); var txt_OrgDescription = (TextBox)e.Item.FindControl("txt_OrgDescription"); var chk_toggleapproveConversation = (CheckBox)e.Item.FindControl("chk_toggleapproveConversation"); var chk_toggleapproveComment = (CheckBox)e.Item.FindControl("chk_toggleapproveComment"); var chk_toggleconversationEmail = (CheckBox)e.Item.FindControl("chk_toggleconversationEmail"); var chk_togglecommentEmail = (CheckBox)e.Item.FindControl("chk_togglecommentEmail"); var chk_toggleprofanityFilter = (CheckBox)e.Item.FindControl("chk_toggleprofanityFilter"); var chk_toggledisableOrg = (CheckBox)e.Item.FindControl("chk_toggledisableOrg"); // Set Update Parameters SqlDataSource_ManageOrg.UpdateParameters["OrgID"].DefaultValue = ddl_selectOrg.SelectedValue; SqlDataSource_ManageOrg.UpdateParameters["OrgName"].DefaultValue = txt_OrgName.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgAddress"].DefaultValue = txt_OrgAddress.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgCity"].DefaultValue = txt_OrgCity.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgState"].DefaultValue = txt_OrgState.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgZip"].DefaultValue = txt_OrgZip.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgPhone"].DefaultValue = txt_OrgPhone.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgPhone2"].DefaultValue = txt_OrgPhone2.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgFax"].DefaultValue = txt_OrgFax.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgEmail"].DefaultValue = txt_OrgEmail.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgContact"].DefaultValue = txt_OrgContact.Text; SqlDataSource_ManageOrg.UpdateParameters["OrgDescription"].DefaultValue = txt_OrgDescription.Text; if (chk_toggleapproveConversation.Checked) { SqlDataSource_ManageOrg.UpdateParameters["autoApproveConversation"].DefaultValue = "1"; } if (chk_toggleapproveComment.Checked) { SqlDataSource_ManageOrg.UpdateParameters["autoApproveComment"].DefaultValue = "1"; } if (chk_toggleconversationEmail.Checked) { SqlDataSource_ManageOrg.UpdateParameters["conversationEmail"].DefaultValue = "1"; } if (chk_togglecommentEmail.Checked) { SqlDataSource_ManageOrg.UpdateParameters["commentEmail"].DefaultValue = "1"; } if (chk_toggleprofanityFilter.Checked) { SqlDataSource_ManageOrg.UpdateParameters["profanityFilter"].DefaultValue = "1"; } if (chk_toggledisableOrg.Checked) { SqlDataSource_ManageOrg.UpdateParameters["OrgEnabled"].DefaultValue = "0"; } } }
protected void ListView1_ItemCommand(object sender, ListViewCommandEventArgs e) { if (String.Equals(e.CommandName, "LikeButton")) { //ListViewDataItem dataItem = (ListViewDataItem)e.Item; //Guid code = (Guid)ListView1.DataKeys[dataItem.DisplayIndex].Value; String like_Id = ListView1.DataKeys[e.Item.DataItemIndex].Values[1].ToString(); MembershipUser currentUser = Membership.GetUser(); Guid currentUserId = (Guid)currentUser.ProviderUserKey; String user_Id = currentUserId.ToString(); String post_userId = ListView1.DataKeys[e.Item.DataItemIndex].Values[2].ToString(); //if (String.Equals(lbtn.Text , "Like")) //{ ImageButton lb = e.Item.FindControl("LinkButtonLike") as ImageButton; LinkButton lbviewallcomment = e.Item.FindControl("LinkViewAllComment") as LinkButton; System.Data.SqlClient.SqlDataReader rdr = null; System.Data.SqlClient.SqlConnection conn = null; System.Data.SqlClient.SqlCommand sqlcmd = null; try { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [UserLikes]", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); //if (rdr.HasRows) //{ while (rdr.Read()) { String usrid = rdr["UserId"].ToString(); String lkid = rdr["LikeId"].ToString(); if (user_Id == usrid && like_Id == lkid) { string connectionString10 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; //string selectSql = "SELECT * FROM UserLikes WHERE UserId = @UserId"; string Sql = "delete from [UserLikes] WHERE LikeId=@LikeId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString10)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(Sql, myConnection); myCommand.Parameters.AddWithValue("@LikeId", new Guid(like_Id)); myCommand.Parameters.AddWithValue("@UserId", new Guid(user_Id)); myCommand.ExecuteNonQuery(); myConnection.Close(); } return; //rdr.NextResult(); } } string connectionString11 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql = "INSERT INTO UserLikes(LikeId,LikeUser,UserId) VALUES(@LikeId,@LikeUser,@UserId)"; using (SqlConnection myConnection = new SqlConnection(connectionString11)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@LikeId", like_Id); myCommand.Parameters.AddWithValue("@LikeUser", HttpContext.Current.Session["user"]); myCommand.Parameters.AddWithValue("@UserId", user_Id); myCommand.ExecuteNonQuery(); myConnection.Close(); } string connectionString5 = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [Notifications]", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); //if (rdr.HasRows) //{ while (rdr.Read()) { String usrid = rdr["UserId"].ToString(); String lkid = rdr["LikeId"].ToString(); String notify = rdr["NotifyTo"].ToString(); if (user_Id == usrid && like_Id == lkid && notify == post_userId) { return; } } if (user_Id != post_userId) { string connectionString12 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql2 = "INSERT INTO Notifications(UserId,LikeId,Type,NotifyTo,PostId) VALUES(@UserId,@LikeId,@Type,@NotifyTo,@PostId)"; using (SqlConnection myConnection = new SqlConnection(connectionString12)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql2, myConnection); myCommand.Parameters.AddWithValue("@LikeId", like_Id); myCommand.Parameters.AddWithValue("@Type", "Covert_Post_Like"); myCommand.Parameters.AddWithValue("@UserId", user_Id); myCommand.Parameters.AddWithValue("@NotifyTo", post_userId); ListView lstview = sender as ListView; Guid post__id = (Guid)lstview.DataKeys[e.Item.DataItemIndex].Values[0]; myCommand.Parameters.AddWithValue("@PostId", post__id); myCommand.ExecuteNonQuery(); myConnection.Close(); } } if (rdr != null) { rdr.Close(); } } catch (Exception ex) { } finally { if (conn != null) { conn.Close(); } this.DataBind(); } } if (String.Equals(e.CommandName, "Updatepost")) { Label lbl = ListView1.EditItem.FindControl("CovertIdLabel") as Label; if (lbl != null) { postId_edit = new Guid(lbl.Text); } TextBox txt = ListView1.EditItem.FindControl("CovertPostTextBox") as TextBox; String edit_text = txt.Text; string connectionString = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string updateSql = "UPDATE [CovertPosts] SET [CovertPost] = @CovertPost WHERE [CovertId] = @CovertId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(updateSql, myConnection); myCommand.Parameters.AddWithValue("@CovertPost", edit_text); myCommand.Parameters.AddWithValue("@CovertId", postId_edit); myCommand.Parameters.AddWithValue("@UserId", currentUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } ListView1.EditIndex = -1; //Button btnCancel = (ListView1.Items[e.Item.DataItemIndex].FindControl("CancelButton")) as Button; ListView1.DataBind(); } if (String.Equals(e.CommandName, "Deletepost")) { Guid post_Id = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[0]; string connectionString = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string Sql = "delete from [CovertPosts] WHERE [CovertId]=@CovertId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(Sql, myConnection); myCommand.Parameters.AddWithValue("@CovertId", post_Id); myCommand.Parameters.AddWithValue("@UserId", currentUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } //ListView2.DataBind(); //UpdatePanel1.Update(); } if (String.Equals(e.CommandName, "Bookmarkpost")) { Guid post_Id = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[0]; System.Data.SqlClient.SqlDataReader rdr = null; System.Data.SqlClient.SqlConnection conn = null; System.Data.SqlClient.SqlCommand sqlcmd = null; try { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [CovertBookmark]", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); //if (rdr.HasRows) //{ while (rdr.Read()) { String covertid = rdr["CovertId"].ToString(); String userid = rdr["UserId"].ToString(); if (covertid == post_Id.ToString() && userid == currentUserId.ToString()) { string connectionString10 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; //string selectSql = "SELECT * FROM UserLikes WHERE UserId = @UserId"; string Sql = "delete from [CovertBookmark] WHERE CovertId=@CovertId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString10)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(Sql, myConnection); myCommand.Parameters.AddWithValue("@CovertId", new Guid(covertid)); myCommand.Parameters.AddWithValue("@UserId", new Guid(userid)); myCommand.ExecuteNonQuery(); myConnection.Close(); } return; //rdr.NextResult(); } } string connectionString2 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string Sql2 = "INSERT INTO CovertBookmark(CovertId,UserId) VALUES(@CovertId,@UserId)"; using (SqlConnection myConnection = new SqlConnection(connectionString2)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(Sql2, myConnection); myCommand.Parameters.AddWithValue("@CovertId", post_Id); myCommand.Parameters.AddWithValue("@UserId", currentUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } if (rdr != null) { rdr.Close(); } } catch (Exception ex) { } finally { if (conn != null) { conn.Close(); } this.DataBind(); } //ListView2.DataBind(); //UpdatePanel1.Update(); } this.DataBind(); }
protected void ShoppingCartList_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "remove") { string username = User.Identity.Name; int itemid = int.Parse(e.CommandArgument.ToString()); int employeeid; if (ShoppingCartList.Items.Count == 0) { MessageUserControl.ShowInfo("Warning", "You have clear the shopping cart."); } else { MessageUserControl.TryRun(() => { ApplicationUserManager secmgr = new ApplicationUserManager(new UserStore <ApplicationUser>(new ApplicationDbContext())); EmployeeInfo info = secmgr.User_GetEmployee(username); employeeid = info.EmployeeID; ShoppingCartItemController sysmgr = new ShoppingCartItemController(); sysmgr.DeleteShoppingItems(employeeid, itemid); List <UserShoppingCartItem> infos = sysmgr.List_ItemsForShoppingCart(employeeid); ShoppingCartList.DataSource = infos; notificationIcon.Value = infos.Count.ToString(); ShoppingCartList.DataBind(); totalLabel.DataBind(); refresh_totallabel(); }, "Removed", $"Item(s) {itemid} have been removed"); } } else if (e.CommandName == "refresh") { string username = User.Identity.Name; int itemid = int.Parse(e.CommandArgument.ToString()); int employeeid; int quantity = int.Parse((e.Item.FindControl("QuantityLabel") as TextBox).Text); MessageUserControl.TryRun(() => { ApplicationUserManager secmgr = new ApplicationUserManager(new UserStore <ApplicationUser>(new ApplicationDbContext())); EmployeeInfo info = secmgr.User_GetEmployee(username); employeeid = info.EmployeeID; ShoppingCartItemController sysmgr = new ShoppingCartItemController(); sysmgr.Update_RefreshCart(employeeid, itemid, quantity); List <UserShoppingCartItem> infos = sysmgr.List_ItemsForShoppingCart(employeeid); ShoppingCartList.DataSource = infos; notificationIcon.Value = infos.Count.ToString(); ShoppingCartList.DataBind(); totalLabel.DataBind(); refresh_totallabel(); }, "Updated", $"Item(s) {itemid} have been updated"); } else { MessageUserControl.ShowInfo("Glad you found this error, cauz I don't even know what should I call this error."); } }
protected void ListView2_ItemCommand(object sender, ListViewCommandEventArgs e) { if (String.Equals(e.CommandName, "LikeButtonComment")) { //Button lbtn = e.Item.FindControl("LinkButtonLike") as Button; Label likeidlbl = e.Item.FindControl("LikeIdLabel") as Label; String like_Id = likeidlbl.Text; MembershipUser currentUser = Membership.GetUser(); Guid currentUserId = (Guid)currentUser.ProviderUserKey; String user_Id = currentUserId.ToString(); string post_userId = e.CommandArgument.ToString(); ImageButton lb = e.Item.FindControl("LinkButtonLike") as ImageButton; LinkButton lbviewallcomment = e.Item.FindControl("LinkViewAllComment") as LinkButton; System.Data.SqlClient.SqlDataReader rdr = null; System.Data.SqlClient.SqlConnection conn = null; System.Data.SqlClient.SqlCommand sqlcmd = null; try { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [UserLikes]", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); //if (rdr.HasRows) //{ while (rdr.Read()) { String usrid = rdr["UserId"].ToString(); String lkid = rdr["LikeId"].ToString(); if (user_Id == usrid && like_Id == lkid) { string connectionString10 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; //string selectSql = "SELECT * FROM UserLikes WHERE UserId = @UserId"; string Sql = "delete from [UserLikes] WHERE LikeId=@LikeId and UserId=@UserId"; using (SqlConnection myConnection = new SqlConnection(connectionString10)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(Sql, myConnection); myCommand.Parameters.AddWithValue("@LikeId", new Guid(like_Id)); myCommand.Parameters.AddWithValue("@UserId", new Guid(user_Id)); myCommand.ExecuteNonQuery(); myConnection.Close(); } return; //rdr.NextResult(); } } string connectionString11 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql = "INSERT INTO UserLikes(LikeId,LikeUser,UserId) VALUES(@LikeId,@LikeUser,@UserId)"; using (SqlConnection myConnection = new SqlConnection(connectionString11)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@LikeId", like_Id); myCommand.Parameters.AddWithValue("@LikeUser", HttpContext.Current.Session["user"]); myCommand.Parameters.AddWithValue("@UserId", user_Id); myCommand.ExecuteNonQuery(); myConnection.Close(); } string connectionString5 = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [Notifications]", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); //if (rdr.HasRows) //{ while (rdr.Read()) { String usrid = rdr["UserId"].ToString(); String lkid = rdr["LikeId"].ToString(); String notify = rdr["NotifyTo"].ToString(); if (user_Id == usrid && like_Id == lkid && notify == post_userId) { return; } } if (user_Id != post_userId) { string connectionString12 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql2 = "INSERT INTO Notifications(UserId,LikeId,Type,NotifyTo,PostId) VALUES(@UserId,@LikeId,@Type,@NotifyTo,@PostId)"; using (SqlConnection myConnection = new SqlConnection(connectionString12)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql2, myConnection); myCommand.Parameters.AddWithValue("@LikeId", like_Id); myCommand.Parameters.AddWithValue("@Type", "Covert_Comment_Like"); myCommand.Parameters.AddWithValue("@UserId", user_Id); myCommand.Parameters.AddWithValue("@NotifyTo", post_userId); ListView lstview = sender as ListView; Guid post__id = (Guid)ListView1.DataKeys[e.Item.DataItemIndex].Values[0]; myCommand.Parameters.AddWithValue("@PostId", post__id); myCommand.ExecuteNonQuery(); myConnection.Close(); } } if (rdr != null) { rdr.Close(); } } catch (Exception ex) { } finally { if (conn != null) { conn.Close(); } this.DataBind(); } } }
protected virtual void OnItemCommand(ListViewCommandEventArgs e) { ListViewCommandEventHandler handler = (ListViewCommandEventHandler)Events[EventItemCommand]; if (handler != null) { handler(this, null); } }
protected void lvACCPrePayableStatementDetail_ItemCommand(object sender, ListViewCommandEventArgs e) { }