using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using sst.classes;

namespace sst.nav
{
	/// <summary>
	/// Création d'un nouveau plan de prévention.
	/// </summary>
	public class newPP : System.Web.UI.Page
	{
		protected string sDayMan, sHour, sDBSaveError, sDateFormat;
		protected System.Web.UI.WebControls.Label lblIntCoRep;
		protected System.Web.UI.WebControls.TextBox txtExtCo, txtExtCoRep, txtOpeNat, txtPlace, txtSSTResp, txtSectResp, txtEndDate, txtBegDate, txtBegTime, txtEndTime, txtNbInterv,  txtExtCoAct, txtDuration, txtIndSec, txtTxFreqAcc, txtTxGrav, txtZoneResp, txtIntervResp;
		protected System.Web.UI.WebControls.DropDownList ddlExtCo;
		
		protected System.Web.UI.WebControls.Label lblNumPP;
		protected System.Web.UI.WebControls.Button btnOK;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvExtCo, rfvOpeNat, rfvPlace, rfvSectResp, rfvBegDate, rfvEndDate, rfvNbInterv, rfvZoneResp, rfvIntervResp, rfvExtCoRep;
		protected System.Web.UI.WebControls.CompareValidator cvBegDate, cvEndDate, cvNbInterv;
		protected System.Web.UI.WebControls.RangeValidator rvBegTime, rvEndTime;
		protected System.Web.UI.WebControls.ValidationSummary vsExtCo;
		protected System.Web.UI.WebControls.CompareValidator cvIndSec;
		protected System.Web.UI.WebControls.CompareValidator cvTxFreqAcc;
		protected System.Web.UI.WebControls.CompareValidator cvTxGrav;
		protected System.Web.UI.HtmlControls.HtmlGenericControl h2Title;
		protected System.Web.UI.HtmlControls.HtmlGenericControl legendIntComp;
		protected System.Web.UI.HtmlControls.HtmlTableCell tdRepr;
		protected System.Web.UI.HtmlControls.HtmlGenericControl legendExtComp;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblExtCoName;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblSecScore;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblRepr2;
		protected System.Web.UI.HtmlControls.HtmlGenericControl legendOperation;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblOpeNat;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblPlace;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblSSTResp;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblSectResp;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblZoneResp;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblIntervResp;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblBegDate;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblAt1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblHour1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblEndDate;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblAt2;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblHour2;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblNbInterv;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblDuration;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblTxFreqAcc;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblTxGrav;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblRepr, lblCompScore;
		protected System.Web.UI.HtmlControls.HtmlInputHidden inputNumPP;
		protected System.Web.UI.WebControls.DropDownList ddlIntCompany;
		protected System.Data.OracleClient.OracleConnection cn;
		protected System.Data.OracleClient.OracleDataAdapter daCompany;
		protected sst.admin.tables tables1;
		protected System.Data.OracleClient.OracleCommand oracleSelectCommand1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl divError;
		protected System.Web.UI.HtmlControls.HtmlGenericControl legendIndSec;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lbl24hNotation;
		protected System.Web.UI.HtmlControls.HtmlTableCell tdAssur;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblYear;
		protected System.Web.UI.HtmlControls.HtmlInputHidden txtCompScore, txtCompScorePrev;

		protected string CalendarLang;
		protected int nWHMorning1, nWHAfternoon2;
		protected System.Web.UI.WebControls.DropDownList ddlCompActivity;
		protected System.Web.UI.HtmlControls.HtmlTableCell lblActivity;
		protected System.Web.UI.HtmlControls.HtmlGenericControl lblCompScorePrev;

		private void Page_Load(object sender, System.EventArgs e)
		{
			InitLoc();
			/*cvTxGrav.Attributes["decimalchar"] = ".";
			cvTxFreqAcc.Attributes["decimalchar"] = ".";*/
			txtExtCo.Visible = User.IsInRole("Admin");
			txtExtCoAct.Visible= User.IsInRole("Admin");
			divError.Visible = false;
			if (!IsPostBack)
				initFields();
		}
		
		/// <summary>
		/// Initialise les champs du formulaire
		/// </summary>
		private void initFields()
		{
			// Société interne
			user u = new user();
			if (u.loadCurrent())
			{
				lblIntCoRep.Text = utils.InitCaps(u.firstName + " " + u.lastName).Trim();
				if (!u.function.Equals(""))
					lblIntCoRep.Text += ", " + u.function;
				/*foreach (ListItem li in rblIntCompany.Items)
				{
					if (String.Compare(u.companyName,li.Value,true) == 0)
						li.Selected = true;
				}
				if (rblIntCompany.SelectedIndex == -1)
					rblIntCompany.SelectedIndex = 0;*/
				
				daCompany.SelectCommand.Parameters[":SiteID"].Value = user.siteID;
				daCompany.Fill(tables1.SST_COMPANY);
				ddlIntCompany.DataBind();
				foreach (ListItem li in ddlIntCompany.Items)
				{
					if (String.Compare(u.companyName,li.Value,true) == 0)
						li.Selected = true;
				}
				if (ddlIntCompany.SelectedIndex == -1)
					ddlIntCompany.SelectedIndex = 0;
			}
			
			// Liste des sociétés externes
			ddlExtCo.Items.Clear();
			ddlExtCo.Items.Add(new ListItem("", "####0##0##0##0##0"));
			companyList cl = new companyList();
			cl.loadExt(true);
			for (int i=0; i<cl.count; i++)
				ddlExtCo.Items.Add(new ListItem(cl[i].compName, cl[i].repName + "##" + cl[i].compActivity +
					"##" + cl[i].note.ToString() + "##" + cl[i].indiceYear.ToString() +
					"##" + cl[i].lostWorkday.ToString() + "##" + cl[i].severityRate.ToString() + "##" + cl[i].notePrev.ToString()));
			ddlExtCo.Attributes.Add("onchange", "setExtCo()");
			
			inputNumPP.Value = pp.generateNumber().ToString();
			h2Title.InnerText = h2Title.InnerText.Replace("#NUMPP#", inputNumPP.Value);

			System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo(user.culture);

			txtBegDate.Text = DateTime.Now.ToShortDateString();
			txtBegTime.Text = DateTime.Now.ToString("%H");
			txtBegDate.Attributes.Add("onblur", "calcDuration()");
			txtEndDate.Attributes.Add("onblur", "calcDuration()");
			txtNbInterv.Attributes.Add("onblur", "calcDuration()");
			txtBegTime.Attributes.Add("onblur", "calcDuration()");
			txtEndTime.Attributes.Add("onblur", "calcDuration()");
			txtDuration.Attributes.Add("style", "display: none;");

			// Liste des activités
			ddlCompActivity.Items.Add(new ListItem("", ""));
			cl.loadActivities();
			for (int i=0; i<cl.count; i++)
				ddlCompActivity.Items.Add(new ListItem(cl[i].compActivity, cl[i].compActivity));
			
			// Reprise depuis un PP existant
			if (Request.QueryString["idppmodel"] != null)
			{
				pp p = new pp(Int32.Parse(Request.QueryString["idppmodel"]));
				txtExtCo.Text = p.extComp;
				txtExtCoRep.Text = p.extRep;
				txtExtCoAct.Text = p.extAct;
				txtOpeNat.Text = p.opNature;
				txtPlace.Text = p.place;
				txtSSTResp.Text = p.sstResp;
				txtSectResp.Text = p.sectResp;
				txtZoneResp.Text = p.zoneResp;
				txtIntervResp.Text = p.intervResp;
				txtIndSec.Text = p.indSec.ToString();
				txtTxFreqAcc.Text = p.txFreqAcc.ToString();
				txtTxGrav.Text = p.txGrav.ToString();
				txtCompScore.Value = p.compScore.ToString();
				txtCompScorePrev.Value = p.compScorePrev.ToString();
			}

			site s = new site(int.Parse(user.siteID));
			nWHMorning1 = s.whMorning1;
			nWHAfternoon2 = s.whAfternoon2;
		}

		private void btnOK_Click(object sender, System.EventArgs e)
		{
			string sRedirect;
		
			try
			{
				CultureInfo ci = new CultureInfo(user.culture, false);
				vsExtCo.HeaderText = "";
				txtTxFreqAcc.Text = txtTxFreqAcc.Text.Replace(".", ci.NumberFormat.NumberDecimalSeparator).Replace(",", ci.NumberFormat.NumberDecimalSeparator);
				txtTxGrav.Text = txtTxGrav.Text.Replace(".", ci.NumberFormat.NumberDecimalSeparator).Replace(",", ci.NumberFormat.NumberDecimalSeparator);
				Page.Validate();
				if (Page.IsValid)
				{
					pp p = new pp();
					ci.Calendar.TwoDigitYearMax = 2099;
				
					if (txtBegTime.Text.Trim().Equals(""))
						txtBegTime.Text = "09";
					if (txtEndTime.Text.Trim().Equals(""))
						txtEndTime.Text = "18";

					p.id = Int32.Parse(inputNumPP.Value);
					p.idSite = utils.IntParse(user.siteID);
					p.intComp = ddlIntCompany.SelectedItem.Text;
					p.intRep = lblIntCoRep.Text;
					p.extComp = txtExtCo.Text;
					p.extRep = txtExtCoRep.Text;
					p.extAct = txtExtCoAct.Text;
					p.opNature = txtOpeNat.Text;
					p.place = txtPlace.Text;
					p.sstResp = txtSSTResp.Text;
					p.sectResp = txtSectResp.Text;
					p.zoneResp = txtZoneResp.Text;
					p.intervResp = txtIntervResp.Text;
					p.begDate = DateTime.Parse(txtBegDate.Text + " " + txtBegTime.Text + ":00:00", ci);
					p.endDate = DateTime.Parse(txtEndDate.Text + " " + txtEndTime.Text + ":00:00", ci);
					p.duration = utils.DoubleParse(txtDuration.Text);
					p.nbInterv = Int32.Parse(txtNbInterv.Text);
					if (!txtIndSec.Text.Equals(""))
						p.indSec = utils.IntParse(txtIndSec.Text);
					if (!txtTxFreqAcc.Text.Equals(""))
						p.txFreqAcc = utils.DoubleParse(txtTxFreqAcc.Text);
					if (!txtTxGrav.Text.Equals(""))
						p.txGrav = utils.DoubleParse(txtTxGrav.Text);
					if (!txtCompScore.Value.Equals(""))
						p.compScore = utils.IntParse(txtCompScore.Value);
					if (!txtCompScorePrev.Value.Equals(""))
						p.compScorePrev = utils.IntParse(txtCompScorePrev.Value);
					
					user u = new user();
					if (u.loadCurrent())
						p.respMail = u.email;

					if (p.update())
					{
						sRedirect = "critCheck.aspx?idpp=" + p.id.ToString();
						if (Request.QueryString["idppmodel"] != null)
							sRedirect += "&idppmodel=" + Request.QueryString["idppmodel"];
						//Server.Transfer(sRedirect);
						Response.Redirect(sRedirect);
					}
				}
			}
			catch (Exception err)
			{
				divError.InnerText = err.Message;
				divError.Visible = true;
			}
		}
		
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			InitializeComponent();
			base.OnInit(e);
		}

		private void InitializeComponent()
		{
			System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
			this.cn = new System.Data.OracleClient.OracleConnection();
			this.daCompany = new System.Data.OracleClient.OracleDataAdapter();
			this.oracleSelectCommand1 = new System.Data.OracleClient.OracleCommand();
			this.tables1 = new sst.admin.tables();
			((System.ComponentModel.ISupportInitialize)(this.tables1)).BeginInit();
			this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
			// 
			// cn
			// 
			this.cn.ConnectionString = ((string)(configurationAppSettings.GetValue("CS_SST", typeof(string))));
			// 
			// daCompany
			// 
			this.daCompany.SelectCommand = this.oracleSelectCommand1;
			this.daCompany.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								new System.Data.Common.DataTableMapping("Table", "SST_COMPANY", new System.Data.Common.DataColumnMapping[] {
																																																			   new System.Data.Common.DataColumnMapping("SST_NID", "SST_NID"),
																																																			   new System.Data.Common.DataColumnMapping("SST_SLABEL", "SST_SLABEL"),
																																																			   new System.Data.Common.DataColumnMapping("SST_SITE_ID", "SST_SITE_ID")})});
			// 
			// oracleSelectCommand1
			// 
			this.oracleSelectCommand1.CommandText = "SELECT SST_COMPANY.SST_NID, SST_COMPANY.SST_SLABEL, SST_COMPANY_SITE.SST_SITE_ID " +
				"FROM SST_COMPANY, SST_COMPANY_SITE WHERE SST_COMPANY.SST_NID = SST_COMPANY_SITE." +
				"SST_COMPANY_ID AND (SST_COMPANY_SITE.SST_SITE_ID = :SiteID) ORDER BY SST_COMPANY" +
				".SST_SLABEL";
			this.oracleSelectCommand1.Connection = this.cn;
			this.oracleSelectCommand1.Parameters.Add(new System.Data.OracleClient.OracleParameter(":SiteID", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(38)), ((System.Byte)(0)), "SST_SITE_ID", System.Data.DataRowVersion.Current, null));
			// 
			// tables1
			// 
			this.tables1.DataSetName = "tables";
			this.tables1.Locale = new System.Globalization.CultureInfo("en-US");
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.tables1)).EndInit();

		}
		#endregion

		private void InitLoc()
		{
			try
			{
				//user.setUserCulture();
				localization l = new localization();
				cvBegDate.ErrorMessage = l.GetString("newPP.cvBegDate");
				rvBegTime.ErrorMessage = l.GetString("newPP.rvBegTime");
				cvEndDate.ErrorMessage = l.GetString("newPP.cvEndDate");
				rvEndTime.ErrorMessage = l.GetString("newPP.rvEndTime");
				cvIndSec.ErrorMessage = l.GetString("newPP.cvIndSec");
				cvNbInterv.ErrorMessage = l.GetString("newPP.cvNbInterv");
				cvTxFreqAcc.ErrorMessage = l.GetString("newPP.cvTxFreqAcc");
				cvTxGrav.ErrorMessage = l.GetString("newPP.cvTxGrav");
				sDBSaveError = l.GetString("newPP.dbSaveError");
				tdAssur.InnerText = l.GetString("newPP.lblAssur");
				lblAt1.InnerText = lblAt2.InnerText = l.GetString("newPP.lblAt");
				lblBegDate.InnerText = l.GetString("newPP.lblBegDate");
				lblDuration.InnerText = l.GetString("newPP.lblDuration");
				lblEndDate.InnerText = l.GetString("newPP.lblEndDate");
				lblActivity.InnerText = l.GetString("newPP.lblExtCoAct");
				legendExtComp.InnerText = l.GetString("newPP.lblExtComp");
				lblExtCoName.InnerText = l.GetString("newPP.lblExtCoName");
				lblHour1.InnerText = lblHour2.InnerText = l.GetString("newPP.lblHour");
				legendIndSec.InnerText = l.GetString("newPP.lblIndSec");
				legendIntComp.InnerText = l.GetString("newPP.lblIntComp");
				lblIntervResp.InnerText = l.GetString("newPP.lblIntervResp");
				lblNbInterv.InnerText = l.GetString("newPP.lblNbInterv");
				lblOpeNat.InnerText = l.GetString("newPP.lblOpeNat");
				legendOperation.InnerText = l.GetString("newPP.lblOperation");
				lblPlace.InnerText = l.GetString("newPP.lblPlace");
				h2Title.InnerText = l.GetString("newPP.lblPPCreation");
				lblRepr2.InnerText = l.GetString("newPP.lblRepr");
				lblSecScore.InnerText = l.GetString("newPP.lblSecScore");
				lblSectResp.InnerText = l.GetString("newPP.lblSectResp");
				lblSSTResp.InnerText = l.GetString("newPP.lblSSTResp");
				lblTxFreqAcc.InnerText = l.GetString("newPP.lblTxFreqAcc");
				lblTxGrav.InnerText = l.GetString("newPP.lblTxGrav");
				lblZoneResp.InnerText = l.GetString("newPP.lblZoneResp");
				rfvBegDate.ErrorMessage = l.GetString("newPP.rfvBegDate");
				rfvEndDate.ErrorMessage = l.GetString("newPP.rfvEndDate");
				rfvExtCo.ErrorMessage = l.GetString("newPP.rfvExtCoName");
				rfvExtCoRep.ErrorMessage = l.GetString("newPP.rfvExtCoRep");
				rfvIntervResp.ErrorMessage = l.GetString("newPP.rfvIntervResp");
				rfvNbInterv.ErrorMessage = l.GetString("newPP.rfvNbInterv");
				rfvOpeNat.ErrorMessage = l.GetString("newPP.rfvOpeNat");
				rfvPlace.ErrorMessage = l.GetString("newPP.rfvPlace");
				rfvSectResp.ErrorMessage = l.GetString("newPP.rfvSectResp");
				rfvZoneResp.ErrorMessage = l.GetString("newPP.rfvZoneResp");
				sDayMan = l.GetString("newPP.sDayMan");
				sHour = l.GetString("newPP.sHour");
				btnOK.Text = l.GetString("generic.save");
				lblRepr.InnerText = l.GetString("newPP.lblRepr");
				lbl24hNotation.InnerText = l.GetString("newPP.lbl24hNotation");
				lblYear.InnerText = l.GetString("newPP.lblYear");

				CalendarLang = user.culture.StartsWith("fr") ? "fr" : "en";
			}
			catch (Exception err)
			{
				errorMgr.logError(err);
			}
		}

		

	

	}
}