private int AddData()
{
string user_id = Session["UserId"].ToString();
string playlist_name = txtPlayListName.Text;
string description = txtDescription.Text;
string status = rdlStatus.SelectedValue;
int typeid = Convert.ToInt32(ddlMediaTypeList.SelectedValue);
/*** UPLOAD ************************************************************************************************************/
string[] FileImg = new String[2];
string front_image = string.Empty; string main_image = string.Empty;
string front_path = Server.MapPath(upload_front_image_dir);
string main_path = Server.MapPath(upload_main_image_dir);
if (FileUpload1.HasFile)
{
FileHandleClass file_bj = new FileHandleClass();
FileImg = file_bj.upload_front_main_image(FileUpload1, front_path, main_path, 120, 120);
main_image = FileImg[0];
front_image = FileImg[1];
//System.Drawing.Image img1 = System.Drawing.Image.FromFile(front_path+ "/" + front_image);
imgPhoto.ImageUrl = upload_front_image_dir + "/" + front_image;
}
////========================================================================================================================
MediaPlayLists artist_obj = new MediaPlayLists();
int i = artist_obj.Insert(user_id, typeid, playlist_name, front_image, main_image, description, status);
return(i);
}
protected void Page_Load(object sender, EventArgs e)
{
MediaPlayLists dal = new MediaPlayLists(StoredData);
if (!Page.IsPostBack)
{
LoadStatus2DDL();
PageAndBind(GridView1);
}
}
protected void PopulateMediaPlayList2DDL(string selected_value)
{
MediaPlayLists media_playlist_obj = new MediaPlayLists();
List <Media_PlayLists> lst = media_playlist_obj.GetListByStatus("1");
ddlPlayList.Items.Clear();
ddlPlayList.DataSource = lst;
ddlPlayList.DataTextField = "PlayListName";
ddlPlayList.DataValueField = "PlayListId";
ddlPlayList.DataBind();
ddlPlayList.SelectedValue = selected_value;
ddlPlayList.AutoPostBack = true;
}
private int UpdateData()
{
string user_id = Session["UserId"].ToString();
string playlist_name = txtPlayListName.Text;
string description = txtDescription.Text;
string status = rdlStatus.SelectedValue;
int typeid = Convert.ToInt32(ddlMediaTypeList.SelectedValue);
/*** UPLOAD ************************************************************************************************************/
string[] FileImg = new String[2];
string front_image = string.Empty; string main_image = string.Empty;
string front_path = Server.MapPath(upload_front_image_dir);
string main_path = Server.MapPath(upload_main_image_dir);
string Orginal_front_image = ViewState["FrontImage"].ToString();
string Orginal_main_image = ViewState["MainImage"].ToString();
//if (FileUpload1.HasFile)
if (Session["FileUpload1"] != null && Session["FileUpload1"].ToString() != string.Empty)
{
FileHandleClass file_obj = new FileHandleClass();
FileImg = file_obj.upload_front_main_image(FileUpload1, front_path, main_path, 120, 120);
main_image = FileImg[0];
front_image = FileImg[1];
//System.Drawing.Image img1 = System.Drawing.Image.FromFile(front_path+ "/" + front_image);
imgPhoto.ImageUrl = upload_front_image_dir + "/" + front_image;
string folderchild = Orginal_front_image.Substring(0, 10);
file_obj.DeleteFile(Orginal_front_image, upload_front_image_dir);
file_obj.DeleteFile(Orginal_main_image, upload_main_image_dir);
}
else
{
front_image = Orginal_front_image;
main_image = Orginal_main_image;
}
////========================================================================================================================
MediaPlayLists artist_obj = new MediaPlayLists();
int i = artist_obj.Update(_idx, typeid, user_id, playlist_name, front_image, main_image, description, status);
return(i);
}
private void PageAndBind(GridView gv)
{
IList <Object> list = new List <Object>();
int pageSize = 2;
int startRow = (gv.PageIndex * pageSize);
string status = ddlStatus.SelectedValue;
MediaPlayLists playList_obj = new MediaPlayLists();
IList <Media_PlayLists> data =
playList_obj.LoadDatedItemsByPage(status, startRow, pageSize, GridViewSortBy, GridViewSortAscending);
//copy data into generic list
foreach (Media_PlayLists item in data)
{
list.Add(item);
}
int count = playList_obj.LoadDatedItemsCount(); //you could cache this
//here's the bit where we use create an ODS in code to fill the gridview with paged data
CommonLibrary.UI.GridView.GridViewFiller.Fill(gv, list, count, pageSize);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridView gv = (GridView)sender;
//to get index and row
int rowIndex = e.RowIndex; //here we have the row directly
//GridViewRow row = gv.Rows[rowIndex]; //the row
int key = (int)gv.DataKeys[rowIndex][0]; //int key = Convert.ToInt32(gv.DataKeys[e.RowIndex].Values[0].ToString());
//int key = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
string UserId = Session["UserId"].ToString();
string Status = "1";
MediaPlayLists playList_obj = new MediaPlayLists();
playList_obj.UpdateStatus(UserId, key, Status);
//playList_obj.Delete(key);
if (rowIndex == 0 && gv.Rows.Count == 1)
{
gv.PageIndex = gv.PageIndex - 1; //only 1 item on page- page back
}
PageAndBind(gv); //load the new information
}
private void LoadData()
{
MediaPlayLists artist_obj = new MediaPlayLists();
Media_PlayLists entity = artist_obj.GetDetails(_idx);
string FrontImage = entity.FrontImage;
string MainImage = entity.MainImage;
imgPhoto.ImageUrl = upload_front_image_dir + "/" + FrontImage;
ViewState["FrontImage"] = FrontImage;
ViewState["MainImage"] = MainImage;
txtPlayListName.Text = entity.PlayListName;
txtDescription.Text = entity.Description;
string Status = entity.Status;
PopulateStatus2DDL(Status);
string TypeId = ddlMediaTypeList.SelectedValue;
PopulateMediaTypeList2DDL(TypeId);
}
