protected void BindBDdl() { Cnx.SelecBD(); using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex())) { string VbTxtSql = "EXEC SP_PANTALLA_Reporte_Manto2 11,'','','','','',0,0,0,@ICC,'01-01-1','02-01-1','03-01-1'"; sqlConB.Open(); using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB)) { SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]); using (SqlDataAdapter SDA = new SqlDataAdapter()) { using (DataSet DST = new DataSet()) { SDA.SelectCommand = SC; SDA.Fill(DST); DST.Tables[0].TableName = "HK"; DST.Tables[1].TableName = "Estado"; DST.Tables[2].TableName = "OT"; DST.Tables[3].TableName = "Rte"; ViewState["DST"] = DST; } } } } DST = (DataSet)ViewState["DST"]; DdlAeronave.DataSource = DST.Tables[0]; DdlAeronave.DataTextField = "Matricula"; DdlAeronave.DataValueField = "CodAeronave"; DdlAeronave.DataBind(); DdlStatus.DataSource = DST.Tables[1]; DdlStatus.DataTextField = "Descripcion"; DdlStatus.DataValueField = "CodStatus"; DdlStatus.DataBind(); DdlOTPpl.DataSource = DST.Tables[2]; DdlOTPpl.DataTextField = "Descripcion"; DdlOTPpl.DataValueField = "CodOt"; DdlOTPpl.DataBind(); DdlRpteNro.DataSource = DST.Tables[3]; DdlRpteNro.DataTextField = "Descripcion"; DdlRpteNro.DataValueField = "CodIdLvDetManto"; DdlRpteNro.DataBind(); }
protected void LoadStatus() { try { if (Session["UserLevel"].ToString() == "4User") { DdlStatus.Items.Add( new ListItem("Applied", "AL") ); } else { if (DdlStaffid.SelectedValue.Equals(Session["StaffId"].ToString())) { DdlStatus.Items.Clear(); DdlStatus.Items.Add( new ListItem("Applied", "AL") ); DdlStatus.SelectedValue = "AL"; } else { DataView dv = new DataView(dsLKUP.Tables[0]); DataTable dt = new DataTable(); dv.RowFilter = "CodeId='LS'"; dt = dv.ToTable(); DdlStatus.DataSource = dt; DdlStatus.DataTextField = "ShortDesc"; DdlStatus.DataValueField = "CodeValue"; DdlStatus.DataBind(); DdlStatus.SelectedValue = "AP"; DdlStatus.Items.Remove(DdlStatus.Items.FindByValue("AL")); } } DdlStatus.Items.Insert(0, "Please Select"); } catch (Exception ex) { WebMsgBox.Show("Failed on load Leave status!"); } }
private void BindGridView(bool clearAllFilters = false) { using (var aryaDc = new AryaDbDataContext()) { var currUser = (from u in aryaDc.Users where u.EmailAddress == Email select u).FirstOrDefault(); if (currUser == null) { FormsAuthentication.RedirectToLoginPage(); return; } using (var taskDc = new AryaServicesDbDataContext()) { var tasks = Enumerable.Empty <AryaTask>().AsQueryable(); if (currUser.IsAdmin) { tasks = taskDc.AryaTasks; } else { //Import Admin Tasks tasks = tasks.Union(GetTasks(aryaDc, taskDc, currUser, Group.ImportAdminGroup, new[] { typeof(ImportWorker).Name }, false)); //Import User Tasks tasks = tasks.Union(GetTasks(aryaDc, taskDc, currUser, Group.ImportUserGroup, new[] { typeof(ImportWorker).Name }, true)); var exportJobTypes = ExportWorkerBase.GetExports().Select(e => e.GetType().Name).ToList(); //Export Admin Tasks tasks = tasks.Union(GetTasks(aryaDc, taskDc, currUser, Group.ExportAdminGroup, exportJobTypes.Union(typeof(CustomExportWorker).Name), false)); //Standard Export User Tasks tasks = tasks.Union(GetTasks(aryaDc, taskDc, currUser, Group.StandardExportUserGroup, exportJobTypes, true)); //Custom Export User Tasks tasks = tasks.Union(GetTasks(aryaDc, taskDc, currUser, Group.CustomExportUserGroup, new[] { typeof(CustomExportWorker).Name }, true)); } if (!clearAllFilters) { Guid selectedProject, selectedUser; if (Guid.TryParse(DdlProjects.SelectedValue, out selectedProject)) { tasks = tasks.Where(task => task.ProjectID == selectedProject); } if (Guid.TryParse(DdlSubmittedBy.SelectedValue, out selectedUser)) { tasks = tasks.Where(task => task.SubmittedBy == selectedUser); } var selectedJobType = DdlJobType.SelectedValue; if (!string.IsNullOrWhiteSpace(selectedJobType) && selectedJobType != "ALL") { tasks = tasks.Where(task => task.JobType == DdlJobType.SelectedValue); } var selectedStatus = DdlStatus.SelectedValue; if (!string.IsNullOrWhiteSpace(selectedStatus) && selectedStatus != "ALL") { tasks = tasks.Where(task => task.Status == DdlStatus.SelectedValue); } } var allTasks = tasks.OrderByDescending(task => task.SubmittedOn).Take(100).ToList(); var distinctUserProjects = allTasks.Select(t => t.SubmittedBy + "|" + t.ProjectID).Distinct().ToList(); var userProjects = (from up in aryaDc.UserProjects //from task in tasks.ToList() //where task.SubmittedBy == up.UserID && task.ProjectID == up.ProjectID where distinctUserProjects.Contains(up.UserID + "|" + up.ProjectID) select new { up.User, up.Project }).ToList(); var visibleTasks = from task in allTasks from up in userProjects where up.Project.ID == task.ProjectID && up.User.ID == task.SubmittedBy let project = up.Project let user = up.User let state = WorkerBase.GetFriendlyWorkerState( (WorkerState)Enum.Parse(typeof(WorkerState), task.Status)) orderby task.SubmittedOn descending select new { task.ID, task.ProjectID, ProjectName = project.DisplayName, Type = task.DisplayJobType, task.JobType, task.Description, task.Status, FriendlyStatus = state, user.FullName, task.SubmittedBy, task.SubmittedOn }; if (sortExpression != string.Empty) { visibleTasks = LinqExtensions.ApplyOrder(visibleTasks, sortExpression, sortOrder == "asc" ? "OrderBy" : "OrderByDescending"); } var visibleTaskList = visibleTasks.Distinct().ToList(); GvStatus.DataSource = visibleTaskList; GvStatus.DataBind(); if (visibleTaskList.Count == 0) { return; } if (!Page.IsPostBack) { var projects = userProjects.Select( up => new DropDownListItem { Text = up.Project.DisplayName, Value = up.Project.ID.ToString() }) .Distinct(new KeyEqualityComparer <DropDownListItem>(item => item.Value)) .OrderBy(item => item.Text) .ToList(); Session["projects"] = projects; var users = userProjects.Select( up => new DropDownListItem { Text = up.User.FullName, Value = up.User.ID.ToString() }) .Distinct(new KeyEqualityComparer <DropDownListItem>(item => item.Value)) .OrderBy(item => item.Text) .ToList(); Session["users"] = users; var jobTypes = allTasks.Select( task => new DropDownListItem { Text = task.DisplayJobType, Value = task.JobType }) .Distinct(new KeyEqualityComparer <DropDownListItem>(item => item.Value)) .OrderBy(item => item.Text) .ToList(); Session["jobTypes"] = jobTypes; var statuses = allTasks.Select(task => new DropDownListItem { Text = task.Status, Value = task.Status }) .Distinct(new KeyEqualityComparer <DropDownListItem>(item => item.Value)) .OrderBy(item => item.Text) .ToList(); Session["statuses"] = statuses; } var prjs = Session["projects"] as List <DropDownListItem> ?? new List <DropDownListItem>(); var visibleProjects = prjs.Where(prj => visibleTaskList.Any(task => task.ProjectID.ToString() == prj.Value)).ToList(); visibleProjects.Insert(visibleProjects.Count > 1 ? 0 : 1, new DropDownListItem { Text = "ALL", Value = "ALL" }); visibleProjects.Add(new DropDownListItem { Text = "-----", Value = "ALL" }); visibleProjects.AddRange(prjs.Where(prj => !visibleProjects.Contains(prj))); DdlProjects.DataSource = visibleProjects; DdlProjects.DataBind(); var usrs = Session["users"] as List <DropDownListItem> ?? new List <DropDownListItem>(); var visibleusers = usrs.Where(usr => visibleTaskList.Any(task => task.SubmittedBy.ToString() == usr.Value)) .ToList(); visibleusers.Insert(visibleusers.Count > 1 ? 0 : 1, new DropDownListItem { Text = "ALL", Value = "ALL" }); visibleusers.Add(new DropDownListItem { Text = "-----", Value = "ALL" }); visibleusers.AddRange(usrs.Where(usr => !visibleusers.Contains(usr))); DdlSubmittedBy.DataSource = visibleusers; DdlSubmittedBy.DataBind(); var jbts = Session["jobTypes"] as List <DropDownListItem> ?? new List <DropDownListItem>(); var visiblejobTypes = jbts.Where(jbt => visibleTaskList.Any(task => task.JobType == jbt.Value)).ToList(); visiblejobTypes.Insert(visiblejobTypes.Count > 1 ? 0 : 1, new DropDownListItem { Text = "ALL", Value = "ALL" }); visiblejobTypes.Add(new DropDownListItem { Text = "-----", Value = "ALL" }); visiblejobTypes.AddRange(jbts.Where(jbt => !visiblejobTypes.Contains(jbt))); DdlJobType.DataSource = visiblejobTypes; DdlJobType.DataBind(); var stus = Session["statuses"] as List <DropDownListItem> ?? new List <DropDownListItem>(); var visiblestatuses = stus.Where(stu => visibleTaskList.Any(task => task.Status == stu.Value)).ToList(); visiblestatuses.Insert(visiblestatuses.Count > 1 ? 0 : 1, new DropDownListItem { Text = "ALL", Value = "ALL" }); visiblestatuses.Add(new DropDownListItem { Text = "-----", Value = "ALL" }); visiblestatuses.AddRange(stus.Where(stu => !visiblestatuses.Contains(stu))); DdlStatus.DataSource = visiblestatuses; DdlStatus.DataBind(); } } }
protected void Traerdatos(string Prmtr, string Accion) { Idioma = (DataTable)ViewState["TablaIdioma"]; try { if (Accion.Equals("UPD")) { Cnx.SelecBD(); using (SqlConnection Cnx2 = new SqlConnection(Cnx.GetConex())) { Cnx2.Open(); using (SqlCommand SC = new SqlCommand("EXEC SP_PANTALLA_OT_Cerradas 4,@Prmtr,'','','',0,0,@Idm,@ICC,'01-1-2009','01-01-1900','01-01-1900'", Cnx2)) { SC.Parameters.AddWithValue("@Prmtr", Prmtr); SC.Parameters.AddWithValue("@Idm", Session["77IDM"]); SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]); using (SqlDataAdapter SDA = new SqlDataAdapter()) { using (DataSet DSTPs = new DataSet()) { SDA.SelectCommand = SC; SDA.Fill(DSTPs); DSTPs.Tables[0].TableName = "Datos"; DSTPs.Tables[1].TableName = "Estado"; DSTPs.Tables[2].TableName = "OTAbiertas"; DSTPs.Tables[3].TableName = "DescPasos"; ViewState["DSTPs"] = DSTPs; } } } } } DSTPs = (DataSet)ViewState["DSTPs"]; if (DSTPs.Tables[0].Rows.Count > 0) //Datos { TxtCodOT.Text = HttpUtility.HtmlDecode(DSTPs.Tables[0].Rows[0]["CodOT"].ToString().Trim()); TxtCodigoOT.Text = HttpUtility.HtmlDecode(DSTPs.Tables[0].Rows[0]["CodigoOT"].ToString().Trim()); TxtAplica.Text = HttpUtility.HtmlDecode(DSTPs.Tables[0].Rows[0]["Aplicabilidad"].ToString().Trim()); DdlStatus.Text = HttpUtility.HtmlDecode(DSTPs.Tables[0].Rows[0]["CodEstOrdTrab1"].ToString().Trim()); ViewState["EstadoAnt"] = DdlStatus.Text.Trim(); CkbCancel.Checked = Convert.ToBoolean(DSTPs.Tables[0].Rows[0]["CancelOT"].ToString()); BindDPasos(TxtCodOT.Text.Trim()); } if (CkbCancel.Checked == true) { DdlStatus.Enabled = false; } else { DdlStatus.Enabled = true; } DdlStatus.DataSource = DSTPs.Tables[1]; DdlStatus.DataTextField = "Descripcion"; DdlStatus.DataValueField = "Codigo"; DdlStatus.DataBind(); if (DSTPs.Tables[2].Rows.Count > 0) { GrdOtPendCerrar.DataSource = DSTPs.Tables[2]; GrdOtPendCerrar.DataBind(); } //OT abiertas else { GrdOtPendCerrar.DataSource = null; GrdOtPendCerrar.DataBind(); } } catch (Exception Ex) { string VbMEns = Ex.ToString().Trim().Substring(1, 50); DataRow[] Result = Idioma.Select("Objeto= 'MensIncovCons'"); foreach (DataRow row in Result) { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true); } // } }