public List <SubSlider> ListWithSortOrder(int SortOrder) { if (!this.dt.OpenConnection()) { return(null); } string sqlquery = "select * from SubSlider where SortOrder=@SortOrder"; SqlParameter pSortOrder = new SqlParameter("@SortOrder", SortOrder); DataTable tb = dt.DATable(sqlquery, pSortOrder); List <SubSlider> lst = new List <SubSlider>(); foreach (DataRow r in tb.Rows) { SubSlider sb = new SubSlider(); sb.ID = (int)r["ID"]; sb.Title = (string.IsNullOrEmpty(r["Title"].ToString())) ? "" : (string)r["Title"]; sb.Descriptions = (string.IsNullOrEmpty(r["Descriptions"].ToString())) ? "" : (string)r["Descriptions"]; sb.SliderImg = (string.IsNullOrEmpty(r["SliderImg"].ToString())) ? 0 : (int)r["SliderImg"]; sb.SliderStatus = (string.IsNullOrEmpty(r["SliderStatus"].ToString())) ? false : (Boolean)r["SliderStatus"]; sb.SortOrder = (string.IsNullOrEmpty(r["SortOrder"].ToString())) ? 0 : (int)r["SortOrder"]; sb.CreateBy = (string.IsNullOrEmpty(r["CreateBy"].ToString())) ? 0 : (int)r["CreateBy"]; sb.CreateDate = (DateTime)r["CreateDate"]; sb.RedirectLink = (string.IsNullOrEmpty(r["RedirectLink"].ToString())) ? "" : (string)r["RedirectLink"]; lst.Add(sb); } this.dt.CloseConnection(); return(lst); }
protected void lkbtnDown_Click(object sender, EventArgs e) { try { subslider = new SubSliderBLL(); LinkButton lkbutton = (sender as LinkButton); //Get the command argument string commandArgument = lkbutton.CommandArgument; int id = int.Parse(commandArgument); Number a, b; Number A, B; List <SubSlider> lst = subslider.ListWithID(id); SubSlider sub = lst.FirstOrDefault(); List <SubSlider> lstUP = subslider.ListWithSortOrder(subslider.MinItemindexLK(sub.SortOrder)); //index B SubSlider sub_Up = lstUP.FirstOrDefault(); if (sub_Up == null) { a = new Number(0); b = new Number(0); return; } else { A = new Number(sub.ID); B = new Number(sub_Up.ID); a = new Number(sub.SortOrder); b = new Number(sub_Up.SortOrder); this.swap(a, b); this.subslider.UpdateSortOrder(a.getNum(), A.getNum()); this.subslider.UpdateSortOrder(b.getNum(), B.getNum()); this.GetSubSliderPageWise(1); gwSubSlider.SelectedIndex = -1; } } catch (Exception ex) { this.AlertPageValid(true, ex.ToString(), alertPageValid, lblPageValid); } }
protected void btnSevaEdit_Click(object sender, EventArgs e) { try { subslider = new SubSliderBLL(); int ID = Convert.ToInt32((gwSubSlider.SelectedRow.FindControl("lblID") as Label).Text); SubSlider sub = subslider.ListWithID(ID).FirstOrDefault(); if (subslider.UpdateSubSlider(ID, txtETitle.Text, txtEDescription.Text, (UploadImg(UploadEditImage) == 0) ? sub.SliderImg : UploadImg(UploadEditImage), chkEditStatus.Checked, txtERedirectLink.Text)) { this.GetSubSliderPageWise(1); } else { this.AlertPageValid(true, "False to connect server !", alertPageValid, lblPageValid); } } catch (Exception ex) { this.AlertPageValid(true, ex.ToString(), alertPageValid, lblPageValid); } }
protected void gwSubSlider_SelectedIndexChanged(object sender, EventArgs e) { try { subslider = new SubSliderBLL(); images = new ImagesBLL(); btnfixSubSlider.Attributes.Add("class", "btn btn-default"); btnselectImg.Attributes.Add("class", "btn btn-default"); int ID = Convert.ToInt32((gwSubSlider.SelectedRow.FindControl("lblID") as Label).Text); SubSlider sub = subslider.ListWithID(ID).FirstOrDefault(); txtETitle.Text = sub.Title; txtEDescription.Text = sub.Descriptions; txtERedirectLink.Text = sub.RedirectLink; Images img = images.ListWithID(sub.SliderImg).FirstOrDefault(); ImgEditImages.ImageUrl = (img == null) ? "#" : "../../" + img.ImagesUrl; chkEditStatus.Checked = sub.SliderStatus; UploadEditImage.ToolTip = (img == null) ? "" : img.ImagesName; } catch (Exception ex) { this.AlertPageValid(true, ex.ToString(), alertPageValid, lblPageValid); } }