protected void _submitForm_Click(object sender, EventArgs e) { int requestID; var sendEmail = true; try { List<RequestData> newRequestDataList = RequestFormRequestData(_requestForm); if (BrandNewRequest()) { var xmlInput = RequestData.ToXml(newRequestDataList); ADUserDetail detail = Apollo.AIM.SNAP.CA.DirectoryServices.GetUserByLoginName(_requestorLoginId.Text); using (var db = new SNAPDatabaseDataContext()) { requestID = db.usp_insert_request_xml(xmlInput, SnapSession.CurrentUser.LoginId, _requestorLoginId.Text, _requestorId.Text, detail.Title, _managerLoginId.Text, _managerName.Text); if (requestID > 0) { SnapSession.SelectedRequestId = requestID.ToString(); SnapSession.UseSelectedRequestId = true; } else { Logger.Fatal("SNAP: Request Form - Submit failure", "Unknown Error"); sendEmail = false; } } } else { requestID = System.Convert.ToInt32(SnapSession.SelectedRequestId); updateRequestUsrInfo(requestID, SnapSession.CurrentUser.LoginId, _requestorLoginId.Text, _requestorId.Text, _managerLoginId.Text, _managerName.Text); RequestData.UpdateRequestData(newRequestDataList, _requestFormData); var accessReq = new AccessRequest(requestID); if (!accessReq.RequestChanged().Success) { sendEmail = false; } } if (sendEmail) { if (SnapSession.CurrentUser.LoginId != _requestorLoginId.Text) { Email.SendTaskEmail(EmailTaskType.ProxyForAffectedEndUser, SnapSession.CurrentUser.LoginId + "@apollogrp.edu", SnapSession.CurrentUser.FullName, requestID, _requestorId.Text); } Email.SendTaskEmail(EmailTaskType.AccessTeamAcknowledge, ConfigurationManager.AppSettings["AIM-DG"], null, requestID, _requestorId.Text); Email.SendTaskEmail(EmailTaskType.UpdateRequester, _requestorLoginId.Text + "@apollogrp.edu", _requestorId.Text, requestID, _requestorId.Text, WorkflowState.Pending_Acknowledgement, null); // TODO: UserLoginId concatenates with @apollogrp, but that may not be the addy. } } catch (Exception ex) { Logger.Fatal("RequestForm - _submitForm_Click, Message:" + ex.Message + ", StackTrace: " + ex.StackTrace); } WebUtilities.Redirect(PageNames.USER_VIEW); }
public void EXEC_usp_open_request_tab() { using (var db = new SNAPDatabaseDataContext()) { var req = db.SNAP_Requests.Single(x => x.submittedBy == "UnitTester"); var accessReq = new AccessRequest(req.pkId); accessReq.Ack(); } using (var db = new SNAPDatabaseDataContext()) { var req = db.SNAP_Requests.Single(x => x.submittedBy == "UnitTester"); Assert.IsTrue(req.statusEnum == (byte)RequestState.Pending); var accessReq = new AccessRequest(req.pkId); accessReq.RequestToChange("TEST"); } usp_open_request_tabResult t = new usp_open_request_tabResult(); t.requestId = 0; t.userId = "test"; t.userDisplayName = "test"; t.userTitle = "test"; t.submittedBy = "test"; t.managerUserId = "test"; t.managerDisplayName = "test"; t.statusEnum = 0; t.isChanged = false; t.ticketNumber = "test"; t.fieldId = 0; t.fieldLabel = "test"; t.fieldText = "ttest"; t.modifiedDate = DateTime.Now; t.createdDate = DateTime.Now; using (var db = new SNAPDatabaseDataContext()) { var req = db.SNAP_Requests.Single(x => x.submittedBy == "UnitTester"); Assert.IsTrue(req.statusEnum == (byte)RequestState.Change_Requested); var test = db.usp_open_request_tab(req.userId, req.pkId).First(); Assert.IsTrue(test.requestId > 0); Console.WriteLine(test.requestId); Console.WriteLine(test.userId); Console.WriteLine(test.userDisplayName); Console.WriteLine(test.userTitle); Console.WriteLine(test.submittedBy); Console.WriteLine(test.managerUserId); Console.WriteLine(test.managerDisplayName); Console.WriteLine(test.statusEnum); Console.WriteLine(test.isChanged); Console.WriteLine(test.ticketNumber); Console.WriteLine(test.fieldId); Console.WriteLine(test.fieldLabel); Console.WriteLine(test.fieldText); Console.WriteLine(test.modifiedDate); Console.WriteLine(test.createdDate); } }
public static int AccessTeamCount() { using (var db = new SNAPDatabaseDataContext()) { int result = db.SNAP_Requests .Where(o => o.statusEnum == 0 || o.statusEnum == 1 || o.statusEnum == 2) .Select(s => s.statusEnum) .Count(); return result; } }
public static WebMethodResponse ApproverActions(int requestId, WorkflowAction action, string comments) { var currentUsrId = SnapSession.CurrentUser.DistributionGroup != null ? SnapSession.CurrentUser.DistributionGroup : SnapSession.CurrentUser.LoginId; int wfId = 0; using (var db = new SNAPDatabaseDataContext()) { wfId = db.GetActiveWorkflowId(requestId, currentUsrId); if (wfId == 0) return new WebMethodResponse(false, "Approver Action Failed", "Approver has nothing to approve"); } var accessReq = new AccessRequest(requestId); comments = comments.FromJSONStringToObj<string>(); return accessReq.WorkflowAck(wfId, action, comments); }
public static int ApprovalCount(string[] userIds) { using (var db = new SNAPDatabaseDataContext()) { int result = (from sr in db.SNAP_Requests join sw in db.SNAP_Workflows on sr.pkId equals sw.requestId join sws in db.SNAP_Workflow_States on sw.pkId equals sws.workflowId join sa in db.SNAP_Actors on sw.actorId equals sa.pkId where userIds.Contains(sa.userId) && sws.workflowStatusEnum == 7 && sws.completedDate == null && sr.statusEnum == 2 select new { sr.pkId }).GroupBy(p => p.pkId).Count(); return result; } }
static void Main(string[] args) { Console.WriteLine("Set due date for request to fire the email nag ..."); Console.WriteLine("What is your intervals(in days):"); var interval = Convert.ToInt16(Console.ReadLine()); Console.WriteLine("What is your max over due (in days) to close abandoned the request:"); var maxOverDue = Convert.ToInt16(Console.ReadLine()); Console.WriteLine("Due on 1 - Tomorrow, 2 - Now (for dev mostly)"); var dueDateOption = Convert.ToInt16(Console.ReadLine()); var answer = "Y"; while (answer.Contains("Y")) { Console.WriteLine("Enter your request id which has approver waiting to approve the request"); var requestId = Console.ReadLine(); using (var db = new SNAPDatabaseDataContext()) { var req = db.SNAP_Requests.Single(x => (x.pkId == Convert.ToInt32(requestId) && x.statusEnum != (byte)RequestState.Closed) ); Console.WriteLine("req id: " + req.pkId + " - " + req.userDisplayName); foreach(var wf in req.SNAP_Workflows) { var latestState = wf.SNAP_Workflow_States.OrderByDescending(s => s.pkId).First(); if (canChangeDueDate(latestState)) { Console.WriteLine(wf.SNAP_Actor.displayName + "... " + Enum.GetName(typeof(WorkflowState), latestState.workflowStatusEnum)); var newDueDate = askUserToSelectDueDate(interval, dueDateOption, maxOverDue); latestState.dueDate = newDueDate; db.SubmitChanges(); } } } Console.WriteLine("Press 'y' to continue .... any key to quit ..."); answer = Console.ReadLine().ToUpper(); } Console.WriteLine("Have a good day! Press enter ...."); Console.ReadKey(); }
public static DataTable GetAllTrackingData(string requestId) { DataTable table = BuildEmptyTrackingBladeTable(); using (var db = new SNAPDatabaseDataContext()) { var tracking = from wf in db.SNAP_Workflows where wf.requestId == Convert.ToInt32(requestId) join ws in db.SNAP_Workflow_States on wf.pkId equals ws.workflowId join a in db.SNAP_Actors on wf.actorId equals a.pkId join ag in db.SNAP_Actor_Groups on a.actor_groupId equals ag.pkId orderby ws.workflowId ascending, ws.pkId descending select new { display_name = a.displayName, workflow_status = ws.workflowStatusEnum, workflow_due_date = ws.dueDate, workflow_completed_date = ws.completedDate, workflow_pkid = ws.workflowId, actor_group_type = ag.actorGroupType }; foreach (var trackingRow in tracking) { table.Rows.Add ( trackingRow.display_name , trackingRow.workflow_status , trackingRow.workflow_due_date , trackingRow.workflow_completed_date , trackingRow.workflow_pkid , trackingRow.actor_group_type ); } } return table; // datatable > rows > Non-Public members > list > Results View }
private bool IsGroupMember() { try { using (var db = new SNAPDatabaseDataContext()) { int result = db.SNAP_Actors .Where(w => w.isGroup == true && w.isActive == true && MemberOf.Contains(w.userId)) .Select(s => s.pkId) .Count(); if (result > 0) { return true; } else { return false; } } } catch (Exception ex) { Logger.Error("SnapUser - IsGroupMember, Message:" + ex.Message + ", StackTrace: " + ex.StackTrace); } return false; }
public void Init() { using (var db = new SNAPDatabaseDataContext()) { var actors = db.SNAP_Actors.Where(a => a.SNAP_Actor_Group.actorGroupType == TEAMAPPROVALGROUP).ToList(); teamApprovalActorId = actors[0].pkId; teamApprovalUserId = actors[0].userId; //actors = db.SNAP_Actors.Where(a => a.actor_groupId == TECHNICALAPPROVALGROUP).ToList(); actors = db.SNAP_Actors.Where(a => a.SNAP_Actor_Group.actorGroupType == TECHNICALAPPROVALGROUP).ToList(); windowsServerActorId = actors[0].pkId; WindowsServerUserId = actors[0].userId; networkShareActorId = actors[1].pkId; networkShareUserId = actors[1].userId; databaseActorId = actors[2].pkId; databaseUserId = actors[2].userId; //actors = db.SNAP_Actors.Where(a => a.actor_groupId == MANAGERGROUP).ToList(); actors = db.SNAP_Actors.Where(a => a.SNAP_Actor_Group.actorGroupType == MANAGERGROUP).ToList(); if (actors.Count == 1) { db.SNAP_Actors.InsertOnSubmit(new SNAP_Actor() { actor_groupId = actors[0].actor_groupId, userId = "pxlee", displayName = "Pong Lee", emailAddress = "*****@*****.**", isActive = true, isDefault = false }); db.SubmitChanges(); actors = db.SNAP_Actors.Where(a => a.SNAP_Actor_Group.actorGroupType == MANAGERGROUP).ToList(); } managerActorId = actors[0].pkId; managerUserId = actors[0].userId; secondManagerActorId = actors[1].pkId; secondMagerUserId = actors[1].userId; } }
public void ShouldOk() { using(var db = new SNAPDatabaseDataContext()) { DateTime current = DateTime.Parse("3/31/2010 1:00:00 PM"); for (int i = 1; i < 20; i++) { Console.WriteLine(db.udf_get_next_business_day(current, i)); } } }
public void ShouldReturnNoRequestData() { using (var db = new SNAPDatabaseDataContext()) { var maxRequestId = db.SNAP_Requests.Max(x => x.pkId); var data = db.RetrieveRequestUserText(++maxRequestId); Assert.IsTrue(data.Count() == 0); } }
public void SetUp() { cleanUp(); using (var db = new SNAPDatabaseDataContext()) { List<RequestData> requestDataList = new List<RequestData>() { new RequestData() {FormId = "2", UserText = "Request Access 2"}, new RequestData() {FormId = "3", UserText = "Request Access 3"}, new RequestData() {FormId = "4", UserText = "Request Access 4"}, new RequestData() {FormId = "5", UserText = "Request Access 5"} }; var xmlInput = RequestData.ToXml(requestDataList); db.usp_insert_request_xml(xmlInput, "UnitTester", "pxlee", "Pong Lee", "Programmer", "gjbelang", "Greg Belanger"); } using (var db = new SNAPDatabaseDataContext()) { var req = db.SNAP_Requests.Single(x => x.submittedBy == "UnitTester"); db.SNAP_Request_Comments.InsertOnSubmit(new SNAP_Request_Comment() { requestId = req.pkId, commentText = "Test Comment", commentTypeEnum = (byte)CommentsType.Acknowledged, createdDate = DateTime.Now }); db.SubmitChanges(); } }
public void ShouldbeAbleToCallUDF() { using (var db = new SNAPDatabaseDataContext()) { var newDate = db.udf_get_next_business_day(DateTime.Now, 10); Assert.IsTrue(newDate != null); } }
public static string GetDetails(int requestId) { Role userRole = SnapSession.CurrentUser.CurrentRole; bool includeADManager = false; int[] commentFilter; switch (userRole) { case Role.AccessTeam: case Role.SuperUser: commentFilter = new int[]{(int)CommentsType.Access_Notes_Requestor, (int)CommentsType.Access_Notes_ApprovingManager, (int)CommentsType.Access_Notes_AccessTeam}; includeADManager = true; break; case Role.ApprovingManager: commentFilter = new int[]{(int)CommentsType.Access_Notes_Requestor, (int)CommentsType.Access_Notes_ApprovingManager}; break; case Role.Requestor: default: commentFilter = new int[] { (int)CommentsType.Access_Notes_Requestor }; break; } using (var db = new SNAPDatabaseDataContext()) { var textIds = from a in db.SNAP_Access_User_Texts where a.requestId == requestId group a by new { a.access_details_formId } into grp select new { ID = grp.Max(s => s.pkId) }; List<int> currentTextIds = new List<int>(); foreach (var id in textIds) { currentTextIds.Add(id.ID); } var details = from r in db.SNAP_Requests join ut in db.SNAP_Access_User_Texts on r.pkId equals ut.requestId join adf in db.SNAP_Access_Details_Forms on ut.access_details_formId equals adf.pkId where r.pkId == requestId && adf.isActive == true && currentTextIds.Contains(ut.pkId) orderby adf.pkId ascending select new { Title = r.userTitle, Manager = r.managerDisplayName, ADManager = r.managerUserId, Requestor = r.submittedBy, UserId = r.userId, Label = adf.label, Text = ut.userText }; var comments = from r in db.SNAP_Requests join rc in db.SNAP_Request_Comments on r.pkId equals rc.requestId where r.pkId == requestId && commentFilter.Contains(rc.commentTypeEnum) orderby rc.createdDate descending select new { Audience = MakeFriendlyCommentAudience((CommentsType)rc.commentTypeEnum), CreatedDate = rc.createdDate, Text = rc.commentText }; if (details != null) { RequestDetails newDetails = new RequestDetails(); List<RequestFormField> newForm = new List<RequestFormField>(); string ADManager = String.Empty; foreach (var detail in details) { if (ADManager == String.Empty) { ADManager = (includeADManager ? CompareManagerName(detail.UserId, detail.ADManager) : null); } newDetails.Title = detail.Title; newDetails.Manager = detail.Manager; newDetails.ADManager = ADManager; newDetails.Requestor = detail.Requestor; newDetails.SearchLinkUrl= Model.Utilities.WebRootUrl + Model.PageNames.SEARCH + ".aspx?requestId=" + requestId.ToString(); RequestFormField newField = new RequestFormField(); newField.Label = detail.Label; newField.Text = detail.Text; newForm.Add(newField); } newDetails.Details = newForm; if (comments != null) { List<RequestComments> newComments = new List<RequestComments>(); foreach (var comment in comments) { RequestComments newComment = new RequestComments(); newComment.Audience = comment.Audience; newComment.CreatedDate = comment.CreatedDate.ToString("MMM d, yyyy") + " at " + comment.CreatedDate.ToString("h:mm tt"); newComment.Text = comment.Text; newComments.Add(newComment); } newDetails.Comments = newComments; } DataContractJsonSerializer serializer = new DataContractJsonSerializer(newDetails.GetType()); using (MemoryStream ms = new MemoryStream()) { serializer.WriteObject(ms, newDetails); string retVal = Encoding.Default.GetString(ms.ToArray()); return retVal; } } return string.Empty; } }
public void RUD_SNAP_Workflow_State_Type() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Workflow_State_Types.InsertOnSubmit(new SNAP_Workflow_State_Type() { pkId = 20, typeName = "TESTTYPE" }); db.SubmitChanges(); var test1 = db.SNAP_Workflow_State_Types.Where(t=>t.pkId==20).ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Workflow_State_Types.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Workflow_State_Types.Where(t => t.pkId == 20).ToList(); Assert.IsTrue(test2.Count == 0); } }
public static List<BuilderActor> GetRequestActors(int requestId) { List<BuilderActor> actorList = new List<BuilderActor>(); using (var db = new SNAPDatabaseDataContext()) { var query = from a in db.SNAP_Actors join sw in db.SNAP_Workflows on a.pkId equals sw.actorId join sws in db.SNAP_Workflow_States on sw.pkId equals sws.workflowId where sw.requestId == requestId group sw by new { a.userId, sw.requestId, sw.actorId } into wfGroup select new { ActorId = wfGroup.Key.actorId, UserId = wfGroup.Key.userId, WorkflowId = wfGroup.Max(sw => sw.pkId) }; foreach (var actor in query) { BuilderActor newActor = new BuilderActor(); newActor.ActorId = actor.ActorId; newActor.UserId = actor.UserId; newActor.WorkflowState = (WorkflowState)ApprovalWorkflow.GetWorkflowState(actor.WorkflowId); actorList.Add(newActor); } } return actorList; }
public static void UpdateRequestData(List<RequestData> newRequestList, List<usp_open_request_tabResult> requestData) { var result = UpdatedRequestDataList(newRequestList, requestData); if (result.Count > 0) { using (var db = new SNAPDatabaseDataContext()) { var reqId = requestData[0].requestId; foreach(var data in result) { var accessUserText = new SNAP_Access_User_Text() { requestId = reqId, access_details_formId = Convert.ToInt16(data.FormId), userText = data.UserText, modifiedDate = DateTime.Now }; db.SNAP_Access_User_Texts.InsertOnSubmit(accessUserText); } db.SubmitChanges(); } } }
public void RUD_SNAP_Actor_Group_Type() { using (var db = new SNAPDatabaseDataContext()) { // db.SNAP_Actor_Group_Types.InsertOnSubmit(new SNAP_Actor_Group_Type() // { // pkId = 20, // typeName = "TESTTYPE" // }); // db.SubmitChanges(); SNAP_Actor_Group_Type test = new SNAP_Actor_Group_Type(); test.pkId = 0; test.typeName = "Test Type"; var test1 = db.SNAP_Actor_Group_Types.Where(t => t.pkId == 1).ToList(); Assert.IsTrue(test1.Count > 0); // foreach (var type in test1) // { // db.SNAP_Actor_Group_Types.DeleteOnSubmit(type); // } // db.SubmitChanges(); // var test2 = db.SNAP_Actor_Group_Types.Where(t => t.pkId == 20).ToList(); // Assert.IsTrue(test2.Count == 0); } }
public void ShouldReturnRequestData() { using (var db = new SNAPDatabaseDataContext()) { var maxRequestId = db.SNAP_Requests.Max(x => x.pkId); var requestTexts = db.RetrieveRequestUserText(maxRequestId); foreach (var text in requestTexts) { Console.WriteLine(text.userText); } Assert.IsTrue(requestTexts.Count() > 0); } }
public void RUD_SNAP_Actor_Group() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Actor_Groups.InsertOnSubmit(new SNAP_Actor_Group() { groupName = "Test Group", description = "Test Group Description", actorGroupType = 0, isActive = false, isLargeGroup = false }); db.SubmitChanges(); var test1 = db.SNAP_Actor_Groups.Where(t => t.groupName == "Test Group").ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Actor_Groups.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Actor_Groups.Where(t => t.groupName == "Test Group").ToList(); Assert.IsTrue(test2.Count == 0); } }
public void RUD_SNAP_Actor() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Actors.InsertOnSubmit(new SNAP_Actor() { userId = "testuser", displayName = "Test User", emailAddress = "*****@*****.**", isActive = false, isDefault = false, isGroup = false, actor_groupId = 0 }); db.SubmitChanges(); var test1 = db.SNAP_Actors.Where(t => t.userId == "testuser").ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Actors.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Actors.Where(t => t.userId == "testuser").ToList(); Assert.IsTrue(test2.Count == 0); } }
public void RUD_SNAP_Access_User_Text() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Access_User_Texts.InsertOnSubmit(new SNAP_Access_User_Text() { requestId = 0, access_details_formId = 20, userText = "For unit testing", modifiedDate = DateTime.Now }); db.SubmitChanges(); var test1 = db.SNAP_Access_User_Texts.Where(t => t.requestId == 0).ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Access_User_Texts.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Access_User_Texts.Where(t => t.requestId == 0).ToList(); Assert.IsTrue(test2.Count == 0); } }
public void RUD_SNAP_Access_Details_Form() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Access_Details_Forms.InsertOnSubmit(new SNAP_Access_Details_Form() { parentId = 20, label = "Test Field", description = "For Unit Testing", isActive = false, isRequired = false }); db.SubmitChanges(); var test1 = db.SNAP_Access_Details_Forms.Where(t => t.label == "Test Field").ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Access_Details_Forms.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Access_Details_Forms.Where(t => t.label == "Test Field").ToList(); Assert.IsTrue(test2.Count == 0); } }
public void RUD_Request_Comment() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Request_Comments.InsertOnSubmit(new SNAP_Request_Comment() { requestId = 0, commentText = "Test Comment", commentTypeEnum = 0, createdDate = DateTime.Now }); db.SubmitChanges(); var test1 = db.SNAP_Request_Comments.Where(t => t.commentText == "Test Comment").ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Request_Comments.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Request_Comments.Where(t => t.commentText == "Test Comment").ToList(); Assert.IsTrue(test2.Count == 0); } }
private void cleanUp() { using (var db = new SNAPDatabaseDataContext()) { var reqs = db.SNAP_Requests.Where(x => x.submittedBy == "UnitTester").ToList(); foreach (var r in reqs) { var wfs = db.SNAP_Workflows.Where(x => x.requestId == r.pkId).ToList(); foreach (SNAP_Workflow wf in wfs) { var states = db.SNAP_Workflow_States.Where(x => x.workflowId == wf.pkId); db.SNAP_Workflow_States.DeleteAllOnSubmit(states); var comments = db.SNAP_Workflow_Comments.Where(c => c.workflowId == wf.pkId); db.SNAP_Workflow_Comments.DeleteAllOnSubmit(comments); } db.SNAP_Workflows.DeleteAllOnSubmit(wfs); var uts = db.SNAP_Access_User_Texts.Where(x => x.requestId == r.pkId); db.SNAP_Access_User_Texts.DeleteAllOnSubmit(uts); db.SNAP_Requests.DeleteOnSubmit(r); var reqComments = db.SNAP_Request_Comments.Where(c => c.requestId == r.pkId); db.SNAP_Request_Comments.DeleteAllOnSubmit(reqComments); } db.SubmitChanges(); } }
public void RUD_SNAP_Weekends_and_Holiday() { using (var db = new SNAPDatabaseDataContext()) { //db.SNAP_Weekends_and_Holidays.InsertOnSubmit(new SNAP_Weekends_and_Holiday() //{ // dayName = "TESTDAY", // dayOfWeekDate = DateTime.Now //}); //db.SubmitChanges(); SNAP_Weekends_and_Holiday test = new SNAP_Weekends_and_Holiday(); test.dayName = "MON"; test.dayOfWeekDate = DateTime.Now; var test1 = db.SNAP_Weekends_and_Holidays.Where(t => t.dayName == test.dayName).ToList(); Assert.IsTrue(test1.Count > 0); //foreach (var row in test1) //{ // db.SNAP_Weekends_and_Holidays.DeleteOnSubmit(row); //} //db.SubmitChanges(); //var test2 = db.SNAP_Weekends_and_Holidays.Where(t => t.dayName == "TESTDAY").ToList(); //Assert.IsTrue(test2.Count == 0); } }
/* static DataTable GetTable() { DataTable table = new DataTable(); table.Columns.Add("pkId", typeof(int)); table.Columns.Add("parentId", typeof(int)); table.Columns.Add("label", typeof(string)); table.Columns.Add("description", typeof(string)); table.Columns.Add("isActive", typeof(bool)); table.Columns.Add("isRequired", typeof(bool)); table.Rows.Add(2, 1, "Windows Servers", "<p>Enter the <strong>exact</strong> servers you need access to...</p>", true, true); table.Rows.Add(3, 1, "Linux/Unix Servers", "<p>Enter the exact...</p>", true, true); table.Rows.Add(4, 1, "Network Shares", "<p>Enter the exact...</p>", true, true); return table; } */ private IEnumerable<SNAP_Access_Details_Form> loadDetailRequestFormData() { var db = new SNAPDatabaseDataContext(); var formDetails = from form in db.SNAP_Access_Details_Forms where (form.parentId == 1) && (form.isActive == true) select form; return formDetails; }
public void RUD_SNAP_Workflow() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Workflows.InsertOnSubmit(new SNAP_Workflow() { actorId = 0, requestId = 0 }); db.SubmitChanges(); var test1 = db.SNAP_Workflows.Where(t => t.requestId == 0 && t.actorId == 0).ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Workflows.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Workflows.Where(t => t.requestId == 0 && t.actorId == 0).ToList(); Assert.IsTrue(test2.Count == 0); } }
public void RUD_SNAP_Request() { using (var db = new SNAPDatabaseDataContext()) { db.SNAP_Requests.InsertOnSubmit(new SNAP_Request() { userId = "testuser", userTitle = "Unit Tester", userDisplayName = "Test Account", managerUserId = "manager", managerDisplayName = "Test Manager", submittedBy = "submitter", isChanged = false, statusEnum = 0, createdDate = DateTime.Now, lastModifiedDate = DateTime.Now, ticketNumber = "0000" }); db.SubmitChanges(); var test1 = db.SNAP_Requests.Where(t => t.userId == "testuser").ToList(); Assert.IsTrue(test1.Count > 0); foreach (var row in test1) { db.SNAP_Requests.DeleteOnSubmit(row); } db.SubmitChanges(); var test2 = db.SNAP_Requests.Where(t => t.userId == "testuser").ToList(); Assert.IsTrue(test2.Count == 0); } }
public static string GetAccessTeamFilter() { string filter = ""; List<int> openEnums = new List<int>(); openEnums.Add((int)RequestState.Open); openEnums.Add((int)RequestState.Pending); openEnums.Add((int)RequestState.Change_Requested); RequestFilter newFilter = new RequestFilter(); List<Filter> newFilters = new List<Filter>(); Filter PendingAcknowledgementFilter = new Filter(); Filter PendingWorkflowFilter = new Filter(); Filter PendingTicketFilter = new Filter(); Filter PendingProvisioningFilter = new Filter(); Filter ChangeRequestedFilter = new Filter(); Filter InWorkflowFilter = new Filter(); List<int> PendingAcknowledgementList = new List<int>(); List<int> PendingWorkflowList = new List<int>(); List<int> PendingTicketList = new List<int>(); List<int> PendingProvisioningList = new List<int>(); List<int> ChangeRequestedList = new List<int>(); List<int> InWorkflowList = new List<int>(); using (var db = new SNAPDatabaseDataContext()) { var filterCounts = from r in db.SNAP_Requests join w in db.SNAP_Workflows on r.pkId equals w.requestId join ws in db.SNAP_Workflow_States on w.pkId equals ws.workflowId join a in db.SNAP_Actors on w.actorId equals a.pkId where a.pkId == AccessTeamActorId && openEnums.Contains(r.statusEnum) && ws.completedDate == null group r by new { r.pkId, r.ticketNumber, ws.workflowStatusEnum } into grp select new { requestId = grp.Key.pkId, ticketNumber = grp.Key.ticketNumber, workflowStatusEnum = grp.Key.workflowStatusEnum }; if(filterCounts != null) { foreach(var row in filterCounts) { switch (row.workflowStatusEnum) { case (int)WorkflowState.Pending_Acknowledgement: PendingAcknowledgementList.Add(row.requestId); break; case (int)WorkflowState.Pending_Workflow: PendingWorkflowList.Add(row.requestId); break; case (int)WorkflowState.Approved: case (int)WorkflowState.Pending_Provisioning: if (row.ticketNumber == null) { PendingTicketList.Add(row.requestId); } else { PendingProvisioningList.Add(row.requestId); } break; case (int)WorkflowState.Workflow_Created: InWorkflowList.Add(row.requestId); break; case (int)WorkflowState.Change_Requested: ChangeRequestedList.Add(row.requestId); break; } } PendingAcknowledgementFilter.FilterName = "Ack"; PendingAcknowledgementFilter.RequestIds = PendingAcknowledgementList; PendingWorkflowFilter.FilterName = "WrkFl"; PendingWorkflowFilter.RequestIds = PendingWorkflowList; PendingTicketFilter.FilterName = "Tkt"; PendingTicketFilter.RequestIds = PendingTicketList; PendingProvisioningFilter.FilterName = "Prov"; PendingProvisioningFilter.RequestIds = PendingProvisioningList; ChangeRequestedFilter.FilterName = "Chng Req"; ChangeRequestedFilter.RequestIds = ChangeRequestedList; InWorkflowFilter.FilterName = "In WrkFl"; InWorkflowFilter.RequestIds = InWorkflowList; newFilters.Add(PendingAcknowledgementFilter); newFilters.Add(PendingWorkflowFilter); newFilters.Add(PendingTicketFilter); newFilters.Add(PendingProvisioningFilter); newFilters.Add(ChangeRequestedFilter); newFilters.Add(InWorkflowFilter); newFilter.Filters = newFilters; DataContractJsonSerializer serializer = new DataContractJsonSerializer(newFilter.GetType()); using (MemoryStream ms = new MemoryStream()) { serializer.WriteObject(ms, newFilter); string retVal = Encoding.Default.GetString(ms.ToArray()); filter = retVal; } } } return filter; }