addetails.aspx.cs

PURPOSE OF THE PROJECT: This Application would facilitate the huge process of managing the Ad detai

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;

namespace MegaMartAudio
{
	//public string strOrgStatus,org_txtRemarks;
	/// <summary>
	/// Summary description for AdDetails.
	/// </summary>
	public class AdDetails : System.Web.UI.Page
	{
		
		string strPlink,strOrgStatus;
		protected System.Web.UI.WebControls.Label lblSub;
		protected System.Web.UI.WebControls.Label lblResult;
		protected System.Web.UI.WebControls.RadioButton rbNotEval;
		protected System.Web.UI.WebControls.RadioButton rbRejected;
		protected System.Web.UI.WebControls.RadioButton rbAccepted;
		protected System.Web.UI.WebControls.Button cmdUpdate;
		protected System.Web.UI.WebControls.Label lblName;
		protected System.Web.UI.WebControls.Label lblProduct;
		protected System.Web.UI.WebControls.Label lblModel;
		protected System.Web.UI.WebControls.Label lblVoice;
		protected System.Web.UI.WebControls.Label lblDuration;
		protected System.Web.UI.WebControls.Label lblContent;
		protected System.Web.UI.WebControls.Label lblVersion;
		protected System.Web.UI.WebControls.Label lblRelease;
		protected System.Web.UI.WebControls.Label lblRemarks;
		protected System.Web.UI.WebControls.Label lblModD;
		protected System.Web.UI.WebControls.Label lblStat;
		protected System.Web.UI.WebControls.Label lblPrev;
		protected System.Web.UI.WebControls.Label lblRel;
		protected System.Web.UI.WebControls.Label lblVer;
		protected System.Web.UI.WebControls.Label lblCont;
		protected System.Web.UI.WebControls.Label lblDur;
		protected System.Web.UI.WebControls.Label lblVoi;
		protected System.Web.UI.WebControls.Label lblMod;
		protected System.Web.UI.WebControls.Label lblProd;
		protected System.Web.UI.WebControls.Label lblModDate;
		protected System.Web.UI.WebControls.TextBox txtRemarks;
		protected System.Web.UI.WebControls.HyperLink hlkPreview;
		protected System.Web.UI.WebControls.Label lblDetails;
		protected System.Web.UI.WebControls.Button cmdReset;
		protected System.Web.UI.WebControls.Button cmdConfirm;
		protected System.Web.UI.WebControls.Label lblConfirm;
		protected System.Web.UI.WebControls.Label lblReset;
		protected System.Web.UI.WebControls.Label lblYesNo;
		protected System.Web.UI.WebControls.LinkButton lnbYes;
		protected System.Web.UI.WebControls.LinkButton lnbNo;
		protected System.Web.UI.WebControls.DataGrid dgTheTwo;
		//protected System.Web.UI.WebControls.Label lblRemarks;
		//protected System.Web.UI.WebControls.TextBox txtRemarks;
		//protected System.Web.UI.WebControls.Button cmdConfirm;
		//protected System.Web.UI.WebControls.Label lblConfirm;
		protected System.Web.UI.WebControls.Button cmdBack;
		//protected System.Web.UI.WebControls.Label lblResult;
		//protected System.Web.UI.WebControls.Button cmdBack;



		private void Page_Load(object sender, System.EventArgs e)
		{
			if(Session["sintID"] == null)
			{
				Response.Redirect("Unauthorised.aspx");
			}

			else
			{
				
				dgTheTwo.Visible = false;
				cmdBack.Visible = false;
				lblYesNo.Visible = false;
				lnbYes.Visible = false;
				lnbNo.Visible = false;
				rbAccepted.Enabled = true;
				rbRejected.Enabled = true;
				rbNotEval.Enabled = true;
				txtRemarks.Enabled = true;


				cmdUpdate.Visible = true;
				cmdReset.Visible = true;
				cmdConfirm.Visible = false;
				lblConfirm.Visible = false;
				lblReset.Visible = false;
				lblResult.Visible = false;



				if(!IsPostBack)
				{
					int intId = Convert.ToInt32(Request.QueryString[0]);
					//string strCon=ConfigurationSettings.AppSettings["DB"];
					string strCon="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
					SqlConnection con = new SqlConnection(strCon);
					SqlCommand cmd = new SqlCommand("select * from MMA_ALLDETAILS_VW where ALDTLS_AID = @adid",con);
					cmd.Parameters.Add("@adid",SqlDbType.Int);
					cmd.Parameters["@adid"].Value = intId;
					con.Open();
					SqlDataReader dr = cmd.ExecuteReader();

					if(dr.HasRows)
					{
						dr.Read();
					
						lblProduct.Text = dr.GetString(0);
						lblModel.Text = dr.GetString(2);
						lblName.Text = dr.GetString(6);
						lblVoice.Text = dr.GetString(9);
						lblDuration.Text = dr.GetString(10);
						lblContent.Text = dr.GetString(11);
						lblVersion.Text = dr.GetString(12);
						lblRelease.Text = dr.GetString(13);
						lblModDate.Text = dr.GetString(16);
						hlkPreview.Text = dr.GetString(14);
						strPlink = dr.GetString(14);

						strOrgStatus = dr.GetString(15);


						txtRemarks.Text = dr.GetString(17);
			
			
					}
					con.Close();

					if(strOrgStatus.Equals("Accepted"))
					{
						rbAccepted.Checked=true;
					}
					else if(strOrgStatus.Equals("Rejected"))
					{
						rbRejected.Checked=true;
					}
					else
					{
						rbNotEval.Checked=true;
					}



					strPlink="./Audio Files/" + strPlink + ".wav";
					hlkPreview.NavigateUrl = strPlink;
			

				}
			}

			
			

		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.cmdUpdate.Click += new System.EventHandler(this.cmdUpdate_Click);
			this.cmdReset.Click += new System.EventHandler(this.Reset_Click);
			this.cmdConfirm.Click += new System.EventHandler(this.cmdConfirm_Click);
			this.lnbYes.Click += new System.EventHandler(this.lnbYes_Click);
			this.cmdBack.Click += new System.EventHandler(this.cmdBack_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void LinkcmdUpdate_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("Advertisements.aspx");
		}

		private void cmdUpdate_Click(object sender, System.EventArgs e)
		{
			rbAccepted.Enabled = false;
			rbRejected.Enabled = false;
			rbNotEval.Enabled = false;
			txtRemarks.Enabled = false;
			lblConfirm.Visible = true;
			lblReset.Visible = true;

			

			cmdConfirm.Visible = true;
			cmdReset.Visible = true;
			lblResult.Visible = true;



			string strPgStatus,strPgRemarks,strOrgStatus2="",strOrgRemarks2="";
			int intOrgAdnum = -1,intOrgMid = -1;

			strPgRemarks = txtRemarks.Text;

			if(rbAccepted.Checked == true)
			{
				strPgStatus = "Accepted";
			}
			else if(rbRejected.Checked == true)
			{
				strPgStatus = "Rejected";
			}
			else
			{
				strPgStatus = "Not Evaluated";
			}

			int intId2 = Convert.ToInt32(Request.QueryString[0]);
			//string strCon=ConfigurationSettings.AppSettings["DB"];
			string strCon="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
			SqlConnection con1 = new SqlConnection(strCon);
			SqlCommand cmd1= new SqlCommand("select * from MMA_ALLDETAILS_VW where ALDTLS_AID = @adid",con1);
			cmd1.Parameters.Add("@adid",SqlDbType.Int);
			cmd1.Parameters["@adid"].Value = intId2;
			con1.Open();
			SqlDataReader dr = cmd1.ExecuteReader();

			if(dr.HasRows)
			{				
				dr.Read();
				intOrgAdnum = dr.GetInt32(4);
				intOrgMid = dr.GetInt32(3);
				strOrgStatus2 = dr.GetString(15);
				strOrgRemarks2 =  dr.GetString(17);
					
			}
			con1.Close();
			

			//neither txtRemarks nor status changed
			if(strPgStatus.Equals(strOrgStatus2) && strPgRemarks.Equals(strOrgRemarks2))
			{
				lblResult.Text = "Nothing new to update!";
				lblConfirm.Text = "";
				lblReset.Text = "";
				rbAccepted.Enabled = true;
				rbRejected.Enabled = true;
				rbNotEval.Enabled = true;
				txtRemarks.Enabled = true;
				cmdConfirm.Visible = false;
				cmdUpdate.Visible = true;
				cmdReset.Visible = true;
			
			}
			else
			{
				lblResult.Text = "";
				lblConfirm.Text = "Click on 'Confirm' to Update the Database";
				lblReset.Text = "Click on 'Reset' to restore the original values";
				cmdConfirm.Visible = true;
				cmdUpdate.Visible = false;
				cmdReset.Visible = true;
			}

			
	

		}

		private void Reset_Click(object sender, System.EventArgs e)
		{
			
			

			cmdUpdate.Visible = true;
			cmdReset.Visible = true;
			cmdConfirm.Visible = false;

			lblConfirm.Visible = false;
			lblReset.Visible = true;
			lblResult.Visible = false;

			string strResetStatus="",strResetRemarks="";
		
			
			int intId = Convert.ToInt32(Request.QueryString[0]);
			//string strCon=ConfigurationSettings.AppSettings["DB"];
			string strCon="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
			SqlConnection con2 = new SqlConnection(strCon);
			SqlCommand cmd2 = new SqlCommand("select * from MMA_ALLDETAILS_VW where ALDTLS_AID = @adid",con2);
			cmd2.Parameters.Add("@adid",SqlDbType.Int);
			cmd2.Parameters["@adid"].Value = intId;
			con2.Open();
			SqlDataReader dr = cmd2.ExecuteReader();

			if(dr.HasRows)
			{
				dr.Read();
				strResetStatus = dr.GetString(15);
				strResetRemarks = dr.GetString(17);
			
			
			}