addetails.aspx.cs

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

			con2.Close();


			if(strResetStatus.Equals("Accepted"))
			{
				rbRejected.Checked=false;
				rbNotEval.Checked=false;
				rbAccepted.Checked=true;

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

			}
			else
			{
				rbAccepted.Checked=false;
				rbRejected.Checked=false;
				rbNotEval.Checked=true;
				
			}
			txtRemarks.Text = strResetRemarks;
			lblReset.Text = "Values have been reset";

		}

		private void cmdConfirm_Click(object sender, System.EventArgs e)
		{
		
			cmdUpdate.Visible = true;
			cmdReset.Visible = true;
			cmdConfirm.Visible = false;

			lblConfirm.Visible = false;
			lblReset.Visible = false;
			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 con3 = new SqlConnection(strCon);
			SqlCommand cmd3 = new SqlCommand("select * from MMA_ALLDETAILS_VW where ALDTLS_AID = @adid",con3);
			cmd3.Parameters.Add("@adid",SqlDbType.Int);
			cmd3.Parameters["@adid"].Value = intId2;
			con3.Open();
			SqlDataReader dr = cmd3.ExecuteReader();

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

			//neither txtRemarks nor status changed
			if(strPgStatus.Equals(strOrgStatus2) && strPgRemarks.Equals(strOrgRemarks2))
			{
				lblResult.Text = "Nothing new to update!";
			
			}


			//-----------------------------------------------------------------------
			//START of the block when status is changed
			if(!strPgStatus.Equals(strOrgStatus2))
			{

				//START of the block when status is changed TO ACCEPTED FROM rejected or not evaluated
				if(strPgStatus.Equals("Accepted"))
				{
					if(intOrgAdnum == 2)
					{
						lblResult.Text += "Two Advertisements have already been accepted for this model";
						lblYesNo.Visible = true;
						lnbYes.Visible = true;
						lnbNo.Visible = true;
						
					}
					else
					{
						int intChgAdnum = intOrgAdnum + 1;
						//string strCon1=ConfigurationSettings.AppSettings["DB"];
						string strCon1="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
						SqlConnection con1 = new SqlConnection(strCon1);
						SqlCommand cmd1 = new SqlCommand("update MMA_ADS_TB set ADS_STATUS=@adstatus where PK_ADS_ID=@adid",con1);
						cmd1.Parameters.Add("@adstatus",SqlDbType.VarChar,20);
						cmd1.Parameters.Add("@adid",SqlDbType.Int);
						cmd1.Parameters["@adstatus"].Value = strPgStatus;
						cmd1.Parameters["@adid"].Value = intId2;
					
						SqlCommand cmd12 = new SqlCommand("update MMA_MODELS_TB set MOD_ADNUM=@adnum where PK_MOD_ID=@mid",con1);
						cmd12.Parameters.Add("@adnum",SqlDbType.Int);
						cmd12.Parameters.Add("@mid",SqlDbType.Int);
						cmd12.Parameters["@adnum"].Value = intChgAdnum;
						cmd12.Parameters["@mid"].Value = intOrgMid;
			
						con1.Open();
						cmd1.ExecuteNonQuery();
						cmd12.ExecuteNonQuery();
						con1.Close();
						lblResult.Visible = true;
						lblResult.Text += "Updated status";
					}
				}
					//END of the block when status is changed TO ACCEPTED FROM rejected or not evaluated





					//START of the block when status is changed FROM ACCEPTED TO rejected or not evaluated
			
				else if(strOrgStatus2.Equals("Accepted") && !strPgStatus.Equals("Accepted"))
				{
					int intChgAdnum = intOrgAdnum - 1;
					//string strCon2=ConfigurationSettings.AppSettings["DB"];
					string strCon2="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
					SqlConnection con2 = new SqlConnection(strCon2);
					SqlCommand cmd2 = new SqlCommand("update MMA_ADS_TB set ADS_STATUS =@adstatus where PK_ADS_ID =@adid",con2);
					cmd2.Parameters.Add("@adstatus",SqlDbType.VarChar,20);
					cmd2.Parameters.Add("@adid",SqlDbType.Int);
					cmd2.Parameters["@adstatus"].Value = strPgStatus;
					cmd2.Parameters["@adid"].Value = intId2;



					
					SqlCommand cmd22 = new SqlCommand("update MMA_MODELS_TB set MOD_ADNUM =@adnum where PK_MOD_ID =@mid",con2);
					cmd22.Parameters.Add("@adnum",SqlDbType.Int);
					cmd22.Parameters.Add("@mid",SqlDbType.Int);
					cmd22.Parameters["@adnum"].Value = intChgAdnum;
					cmd22.Parameters["@mid"].Value = intOrgMid;
			
						
					con2.Open();
					cmd2.ExecuteNonQuery();
					cmd22.ExecuteNonQuery();
					con2.Close();
					lblResult.Visible = true;
					lblResult.Text += "Updated status";
				}
					//END of the block when status is changed FROM ACCEPTED TO rejected or not evaluated




					//START of the block when status is changed FROM REJECTED TO NOT EVALUATED or vice versa
				else 
				{
					//string strCon3=ConfigurationSettings.AppSettings["DB"];
					string strCon3="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
					SqlConnection con4 = new SqlConnection(strCon3);
					SqlCommand cmd4 = new SqlCommand("update MMA_ADS_TB set ADS_STATUS =@adstatus where PK_ADS_ID =@adid",con4);
					cmd4.Parameters.Add("@adstatus",SqlDbType.VarChar,20);
					cmd4.Parameters.Add("@adid",SqlDbType.Int);
					cmd4.Parameters["@adstatus"].Value = strPgStatus;
					cmd4.Parameters["@adid"].Value = intId2;

	
						
					con3.Open();
					cmd3.ExecuteNonQuery();
					con3.Close();
					lblResult.Visible = true;
					lblResult.Text += "Updated status";
				
				}
				//END of the block when status is changed FROM REJECTED TO NOT EVALUATED or vice versa
			
			}
			//
			//END of the block when status is changed
			// -------------------------------------------------------------------------



			//----------------------------------------------------------------------------
			//Start of block when Remarks is changed
			if(!strPgRemarks.Equals(strOrgRemarks2))
			{
				//string strCon3=ConfigurationSettings.AppSettings["DB"];
				string strCon3="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
				SqlConnection con5 = new SqlConnection(strCon3);
				SqlCommand cmd5 = new SqlCommand("update MMA_ADS_TB set ADS_REMARKS =@adtxtRemarks where PK_ADS_ID =@adid",con5);
				cmd5.Parameters.Add("@adRemarks",SqlDbType.VarChar,100);
				cmd5.Parameters.Add("@adid",SqlDbType.Int);
				cmd5.Parameters["@adRemarks"].Value = strPgRemarks;
				cmd5.Parameters["@adid"].Value = intId2;
				con5.Open();
				cmd5.ExecuteNonQuery();
				con5.Close();
				lblResult.Visible = true;
				lblResult.Text += "Updated Remarks";
			}
			//END of block when txtRemarks is changed
			//----------------------------------------------------------------------------
			//
		}

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

		private void lnbNo_Click(object sender, System.EventArgs e)
		{
			lblYesNo.Visible = false;
			lnbYes.Visible = false;
			lnbNo.Visible = false;

			rbAccepted.Enabled = true;
			rbRejected.Enabled = true;
			rbNotEval.Enabled = true;
			txtRemarks.Enabled = true;

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


		}

		private void lnbYes_Click(object sender, System.EventArgs e)
		{
			string strOrgP="",strOrgM="";
			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();
					
				strOrgP = dr.GetString(0);
				strOrgM = dr.GetString(2);
						
			}
			con.Close();





			dgTheTwo.Visible = true;
			cmdBack.Visible = true;
			lblYesNo.Visible = false;
			lnbYes.Visible = false;
			lnbNo.Visible = false;
			cmdConfirm.Visible = false;
			cmdReset.Visible = false;


			
			string strCmd = "select ALDTLS_UNAME as [Submitted By], ALDTLS_ASTATUS as Status, ALDTLS_AREMARKS as Remarks, ALDTLS_AID as AdID from MMA_ALLDETAILS_VW where ALDTLS_PNAME= '"+ strOrgP +"' and ALDTLS_MNAME ='"+ strOrgM +"' and ALDTLS_ASTATUS ='Accepted'";
            SqlCommand cmd2 = new SqlCommand(strCmd,con);
			DataSet ds2=new DataSet();
			SqlDataAdapter da2=new SqlDataAdapter(cmd2);
			da2.Fill(ds2);
			dgTheTwo.DataSource = ds2;
			dgTheTwo.DataBind();





		}

		private void cmdBack_Click(object sender, System.EventArgs e)
		{
			rbAccepted.Enabled = true;
			rbRejected.Enabled = true;
			rbNotEval.Enabled = true;
			txtRemarks.Enabled = true;

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

		
		}

		
	}
}