private void Update_Album_Save(tbl_Album_Save objAlbumSave, SqlTransaction trans, SqlConnection cn)
{
string strQuer = "";
strQuer = "set dateformat dmy; update tbl_Album_Save set [Album_Name]='" + objAlbumSave.Album_Name + "',[Album_Description]='" + objAlbumSave.Album_Description + "',[Album_Rating]='" + objAlbumSave.Album_Rating + "',[Album_Mounting_Rating]='" + objAlbumSave.Album_Mounting_Rating + "',[Album_Studio_Id]='" + objAlbumSave.Album_Studio_Id + "',[Album_Category]='" + objAlbumSave.Album_Category + "',[Album_AddedBy]='" + objAlbumSave.Album_AddedBy + "',[Album_AddedOn]=getdate(), [Album_ModifiedOn]='" + objAlbumSave.Album_ModifiedOn + "',[Album_Status]='" + objAlbumSave.Album_Status + "' where [Album_Id]='" + objAlbumSave.Album_Id + "' ";
if (trans == null)
{
try
{
ExecuteSelectQuery(strQuer);
}
catch (Exception ee)
{
}
}
else
{
ExecuteSelectQuerywithTransaction(cn, strQuer, trans);
}
}
public bool Insert_Album(tbl_Album_Save objAlbumSave, List <tbl_Album_Staff> obj_tbl_Album_Staff_Li, List <tbl_Album_Genere> obj_tbl_Album_Genere_Li, List <tbl_Upload_Banner> obj_tbl_Upload_BannerLi)
{
bool flag = false;
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(ConStr))
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction trans = cn.BeginTransaction();
try
{
if (objAlbumSave.Album_Id > 0)
{
Update_Album_Save(objAlbumSave, trans, cn);
}
else
{
objAlbumSave.Album_Id = Insert_Album_Save(objAlbumSave, trans, cn);
}
Update_Staff_Album_Save(objAlbumSave.Album_Id, objAlbumSave.Album_AddedBy, trans, cn);
for (int i = 0; i < obj_tbl_Album_Staff_Li.Count; i++)
{
obj_tbl_Album_Staff_Li[i].AlbumStaff_Album_Id = objAlbumSave.Album_Id;
Insert_Staff_Album_Save(obj_tbl_Album_Staff_Li[i], trans, cn);
}
Update_Album_Genere_save(objAlbumSave.Album_Id, objAlbumSave.Album_AddedBy, trans, cn);
for (int i = 0; i < obj_tbl_Album_Genere_Li.Count; i++)
{
obj_tbl_Album_Genere_Li[i].AlbumGenere_Album_Id = objAlbumSave.Album_Id;
Insert_Album_Genere_save(obj_tbl_Album_Genere_Li[i], trans, cn);
}
if (!Directory.Exists(Server.MapPath(".") + "\\Downloads\\" + objAlbumSave.Album_Id.ToString()))
{
Directory.CreateDirectory(Server.MapPath(".") + "\\Downloads\\" + objAlbumSave.Album_Id.ToString());
}
for (int i = 0; i < obj_tbl_Upload_BannerLi.Count; i++)
{
obj_tbl_Upload_BannerLi[i].AlbumUpload_Album_Id = objAlbumSave.Album_Id;
if (obj_tbl_Upload_BannerLi[i].AlbumUpload_File_Bytes != null && obj_tbl_Upload_BannerLi[i].AlbumUpload_File_Bytes.Length > 0)
{
File.WriteAllBytes(Server.MapPath(".") + "\\Downloads\\" + objAlbumSave.Album_Id.ToString() + "\\" + obj_tbl_Upload_BannerLi[i].AlbumUpload_Path, obj_tbl_Upload_BannerLi[i].AlbumUpload_File_Bytes);
obj_tbl_Upload_BannerLi[i].AlbumUpload_Path = "\\Downloads\\" + objAlbumSave.Album_Id.ToString() + "\\" + obj_tbl_Upload_BannerLi[i].AlbumUpload_Path;
Insert_Upload_Banner(obj_tbl_Upload_BannerLi[i], trans, cn);
}
}
trans.Commit();
cn.Close();
flag = true;
}
catch (Exception e)
{
trans.Rollback();
cn.Close();
flag = false;
}
}
return(flag);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtAlbumName.Text.Trim() == "")
{
txtAlbumName.Focus();
return;
}
if (txtDescription.Text.Trim() == "")
{
txtDescription.Focus();
return;
}
if (ddlMountingRating.Text.Trim() == "")
{
ddlMountingRating.Focus();
}
if (ddlStudio.SelectedValue == "0")
{
ddlStudio.Focus();
return;
}
if (ddlCategory.SelectedValue == "0")
{
ddlCategory.Focus();
return;
}
tbl_Album_Save objAlbumSave = new tbl_Album_Save();
try
{
objAlbumSave.Album_Id = Convert.ToInt32(hf_AlbumId.Value);
}
catch
{
objAlbumSave.Album_Id = 0;
}
List <tbl_Upload_Banner> obj_tbl_Upload_BannerLi = new List <tbl_Upload_Banner>();
Dictionary <string, byte[]> file_Upload_Array_Banner = new Dictionary <string, byte[]>();
if (Session["FileUpload1"] != null)
{
file_Upload_Array_Banner = (Dictionary <string, byte[]>)Session["FileUpload1"];
foreach (KeyValuePair <string, byte[]> item in file_Upload_Array_Banner)
{
if (item.Value != null)
{
tbl_Upload_Banner obj_tbl_Upload_Banner = new tbl_Upload_Banner();
obj_tbl_Upload_Banner.AlbumUpload_Status = 1;
obj_tbl_Upload_Banner.AlbumUpload_Type = "B";
obj_tbl_Upload_Banner.AlbumUpload_File_Bytes = item.Value;
obj_tbl_Upload_Banner.AlbumUpload_Path = item.Key;
obj_tbl_Upload_BannerLi.Add(obj_tbl_Upload_Banner);
}
}
}
else
{
file_Upload_Array_Banner = null;
}
Dictionary <string, byte[]> file_Upload_Array_Video = new Dictionary <string, byte[]>();
if (Session["FileUpload2"] != null)
{
file_Upload_Array_Video = (Dictionary <string, byte[]>)Session["FileUpload2"];
foreach (KeyValuePair <string, byte[]> item in file_Upload_Array_Video)
{
if (item.Value != null)
{
tbl_Upload_Banner obj_tbl_Upload_Banner = new tbl_Upload_Banner();
obj_tbl_Upload_Banner.AlbumUpload_Status = 1;
obj_tbl_Upload_Banner.AlbumUpload_Type = "V";
obj_tbl_Upload_Banner.AlbumUpload_File_Bytes = item.Value;
obj_tbl_Upload_Banner.AlbumUpload_Path = item.Key;
obj_tbl_Upload_BannerLi.Add(obj_tbl_Upload_Banner);
}
}
}
else
{
file_Upload_Array_Video = null;
}
if (file_Upload_Array_Banner == null || file_Upload_Array_Banner.Count == 0)
{
MessageBox.Show("Please Upload Album Banner.");
return;
}
if (file_Upload_Array_Video == null || file_Upload_Array_Video.Count == 0)
{
MessageBox.Show("Please Upload Trailer Video.");
return;
}
objAlbumSave.Album_Name = txtAlbumName.Text.Trim();
objAlbumSave.Album_Description = txtDescription.Text.Trim();
objAlbumSave.Album_Rating = Rating1.CurrentRating;
objAlbumSave.Album_Mounting_Rating = ddlMountingRating.Text.Trim();
objAlbumSave.Album_Studio_Id = Convert.ToInt32(ddlStudio.SelectedValue);
objAlbumSave.Album_Category = Convert.ToInt32(ddlCategory.SelectedValue);
objAlbumSave.Album_AddedBy = Convert.ToInt32(Session["Person_Id"].ToString());
objAlbumSave.Album_Status = 1;
List <tbl_Album_Staff> obj_tbl_Album_Staff_Li = new List <tbl_Album_Staff>();
for (int i = 0; i < lbStarring.Items.Count; i++)
{
if (lbStarring.Items[i].Selected)
{
tbl_Album_Staff obj_tbl_Album_Staff = new tbl_Album_Staff();
obj_tbl_Album_Staff.AlbumStaff_AddedBy = Convert.ToInt32(Session["Person_Id"].ToString());
obj_tbl_Album_Staff.AlbumStaff_Starring_id = Convert.ToInt32(lbStarring.Items[i].Value);
obj_tbl_Album_Staff.AlbumStaff_Status = 1;
obj_tbl_Album_Staff_Li.Add(obj_tbl_Album_Staff);
}
}
for (int i = 0; i < lbDirector.Items.Count; i++)
{
if (lbDirector.Items[i].Selected)
{
tbl_Album_Staff obj_tbl_Album_Staff = new tbl_Album_Staff();
obj_tbl_Album_Staff.AlbumStaff_AddedBy = Convert.ToInt32(Session["Person_Id"].ToString());
obj_tbl_Album_Staff.AlbumStaff_Starring_id = Convert.ToInt32(lbDirector.Items[i].Value);
obj_tbl_Album_Staff.AlbumStaff_Status = 1;
obj_tbl_Album_Staff_Li.Add(obj_tbl_Album_Staff);
}
}
for (int i = 0; i < lbSupportingActor.Items.Count; i++)
{
if (lbSupportingActor.Items[i].Selected)
{
tbl_Album_Staff obj_tbl_Album_Staff = new tbl_Album_Staff();
obj_tbl_Album_Staff.AlbumStaff_AddedBy = Convert.ToInt32(Session["Person_Id"].ToString());
obj_tbl_Album_Staff.AlbumStaff_Starring_id = Convert.ToInt32(lbSupportingActor.Items[i].Value);
obj_tbl_Album_Staff.AlbumStaff_Status = 1;
obj_tbl_Album_Staff_Li.Add(obj_tbl_Album_Staff);
}
}
List <tbl_Album_Genere> obj_tbl_Album_Genere_Li = new List <tbl_Album_Genere>();
for (int i = 0; i < lbGenere.Items.Count; i++)
{
if (lbGenere.Items[i].Selected)
{
tbl_Album_Genere obj_tbl_Album_Genere = new tbl_Album_Genere();
obj_tbl_Album_Genere.AlbumGenere_AddedBy = Convert.ToInt32(Session["Person_Id"].ToString());
obj_tbl_Album_Genere.AlbumGenere_Genere_id = Convert.ToInt32(lbGenere.Items[i].Value);
obj_tbl_Album_Genere.AlbumGenere_Status = 1;
obj_tbl_Album_Genere_Li.Add(obj_tbl_Album_Genere);
}
}
if (new DataLayer().Insert_Album(objAlbumSave, obj_tbl_Album_Staff_Li, obj_tbl_Album_Genere_Li, obj_tbl_Upload_BannerLi))
{
MessageBox.Show("Created Successfully");
reset();
}
else
{
MessageBox.Show("Error");
}
}
