protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = null;
SqlDataReader reader = null;
conn = new
SqlConnection(Reference.Constr);
conn.Open();
if (!IsPostBack)
{
SqlCommand cmd0 = new SqlCommand("select c.Name from [Advertisement] as a inner join [Company] as c on a.companyID=c.CompanyID where a.AdvID=@ID");
SqlParameter param0 = new SqlParameter();
param0.ParameterName = "@ID";
param0.Value = Session["AdvertID"].ToString();
cmd0.Parameters.Add(param0);
SqlDataAdapter sda0 = new SqlDataAdapter();
DataTable dt0 = new DataTable();
cmd0.Connection = conn;
sda0.SelectCommand = cmd0;
sda0.Fill(dt0);
cmd0.Parameters.Clear();
for (int i = 0; i < dt0.Rows.Count; i++)
{
string companynameChecker = dt0.Rows[i]["Name"].ToString();
CompanyNameLiteral.Text = companynameChecker;
}
Advertisement AdvertObj = new Advertisement();
Advertisement_Management aDao = new Advertisement_Management();
AdvertObj = aDao.getAdvByID(Session["AdvertID"].ToString());
string previousimagepath = AdvertObj.Item.ToString();
if (AdvertObj.ItemType == "image")
{
imgLogo.ImageUrl = ResolveUrl(previousimagepath);
imgLogo.Visible = true;
videoThumbnail.Visible = false;
}
if (AdvertObj.ItemType == "video")
{
videoThumbnail.Src = ResolveUrl(previousimagepath);
videoThumbnail.Visible = true;
imgLogo.Visible = false;
}
//headerName.InnerText = AdvertObj.Name.ToString();
AdNameLabel.Text = "for " + AdvertObj.Name.ToString();
AdNameLiteral.Text = AdvertObj.Name.ToString();
ItemTypeLiteral.Text = AdvertObj.ItemType.ToString();
DateTime StartDateVar = Convert.ToDateTime(AdvertObj.StartDate);
DateTime EndDateVar = Convert.ToDateTime(AdvertObj.EndDate);
string niceStartDate = StartDateVar.ToString("dddd, dd MMMM yyyy");
string niceEndDate = EndDateVar.ToString("dddd, dd MMMM yyyy");
StartDateLiteral.Text = niceStartDate;
EndDateLiteral.Text = niceEndDate;
SqlCommand cmd1 = new SqlCommand("select a.AdvID,a.AgeID,a.GenderID,coderefage.CodeDesc as agedesc,coderefgender.CodeDesc as genderdesc from AdvertisementAudience " +
" a full outer join CodeReferece as coderefage on coderefage.CodeValue = a.AgeID full outer join CodeReferece as coderefgender on coderefgender.CodeValue = a.GenderID where" +
" a.advid =@ID and coderefage.CodeType = 'AgeID' and coderefgender.CodeType = 'GenderID' ", conn);
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "@ID";
param1.Value = Session["AdvertID"].ToString();
cmd1.Parameters.Add(param1);
SqlDataAdapter sda1 = new SqlDataAdapter();
DataTable dt1 = new DataTable();
cmd1.Connection = conn;
sda1.SelectCommand = cmd1;
sda1.Fill(dt1);
cmd1.Parameters.Clear();
for (int i = 0; i < dt1.Rows.Count; i++)
{
string ageDesc = dt1.Rows[i]["agedesc"].ToString();
string genderDesc = dt1.Rows[i]["genderdesc"].ToString();
HtmlGenericControl li = new HtmlGenericControl("li");
//tabs.Controls.Add(li);
AudienceList.Controls.Add(li);
HtmlGenericControl anchor = new HtmlGenericControl();
anchor.Attributes.Add("href", "page.htm");
anchor.InnerText = "" + ageDesc + " (" + genderDesc + ")";
li.Controls.Add(anchor);
}
SqlCommand cmdCat = new SqlCommand("SELECT a.[AdvID], a.[Name], a.[Item], b.CategoryID, c.CodeDesc FROM [Advertisement] a INNER JOIN [AdvertisementCategory]" +
" b ON a.AdvID = b.AdvID FULL OUTER JOIN [CodeReferece] c ON b.CategoryID = c.CodeValue WHERE a.AdvID = @ID and c.CodeType='Category' ", conn);
SqlParameter paramCat = new SqlParameter();
paramCat.ParameterName = "@ID";
paramCat.Value = Session["AdvertID"].ToString();
cmdCat.Parameters.Add(paramCat);
SqlDataAdapter sdaCat = new SqlDataAdapter();
DataTable dtCat = new DataTable();
cmdCat.Connection = conn;
sdaCat.SelectCommand = cmdCat;
sdaCat.Fill(dtCat);
cmdCat.Parameters.Clear();
for (int i = 0; i < dtCat.Rows.Count; i++)
{
string codedesc = dtCat.Rows[i]["CodeDesc"].ToString();
HtmlGenericControl li = new HtmlGenericControl("li");
//tabs.Controls.Add(li);
//AudienceList.Controls.Add(li);
CategoryList.Controls.Add(li);
HtmlGenericControl anchor = new HtmlGenericControl();
anchor.Attributes.Add("href", "page.htm");
anchor.InnerText = "" + codedesc;
li.Controls.Add(anchor);
}
SqlCommand cmd3 = new SqlCommand("select b.BillboardCode from [AdvertisementLocation] as a inner join [BillboardLocation] as b on a.BillboardID=b.BillboardID where AdvID=@ID", conn);
SqlParameter param3 = new SqlParameter();
param3.ParameterName = "@ID";
param3.Value = Session["AdvertID"].ToString();
cmd3.Parameters.Add(param3);
SqlDataAdapter sda3 = new SqlDataAdapter();
DataTable dt3 = new DataTable();
cmd3.Connection = conn;
sda3.SelectCommand = cmd3;
sda3.Fill(dt3);
cmd3.Parameters.Clear();
for (int i = 0; i < dt3.Rows.Count; i++)
{
string BillboardCode = ((String)dt3.Rows[i]["BillboardCode"]);
HtmlGenericControl li = new HtmlGenericControl("li");
//tabs.Controls.Add(li);
//AudienceList.Controls.Add(li);
BBCodeList.Controls.Add(li);
HtmlGenericControl anchor = new HtmlGenericControl();
anchor.Attributes.Add("href", "page.htm");
anchor.InnerText = "" + BillboardCode;
li.Controls.Add(anchor);
}
}
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
SqlConnection conn = null;
SqlDataReader reader = null;
// instantiate and open connection
conn = new
SqlConnection(Reference.Constr);
conn.Open();
if (e.CommandName == "DeleteAdMessage")
{
int index = Convert.ToInt32(e.CommandArgument);
// Retrieve the row that contains the button
// from the Rows collection.
GridViewRow row = GridView1.Rows[index];
LinkButton btnButton1 = sender as LinkButton;
GridViewRow gvRow1 = (GridViewRow)btnButton1.NamingContainer;
Advertisement aObj = new Advertisement();
Advertisement_Management aDao = new Advertisement_Management();
Label lb_msgId = (Label)gvRow1.FindControl("lb_AdvertID");
aObj = aDao.getAdvByID(lb_msgId.Text);
// bObj = bDao.getBillboardByID(lb_msgId.Text);
// string BBCode = bObj.BillboardCode;
//Boolean insCnt = bDao.deleteBillboard(lb_msgId.Text);
Boolean DeleteAd = aDao.deleteAdvert(lb_msgId.Text);
//VIC: never inform if the delete is successful or not?
alertSuccessDelete.Visible = true;
alertSuccessCreate.Visible = false;
alertSuccessUpdate.Visible = false;
Label3.Text = " Advert '" + aObj.Name + "' Has Been Deleted Successfully!";
//" SELECT [Advertisement].AdvID,[Company].Name as CompanyName, [Advertisement].Name as AdvertName, [Advertisement].Item, [Advertisement].ItemType,[StartDate], [EndDate]FROM " +
// "[Advertisement] inner join [Company] on Company.CompanyID =[Advertisement].CompanyID where [Advertisement].status = 1 and[Company].status = 1", conn);
Database db = new Database();
if (Session["userType"].ToString() == Reference.USR_ADM)
{
SqlCommand cmd = new SqlCommand("SELECT [Advertisement].AdvID,[Company].Name as CompanyName, [Advertisement].Name as AdvertName, [Advertisement].Item, [Advertisement].ItemType,[StartDate], [EndDate]FROM " +
"[Advertisement] inner join [Company] on Company.CompanyID =[Advertisement].CompanyID where [Advertisement].status = 1 and[Company].status = 1", conn);
SqlDataAdapter sda = new SqlDataAdapter();
DataTable dt = new DataTable();
sda.SelectCommand = cmd;
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
User uObj = new User();
UserManagement uDao = new UserManagement();
uObj = uDao.getUserByID(Session["userID"].ToString());
SqlCommand cmd = new SqlCommand("SELECT [Advertisement].AdvID,[Company].Name as CompanyName, [Advertisement].Name as AdvertName, [Advertisement].Item, [Advertisement].ItemType,[StartDate], [EndDate]FROM " +
"[Advertisement] inner join [Company] on Company.CompanyID =[Advertisement].CompanyID where [Advertisement].status = 1 and[Company].status = 1 and [Advertisement].CompanyID=@comID", conn);
SqlParameter param = new SqlParameter();
param.ParameterName = "@comID";
param.Value = uObj.CompanyID.ToString();
cmd.Parameters.Add(param);
SqlDataAdapter sda = new SqlDataAdapter();
DataTable dt = new DataTable();
sda.SelectCommand = cmd;
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//login_div.Attributes.Add("style","display:none");
Advertisement adObject = new Advertisement();
Advertisement_Management adObjectClass = new Advertisement_Management();
adObject = adObjectClass.getAdvByID(Session["AdvertID"].ToString());
string previousimagepath = adObject.Item.ToString();
if (adObject.ItemType == "image")
{
imgLogo.Attributes.Add("style", "display:block");
videoDog.Attributes.Add("style", "display:none");
imgLogo.Visible = true;
videoDog.Visible = false;
imgLogo.ImageUrl = ResolveUrl(previousimagepath);
}
if (adObject.ItemType == "video")
{
imgLogo.Attributes.Add("style", "display:none");
videoDog.Attributes.Add("style", "display:block");
videoDog.Visible = true;
imgLogo.Visible = false;
videoDog.Src = ResolveUrl(previousimagepath);
}
SqlConnection conn = null;
SqlDataReader reader = null;
conn = new
SqlConnection(Reference.Constr);
conn.Open();
if ((string)Session["userType"] == Reference.USR_ADM)
{
divCompany.Visible = true;
DropDownListCompany.Visible = true;
// int companyID = Convert.ToInt32(DropDownListCompany.SelectedItem.Value);
}
else
{
// User userObj = new User();
// UserManagement uDao = new UserManagement();
divCompany.Visible = false;
DropDownListCompany.Visible = false;
// userObj = uDao.getUserByID(Session["userID"].ToString());
// int companyID = userObj.CompanyID;
}
if (FileUpload1.HasFile)
{
Literal1.Text = Convert.ToString(FileUpload1.PostedFile.FileName);
if (Literal1.Text.EndsWith(".png") || Literal1.Text.EndsWith(".jpg") || Literal1.Text.EndsWith(".jpeg") || Literal1.Text.EndsWith(".gif") || Literal1.Text.EndsWith(".PNG") || Literal1.Text.EndsWith(".JPG") || Literal1.Text.EndsWith(".JPEG") || Literal1.Text.EndsWith(".GIF"))
{
Literal2.Text = "image";
}
else
{
Literal2.Text = "video";
}
}
if (!Page.IsPostBack)
{
//SqlCommand cmdBB = new SqlCommand("SELECT BillboardID,BillboardCode, Latitude ,Longtitude ,(( AddressLn1)" +
// " + ' '+( AddressLn2 )+ ' '+(City)+ ', '+(Country)+ ' '+(postalCode)) AS Address FROM BillboardLocation where status=1", conn);
//SqlDataAdapter sdaBB = new SqlDataAdapter();
//DataTable dtBB = new DataTable();
//cmdBB.Connection = conn;
//sdaBB.SelectCommand = cmdBB;
//sdaBB.Fill(dtBB);
//GridView1.DataSource = dtBB;
//GridView1.DataBind();
Database db = new Database();
string mainconn = ConfigurationManager.ConnectionStrings["Targeted_Marketing_DisplayConnectionString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(Reference.Constr);
string sqlquery = "SELECT * FROM [CodeReferece] WHERE ([CodeType] = @CodeType)";
SqlCommand cmdCodeRef = new SqlCommand(sqlquery, sqlconn);
cmdCodeRef.Parameters.AddWithValue("@CodeType", "Category");
SqlDataAdapter sdaCodeRef = new SqlDataAdapter(cmdCodeRef);
DataTable dt = new DataTable();
sdaCodeRef.Fill(dt);
CheckBoxList1.DataSource = dt;
CheckBoxList1.DataBind();
SqlCommand cmdCompany = new SqlCommand("Select * from Company where status=1");
DataTable dtCompany = db.getDataTable(cmdCompany);
DropDownListCompany.DataSource = dtCompany;
DropDownListCompany.DataValueField = "CompanyID";
DropDownListCompany.DataTextField = "Name";
DropDownListCompany.DataBind();
DropDownListCompany.Items.Insert(0, new ListItem("---Select A Company---", "0"));
Advertisement AdvertObj = new Advertisement();
Advertisement_Management aDao = new Advertisement_Management();
AdvertObj = aDao.getAdvByID(Session["AdvertID"].ToString());
DateTime startDatevar = Convert.ToDateTime(AdvertObj.StartDate);
String ConvertDate = startDatevar.ToString("yyyy-MM-dd");
DateTime dt2 = Convert.ToDateTime(AdvertObj.EndDate);
String ConvertEndDate = dt2.ToString("yyyy-MM-dd");
AdvIDLabel.Text = " for " + ' ' + AdvertObj.Name.ToString();
startDateTB.Text = ConvertDate;
endDateTB.Text = ConvertEndDate;
DropDownListCompany.SelectedValue = AdvertObj.CompanyID.ToString();
adNameTB.Text = AdvertObj.Name.ToString();
videoDurationTB.Text = AdvertObj.Duration.ToString();
SqlCommand cmd = new SqlCommand("select * from [AdvertisementAudience] where AdvID=@ID", conn);
SqlParameter param = new SqlParameter();
param.ParameterName = "@ID";
param.Value = Session["AdvertID"].ToString();
cmd.Parameters.Add(param);
SqlDataAdapter sda = new SqlDataAdapter();
DataTable datatable = new DataTable();
cmd.Connection = conn;
sda.SelectCommand = cmd;
sda.Fill(datatable);
cmd.Parameters.Clear();
// string userName = dtLoginTable.Rows[0]["UserName"].ToString();
string AgeID = datatable.Rows[0]["AgeID"].ToString();
for (int i = 0; i < datatable.Rows.Count; i++)
{
int ageChecker = Convert.ToInt32(datatable.Rows[i]["AgeID"]);
string GenderChecker = datatable.Rows[i]["GenderID"].ToString();
if (ageChecker == 1)
{
if (GenderChecker == "M")
{
CheckBoxList2.Items[0].Selected = true;
}
else
{
CheckBoxList2.Items[4].Selected = true;
}
}
if (ageChecker == 2)
{
if (GenderChecker == "M")
{
CheckBoxList2.Items[1].Selected = true;
}
else
{
CheckBoxList2.Items[5].Selected = true;
}
}
if (ageChecker == 3)
{
if (GenderChecker == "M")
{
CheckBoxList2.Items[2].Selected = true;
}
else
{
CheckBoxList2.Items[6].Selected = true;
}
}
if (ageChecker == 4)
{
if (GenderChecker == "M")
{
CheckBoxList2.Items[3].Selected = true;
}
else
{
CheckBoxList2.Items[7].Selected = true;
}
}
}
CompareValidator2.ValueToCompare = DateTime.Now.ToShortDateString();
SqlCommand cmdLoc = new SqlCommand("select a.AdvID,a.BillboardID,b.BillboardCode from AdvertisementLocation a inner join BillboardLocation b on a.BillboardID = b.BillboardID where a.AdvID = @ID", conn);
SqlParameter paramLoc = new SqlParameter();
paramLoc.ParameterName = "@ID";
paramLoc.Value = Session["AdvertID"].ToString();
cmdLoc.Parameters.Add(paramLoc);
SqlDataAdapter sdaLoc = new SqlDataAdapter();
DataTable datatableLoc = new DataTable();
cmdLoc.Connection = conn;
sdaLoc.SelectCommand = cmdLoc;
sdaLoc.Fill(datatableLoc);
cmdLoc.Parameters.Clear();
for (int i = 0; i < datatableLoc.Rows.Count; i++)
{
string BillboardCodefromdb = datatableLoc.Rows[i]["BillboardCode"].ToString();
foreach (GridViewRow gvr in GridView1.Rows)
{
if (gvr.RowType == DataControlRowType.DataRow)
{
CheckBox cb = (CheckBox)(gvr.FindControl("CheckBoxSelector"));
if (gvr.Cells[2].Text.ToString() == BillboardCodefromdb)
{
cb.Checked = true;
billboardDisplayTB.Text = billboardDisplayTB.Text + "," + gvr.Cells[2].Text;
}
}
}
// CompareValidator1.ValueToCompare = DateTime.Now.ToShortDateString();
}
billboardDisplayTB.Text = (billboardDisplayTB.Text).Substring(1);
SqlCommand cmdCat = new SqlCommand("select * from [AdvertisementCategory] where AdvID=@ID", conn);
SqlParameter paramCat = new SqlParameter();
paramCat.ParameterName = "@ID";
paramCat.Value = Session["AdvertID"].ToString();
cmdCat.Parameters.Add(paramCat);
SqlDataAdapter sdaCat = new SqlDataAdapter();
DataTable datatableCat = new DataTable();
cmdCat.Connection = conn;
sdaCat.SelectCommand = cmdCat;
sdaCat.Fill(datatableCat);
string name = "";
for (int i = 0; i < datatableCat.Rows.Count; i++)
{
//Auto,Bus,Career,Fin,Food,Gov,Health,Home,Ins,Int,Law,Mobile,Mother,Pets,Photo,Polit,
//Rec,Rest,Retail,Shop,Sport,Style,Tech,Tel,Travel,Wed,Women
//int ageChecker = Convert.ToInt32(datatable.Rows[i]["AgeID"]);
string catChecker = ((String)datatableCat.Rows[i]["CategoryID"]);
for (int x = 0; x < CheckBoxList1.Items.Count; x++)
{
if (catChecker == CheckBoxList1.Items[x].Value)
{
CheckBoxList1.Items[x].Selected = true;
name = name + "," + CheckBoxList1.Items[x].Value;
break;
}
}
// adCategoryTB.Text = (name).Substring(1);
}
adCategoryTB.Text = name.Substring(1);
}
}
protected void ButtonConfirm_Click(object sender, EventArgs e)
{
Advertisement AdvertObj = new Advertisement();
Advertisement_Management aDao = new Advertisement_Management();
AdvertObj = aDao.getAdvByID(Session["AdvertID"].ToString());
//initialise imagelink and getvalue
string imagelink = "";
string getvalue = "";
for (int i = 0; i < CheckBoxList2.Items.Count; i++)
{
if (CheckBoxList2.Items[i].Selected)
{
getvalue += CheckBoxList2.Items[i].Text + ",";
getvalue = getvalue.TrimEnd();
}
}
//if uploaded file then save
if (FileUpload1.HasFile)
{
string fileExt = System.IO.Path.GetExtension(FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("~/Images/") + FileUpload1.FileName);
}
if (Literal1.Text == "") // if no file is uploaded
{
string previousimagepath = AdvertObj.Item.ToString();
imagelink = previousimagepath;
}
else
{
imagelink = "Images/" + Literal1.Text;
}
string newItemType = AdvertObj.ItemType;
if (AdvertObj.ItemType == "image") // If file is image,
{
newItemType = AdvertObj.ItemType; // Item type will be image
}
else if (AdvertObj.ItemType == "video") // If file is video,
{
newItemType = AdvertObj.ItemType; // Item type will be video
}
string NewAdvertName = adNameTB.Text.ToString();
int NewCompanyID = Convert.ToInt32(DropDownListCompany.SelectedValue);
int NewDuration = Convert.ToInt32(videoDurationTB.Text);
string startdate = startDateTB.Text.ToString();
string enddate = endDateTB.Text.ToString();
string lastUpdBy = Session["userID"].ToString();
string lastUpdOn = DateTime.Now.ToString("MM/dd/yyyy h:mm tt");
SqlConnection sqlcn = new SqlConnection(Reference.Constr);
aDao.AdvertUpdate(Session["AdvertID"].ToString(), imagelink, newItemType, NewCompanyID, NewAdvertName, NewDuration, startdate, enddate, lastUpdBy, lastUpdOn);
//SqlCommand cmd = new SqlCommand("update [AdvertisementAudience] set AgeID=@newAgeID,GenderID=@newGenderID where AdvID=@paraAdvID " +
// "if @@rowcount=0 insert into [AdvertisementLocation] (AdvID,AgeID,GenderID) values (@newAdvID,@newAgeID,@newGenderID)", sqlcn);
// sqlcn.Open();
aDao.AdvertAudienceDeleteExisting(Session["AdvertID"].ToString());
aDao.AdvertCategoryDeleteExisting(Session["AdvertID"].ToString());
aDao.AdvertLocationDeleteExisting(Session["AdvertID"].ToString());
SqlConnection sqlcon = new SqlConnection(Reference.Constr);
string sqlquery = "Insert into [AdvertisementCategory](AdvID,CategoryID) values(@AdvID,@CategoryID)";
SqlCommand sqlcom = new SqlCommand(sqlquery, sqlcon);
sqlcon.Open();
string str = adCategoryTB.Text;
string[] splitstr = str.Split(',');
//int id = GetMaxIDAdvertisement();
foreach (string s in splitstr)
{
//trim the string, i.e. remove the space if any
string _s = s;
_s = _s.Trim();
sqlcom.Parameters.AddWithValue("@AdvID", Session["AdvertID"]);
sqlcom.Parameters.AddWithValue("@CategoryID", _s);
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
}
sqlcon.Close();
SqlConnection sqlconnn = new SqlConnection(Reference.Constr);
string sqlqueryy = "Insert into [AdvertisementLocation](AdvID,BillboardID) values(@AdvID,@BillboardID)";
SqlCommand sqlcommm = new SqlCommand(sqlqueryy, sqlconnn);
sqlconnn.Open();
//int AdvId = GetMaxIDAdvertisement();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
bool chkbx = ((CheckBox)row.FindControl("CheckBoxSelector")).Checked;
if (chkbx)
{
Label bblabel = (Label)GridView1.Rows[i].FindControl("lb_BillboardID");
sqlcommm.Parameters.AddWithValue("@BillboardID", Convert.ToInt32(bblabel.Text));
sqlcommm.Parameters.AddWithValue("@AdvID", Session["AdvertID"]);
sqlcommm.ExecuteNonQuery();
sqlcommm.Parameters.Clear();
}
}
sqlconnn.Close();
SqlConnection sqlcnAudience = new SqlConnection(Reference.Constr);
string sqlque = "Insert into [AdvertisementAudience](AdvID,AgeID,GenderID) values(@AdvID,@AgeID,@GenderID)";
SqlCommand sqlcm = new SqlCommand(sqlque, sqlcnAudience);
sqlcnAudience.Open();
//int ID_audience = GetMaxIDAdvertisement();
for (int i = 0; i < CheckBoxList2.Items.Count; i++)
{
if (CheckBoxList2.Items[i].Selected == true)
{
string stri = string.Empty;
stri = CheckBoxList2.Items[i].ToString();
if (stri.Contains("Male") & stri.Contains("Child"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "1");
}
else if (stri.Contains("Male") & stri.Contains("Young Adult"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "2");
}
else if (stri.Contains("Male") & stri.Contains("Age 31-65"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "3");
}
else if (stri.Contains("Male") & stri.Contains("Senior"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "4");
}
else if (stri.Contains("Female") & stri.Contains("Child"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "1");
}
else if (stri.Contains("Female") & stri.Contains("Young Adult"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "2");
}
else if (stri.Contains("Female") & stri.Contains("Age 31-65"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "3");
}
else if (stri.Contains("Female") & stri.Contains("Senior"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "4");
}
sqlcm.Parameters.AddWithValue("@AdvID", Session["AdvertID"]);
sqlcm.ExecuteNonQuery();
sqlcm.Parameters.Clear();
}
}
sqlcnAudience.Close();
adNameTB.Text = string.Empty;
DropDownListCompany.SelectedIndex = 0;
startDateTB.Text = string.Empty;
endDateTB.Text = string.Empty;
videoDurationTB.Text = string.Empty;
adCategoryTB.Text = string.Empty;
billboardDisplayTB.Text = string.Empty;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
CheckBoxList1.Items[i].Selected = false;
}
for (int i = 0; i > CheckBoxList2.Items.Count; i++)
{
CheckBoxList2.Items[i].Selected = false;
}
//alertWarning.Visible = false;
//alertSuccess.Visible = true;
Session["AdvertUpdate"] = 2;
Response.Redirect("AdvertList.aspx");
}
protected void ButtonConfirm_Click(object sender, EventArgs e)
{
Advertisement AdvertObj = new Advertisement();
Advertisement_Management aDao = new Advertisement_Management();
AdvertObj = aDao.getAdvByID(Session["AdvertID"].ToString());
//initialise imagelink and getvalue
string imagelink = "";
string getvalue = "";
for (int i = 0; i < CheckBoxList2.Items.Count; i++)
{
if (CheckBoxList2.Items[i].Selected)
{
getvalue += CheckBoxList2.Items[i].Text + ",";
getvalue = getvalue.TrimEnd();
}
}
//if uploaded file then save
if (FileUpload1.HasFile)
{
string fileExt = System.IO.Path.GetExtension(FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("~/Images/") + FileUpload1.FileName);
}
//if any field missing give warning!
if (Literal1.Text == "" || startDateTB.Text == "" ||
endDateTB.Text == "" || adCategoryTB.Text == "" || billboardDisplayTB.Text == "" || getvalue == "")
{
alertWarning.Visible = true;
warningLocation.Text = "Please ensure you have filled in all required fields";
}
//if never agree to terms and conditions,display warning
else if (CheckBox1.Checked == false)
{
alertWarning.Visible = true;
warningLocation.Text = "Please agree with T&C";
}
if (startDateTB.Text == "" || endDateTB.Text == "")
{
warningLocation.Visible = true;
}
else
{
imagelink = "Images/" + Literal1.Text;
string newItemType = Literal2.Text;
string NewAdvertName = adNameTB.Text.ToString();
int NewCompanyID = Convert.ToInt32(DropDownListCompany.SelectedValue);
int NewDuration = Convert.ToInt32(videoDurationTB.Text);
string startdate = startDateTB.Text.ToString();
string enddate = endDateTB.Text.ToString();
string lastUpdBy = Session["userID"].ToString();
string lastUpdOn = DateTime.Now.ToString("MM/dd/yyyy h:mm tt");
SqlConnection sqlcn = new SqlConnection(Reference.Constr);
aDao.AdvertUpdate(Session["AdvertID"].ToString(), imagelink, newItemType, NewCompanyID, NewAdvertName, NewDuration, startdate, enddate, lastUpdBy, lastUpdOn);
//SqlCommand cmd = new SqlCommand("update [AdvertisementAudience] set AgeID=@newAgeID,GenderID=@newGenderID where AdvID=@paraAdvID " +
// "if @@rowcount=0 insert into [AdvertisementLocation] (AdvID,AgeID,GenderID) values (@newAdvID,@newAgeID,@newGenderID)", sqlcn);
// sqlcn.Open();
aDao.AdvertAudienceDeleteExisting(Session["AdvertID"].ToString());
aDao.AdvertCategoryDeleteExisting(Session["AdvertID"].ToString());
aDao.AdvertLocationDeleteExisting(Session["AdvertID"].ToString());
SqlConnection sqlcon = new SqlConnection(Reference.Constr);
string sqlquery = "Insert into [AdvertisementCategory](AdvID,CategoryID) values(@AdvID,@CategoryID)";
SqlCommand sqlcom = new SqlCommand(sqlquery, sqlcon);
sqlcon.Open();
string str = adCategoryTB.Text;
string[] splitstr = str.Split(',');
//int id = GetMaxIDAdvertisement();
foreach (string s in splitstr)
{
//trim the string, i.e. remove the space if any
string _s = s;
_s = _s.Trim();
sqlcom.Parameters.AddWithValue("@AdvID", Session["AdvertID"]);
sqlcom.Parameters.AddWithValue("@CategoryID", _s);
sqlcom.ExecuteNonQuery();
sqlcom.Parameters.Clear();
}
sqlcon.Close();
SqlConnection sqlconnn = new SqlConnection(Reference.Constr);
string sqlqueryy = "Insert into [AdvertisementLocation](AdvID,BillboardID) values(@AdvID,@BillboardID)";
SqlCommand sqlcommm = new SqlCommand(sqlqueryy, sqlconnn);
sqlconnn.Open();
//int AdvId = GetMaxIDAdvertisement();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
bool chkbx = ((CheckBox)row.FindControl("CheckBoxSelector")).Checked;
if (chkbx)
{
Label bblabel = (Label)GridView1.Rows[i].FindControl("lb_BillboardID");
sqlcommm.Parameters.AddWithValue("@BillboardID", Convert.ToInt32(bblabel.Text));
sqlcommm.Parameters.AddWithValue("@AdvID", Session["AdvertID"]);
sqlcommm.ExecuteNonQuery();
sqlcommm.Parameters.Clear();
}
}
sqlconnn.Close();
SqlConnection sqlcnAudience = new SqlConnection(Reference.Constr);
string sqlque = "Insert into [AdvertisementAudience](AdvID,AgeID,GenderID) values(@AdvID,@AgeID,@GenderID)";
SqlCommand sqlcm = new SqlCommand(sqlque, sqlcnAudience);
sqlcnAudience.Open();
//int ID_audience = GetMaxIDAdvertisement();
for (int i = 0; i < CheckBoxList2.Items.Count; i++)
{
if (CheckBoxList2.Items[i].Selected == true)
{
string stri = string.Empty;
stri = CheckBoxList2.Items[i].ToString();
if (stri.Contains("Male") & stri.Contains("Child"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "1");
}
else if (stri.Contains("Male") & stri.Contains("Young Adult"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "2");
}
else if (stri.Contains("Male") & stri.Contains("Age 31-65"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "3");
}
else if (stri.Contains("Male") & stri.Contains("Senior"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "M");
sqlcm.Parameters.AddWithValue("@AgeID", "4");
}
else if (stri.Contains("Female") & stri.Contains("Child"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "1");
}
else if (stri.Contains("Female") & stri.Contains("Young Adult"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "2");
}
else if (stri.Contains("Female") & stri.Contains("Age 31-65"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "3");
}
else if (stri.Contains("Female") & stri.Contains("Senior"))
{
sqlcm.Parameters.AddWithValue("@GenderID", "F");
sqlcm.Parameters.AddWithValue("@AgeID", "4");
}
sqlcm.Parameters.AddWithValue("@AdvID", Session["AdvertID"]);
sqlcm.ExecuteNonQuery();
sqlcm.Parameters.Clear();
}
}
sqlcnAudience.Close();
adNameTB.Text = string.Empty;
DropDownListCompany.SelectedIndex = 0;
startDateTB.Text = string.Empty;
endDateTB.Text = string.Empty;
videoDurationTB.Text = string.Empty;
adCategoryTB.Text = string.Empty;
billboardDisplayTB.Text = string.Empty;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
CheckBoxList1.Items[i].Selected = false;
}
for (int i = 0; i > CheckBoxList2.Items.Count; i++)
{
CheckBoxList2.Items[i].Selected = false;
}
alertWarning.Visible = false;
alertSuccess.Visible = true;
Session["AdvertUpdate"] = 2;
Response.Redirect("AdvertList.aspx");
}
//ScriptManager.RegisterStartupScript(this, this.GetType(),
//"alert",
//"alert('Advertisement Successfully Updated');window.location ='AdListing.aspx';",
// true);
//Response.Write("<script language='javascript'>window.alert('Advertisement Successfully Updated');window.location='AdListingUpdate.aspx';</script>");
//string adNamenew = AdvertObj.Name;
//Response.Write("<script language='javascript'>alert('Successfully Updated Advertisement');</script>");
//Server.Transfer("AdListing.aspx", true);
// Response.Redirect(Request.RawUrl);
// alertSuccess.Visible = true;
// Response.Redirect("AdListing.aspx?showSuccessMessage = 1");
}