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);
} //
}
}
