/// <summary>
/// Gets a SPUser object for a given login name
/// </summary>
/// <param name="userLogin">The loginName to look for</param>
/// <returns></returns>
public static SPUser GetUserFromLogin(string userLogin)
{
// TODO: We get a lot of warnings on these, and the Guidewire Service Account is often reflected in SharePoint. This method could use some work. Not critical ATM
SPUser user = null;
if (userLogin != null)
{
try
{
SPUserCollection allUsers = SPContext.Current.Web.AllUsers;
var xml = XDocument.Parse(allUsers.Xml);
var xmlUsers = (from item in xml.Descendants("User")
where (String)item.Attribute("LoginName") == userLogin
select item);
if (xmlUsers.Count <XElement>() > 0) // should only be one, if less than zero user could not be found
{
int userID = (int)xmlUsers.First().Attribute("ID");
user = allUsers.GetByID(userID);
}
else
{
LogError(String.Format("Login {0} could not be located in SharePoint Users", userLogin == null ? "null" : userLogin), ErrorLevel.Warning);
}
}
catch (Exception e)
{
LogError("GetUserFromLogin errored with the exception: " + e.Message);
}
}
return(user);
}
public SPUserInstance GetUserById(int id)
{
var result = m_userCollection.GetByID(id);
return(result == null
? null
: new SPUserInstance(Engine, result));
}
protected void Page_Load(object sender, EventArgs e)
{
/*using (TPP bd = new TPP())
* {
*
* }*/
/*TPP bd = new TPP();
* bd.Materials.Add(new Material()
* {
* Assortment = "erhrh",
* DesignOfStandard = "htdfdh",
* Name = "rth",
* Stamp = "hfhrfr"
* });
* bd.SaveChanges();*/
TPP bd = new TPP();
SPSite site = SPControl.GetContextSite(Context);
SPWeb web = site.OpenWeb();
/*SPListCollection collList = web.Lists;
*
* foreach (var oList in collList)
* {
* Console.WriteLine("Title: {0} Created: {1}", oList., oList.Created.ToString());
* }*/
//SPUser developer = web.Users.GetByID(route.NameOfDeveloper);
//cell4.Text = developer.LoginName;
SPGroupCollection collGroups = web.Groups;
foreach (SPGroup oGroup in collGroups)
{
foreach (SPUser user in oGroup.Users)
{
routeNameOfDeveloper.Items.Add(
new ListItem(user.LoginName, user.ID.ToString()));
routeCardAgreed.Items.Add(
new ListItem(user.LoginName, user.ID.ToString()));
routeCardApproved.Items.Add(
new ListItem(user.LoginName, user.ID.ToString()));
routeCardChecked.Items.Add(
new ListItem(user.LoginName, user.ID.ToString()));
routeCardDeveloper.Items.Add(
new ListItem(user.LoginName, user.ID.ToString()));
routeCardNormController.Items.Add(
new ListItem(user.LoginName, user.ID.ToString()));
}
}
//add materials
foreach (var mat in bd.Materials)
{
//fill dropdowns
technologicalProcessMaterial.Items.Add(
new ListItem(mat.MaterialId.ToString(), mat.MaterialId.ToString()));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = mat.MaterialId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = mat.Assortment;
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = mat.Name;
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = mat.Stamp;
row.Cells.Add(cell4);
TableCell cell5 = new TableCell();
cell5.Text = mat.DesignOfStandard;
row.Cells.Add(cell5);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.Materials.Attach(mat);
lbd.Entry(mat).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell6 = new TableCell();
cell6.Controls.Add(button);
row.Cells.Add(cell6);
materials.Rows.Add(row);
}
//fill Equipment table
foreach (var eqip in bd.Equipments)
{
//add to dropdown
operationEquipment.Items.Add(
new ListItem(eqip.EquipmentId.ToString(), eqip.EquipmentId.ToString()));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = eqip.EquipmentId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = eqip.DetailNumber.ToString();
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = eqip.Name;
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = eqip.Quantity.ToString();
row.Cells.Add(cell4);
TableCell cell5 = new TableCell();
cell5.Text = eqip.Department;
row.Cells.Add(cell5);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.Equipments.Attach(eqip);
lbd.Entry(eqip).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell6 = new TableCell();
cell6.Controls.Add(button);
row.Cells.Add(cell6);
equipments.Rows.Add(row);
}
//add rigging
foreach (var rig in bd.Riggings)
{
//add to dropdowns
operationRigging.Items.Add(
new ListItem(rig.RiggingId.ToString(), rig.RiggingId.ToString()));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = rig.RiggingId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = rig.Name;
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = rig.TypeOfTool;
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = rig.Quantity.ToString();
row.Cells.Add(cell4);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.Riggings.Attach(rig);
lbd.Entry(rig).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell5 = new TableCell();
cell5.Controls.Add(button);
row.Cells.Add(cell5);
riggings.Rows.Add(row);
}
//fill operations table
foreach (var oper in bd.Operations)
{
//add to dropdowns
technologicalProcessOperation.Items.Add(
new ListItem(oper.OperationId.ToString(), oper.OperationId.ToString()));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = oper.OperationId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = oper.Name;
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = oper.Number.ToString();
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = oper.TransitionId.ToString();
row.Cells.Add(cell4);
TableCell cell5 = new TableCell();
cell5.Text = oper.TransitionName;
row.Cells.Add(cell5);
TableCell cell6 = new TableCell();
cell6.Text = oper.EquipmentId.ToString();
row.Cells.Add(cell6);
TableCell cell7 = new TableCell();
cell7.Text = oper.RiggingId.ToString();
row.Cells.Add(cell7);
TableCell cell8 = new TableCell();
cell8.Text = oper.DepartmentNumber.ToString();
row.Cells.Add(cell8);
TableCell cell9 = new TableCell();
cell9.Text = oper.SiteNumber.ToString();
row.Cells.Add(cell9);
TableCell cell10 = new TableCell();
cell10.Text = oper.WorkplaceNumber.ToString();
row.Cells.Add(cell10);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.Operations.Attach(oper);
lbd.Entry(oper).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell11 = new TableCell();
cell11.Controls.Add(button);
row.Cells.Add(cell11);
operations.Rows.Add(row);
}
//add transitions
foreach (var trans in bd.Transitions)
{
//add to dropdowns
operationTransition.Items.Add(
new ListItem(trans.TransitionId.ToString(), trans.TransitionId.ToString()));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = trans.TransitionId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = trans.TransitionNumber.ToString();
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = trans.Keyword;
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = trans.TransitionType;
row.Cells.Add(cell4);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.Transitions.Attach(trans);
lbd.Entry(trans).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell5 = new TableCell();
cell5.Controls.Add(button);
row.Cells.Add(cell5);
transitions.Rows.Add(row);
}
//fill TechnologicalProcesses
foreach (var tp in bd.TechnologicalProcesseses)
{
//add to routes
this.routeTechProc.Items.Add(
new ListItem(tp.TechProcId.ToString(), tp.TechProcId.ToString()));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = tp.TechProcId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = tp.Name;
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = tp.OperationId.ToString();
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
cell4.Text = tp.MaterialId.ToString();
row.Cells.Add(cell4);
TableCell cell5 = new TableCell();
cell5.Text = tp.TypeByExecution;
row.Cells.Add(cell5);
TableCell cell6 = new TableCell();
cell6.Text = tp.ActNumber.ToString();
row.Cells.Add(cell6);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.TechnologicalProcesseses.Attach(tp);
lbd.Entry(tp).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell7 = new TableCell();
cell5.Controls.Add(button);
row.Cells.Add(cell7);
technologicalProcesses.Rows.Add(row);
}
//fill route
foreach (var route in bd.Routes)
{
//add to route card
this.routeCardRoute.Items.Add(
new ListItem(route.RouteId.ToString(), route.RouteId.ToString()));
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = route.RouteId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = route.TechProcId.ToString();
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = route.NameTechProc;
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
SPUserCollection users = web.SiteUsers;
SPUser user = users.GetByID(route.NameOfDeveloper);
//SPUser developer = web.Users.GetByID(route.NameOfDeveloper);
//cell4.Text = developer.LoginName;
//cell4.Text = route.NameOfDeveloper.ToString();
cell4.Text = user.LoginName;
row.Cells.Add(cell4);
TableCell cell5 = new TableCell();
cell5.Text = route.DetailsDesignation;
row.Cells.Add(cell5);
TableCell cell6 = new TableCell();
cell6.Text = route.DetailsName;
row.Cells.Add(cell6);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.Routes.Attach(route);
lbd.Entry(route).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell7 = new TableCell();
cell7.Controls.Add(button);
row.Cells.Add(cell7);
routes.Rows.Add(row);
}
//fill routeCard
foreach (var rc in bd.RouteCars)
{
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = rc.RouteCarId.ToString();
row.Cells.Add(cell1);
TableCell cell2 = new TableCell();
cell2.Text = rc.RouteId.ToString();
row.Cells.Add(cell2);
TableCell cell3 = new TableCell();
cell3.Text = rc.CompanyName;
row.Cells.Add(cell3);
TableCell cell4 = new TableCell();
SPUserCollection users = web.SiteUsers;
SPUser user = users.GetByID(rc.Developer);
//cell4.Text = rc.Developer.ToString();
cell4.Text = user.LoginName;
row.Cells.Add(cell4);
TableCell cell5 = new TableCell();
//cell5.Text = rc.Checked.ToString();
user = users.GetByID(rc.Checked);
cell5.Text = user.LoginName;
row.Cells.Add(cell5);
TableCell cell6 = new TableCell();
//cell6.Text = rc.Agreed.ToString();
user = users.GetByID(rc.Agreed);
cell6.Text = user.LoginName;
row.Cells.Add(cell6);
TableCell cell7 = new TableCell();
//cell7.Text = rc.Approved.ToString();
user = users.GetByID(rc.Approved);
cell7.Text = user.LoginName;
row.Cells.Add(cell7);
TableCell cell8 = new TableCell();
//cell8.Text = rc.NormСontroller.ToString();
user = users.GetByID(rc.NormСontroller);
cell8.Text = user.LoginName;
row.Cells.Add(cell8);
Button button = new Button();
button.Text = "Delete";
button.Click += (s, e1) =>
{
TPP lbd = new TPP();
lbd.RouteCars.Attach(rc);
lbd.Entry(rc).State = System.Data.Entity.EntityState.Deleted;
lbd.SaveChanges();
Response.Redirect(Request.RawUrl);
};
TableCell cell9 = new TableCell();
cell9.Controls.Add(button);
row.Cells.Add(cell9);
routeCards.Rows.Add(row);
}
}