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