public CurrentUserResponse(JObject j) : base(j) { if(j["Response"] != null) { User = new CurrentUser(j["Response"].Value<JObject>()); } }
public DeleteMessages(CurrentUser user, int roomId) { this._user = user; this._roomId = roomId; this._client = new ChatService.ChatClient("Unisex"); InitializeComponent(); PopulateMyMessages(); }
public ChatroomOptions(CurrentUser user) { InitializeComponent(); this._currentUser = user; this._client = new ChatService.ChatClient("Unisex"); SetComponentsToCorrectState(user); PopulateCurrentOnlineUsersCounter(); _timer = new Timer(); _timer.Interval = 3000; _timer.Tick += RefreshCounter; _timer.Start(); }
bool loadCurrentUser() { if (currentUser != null) throw new Exception("Current user already added"); // nacti uzivatele bool loaded = true; OracleCommand cmd = new OracleCommand(CURRENT_USER_SELECT, conn); OracleDataReader odr = cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow); if (odr.Read()) { currentUser = loadUser(odr, true); } else loaded = false; return loaded; }
private void SetComponentsToCorrectState(CurrentUser user) { labelCurrentUser.Text = _currentUser.UserName; if (user.Gender != "Man") { buttonJoinChatroomMen.Enabled = false; buttonJoinChatroomMen.BackColor = Color.LightGray; pictureBoxChatMan.Enabled = false; } if (user.Gender != "Woman") { buttonJoinChatroomWomen.Enabled = false; buttonJoinChatroomWomen.BackColor = Color.LightGray; pictureBoxChatWoman.Enabled = false; } }
public ChatroomMen(CurrentUser user) { try { InitializeComponent(); textBoxChatroomMen.Text = GlobalMethods.PopulateChatWithMessages(roomID, "Man"); _currentUser = user; _timer = new Timer(); _timer.Interval = 1000; _timer.Tick += pictureBoxRefresh_Click; } catch (FaultException ex) { MessageBox.Show("Service error: " + ex.Message); } catch (Exception ex) { MessageBox.Show("Client error: " + ex.Message); } }
public int SyncFriendsToDatabase(CurrentUser currentUser, long UserId) { return SyncToDatabase(SyncToDatabaseOp.GetFriends, currentUser, UserId); }
public ViewResult SelectCommunity() { UserDbManager.GetInstance().CommunityListByUserLocation(); return(View(CurrentUser.Storage())); }
public async Task <IActionResult> GenerateJobs(int csId, int ssId) { try { CurrentUser cUser = new CurrentUser(HttpContext, _configuration); var sems = (List <AlarmEmailNotificationEntityModel>) await alarmEmailNotificationRepo.GetAlarmEmailNotificationByStatus(csId, ssId, 0, 0, "GenerateJob"); var equipments = (List <AlarmEmailNotificationEntityModel>) await alarmEmailNotificationRepo.GetEquipmentByAlarmEmailNotificationId(csId, ssId, 0, "GenerateJob"); if (sems != null && sems.Count > 0) { var sem = sems[0]; List <JobServicesViewModel> jsvms = null; List <JobEquipmentsViewModel> jevms = null; /** Deserializing the Schedule Equipement Object and Looping into Job Service Object */ List <AlarmEmailNotificationEquipmentsViewModel> sevms = JsonConvert.DeserializeObject <List <AlarmEmailNotificationEquipmentsViewModel> >(equipments[0].AlarmEmailNotificationEquipments); if (sevms != null && sevms.Count > 0) { jevms = new List <JobEquipmentsViewModel>(); foreach (AlarmEmailNotificationEquipmentsViewModel sevm in sevms) { if (sevm.Active == "Y") { JobEquipmentsViewModel jsvm = new JobEquipmentsViewModel { JobEquipmentId = 0, EquipmentId = sevm.EquipmentId, }; jevms.Add(jsvm); } } } foreach (DateTime StartDate in DateUtils.GetDatesBetweenRange(sem.StartDate, sem.EndDate, sem.IntervalDays)) { //AlarmEmailNotificationEquipmentsViewModel jvm = new AlarmEmailNotificationEquipmentsViewModel //{ // JobId = 0, // AlarmEmailNotificationSetupId = sem.AlarmEmailNotificationSetupId, // JobName = sem.AlarmEmailNotificationName, // ClientSiteId = csId, // EstStartDate = StartDate, // EstEndDate = StartDate.AddDays(sem.EstJobDays - 1), // JobServices = jsvms, // JobEquipments = jevms, // UserId = cUser.UserId //}; //await EmailConfigurationRepo.SaveOrUpdate(jvm); } } await auditLogService.LogActivity(cUser.UserId, cUser.HostIP, cUser.SessionId, "Jobs", "Job Generated."); return(Ok()); } catch (CustomException cex) { var responseObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString()); return(StatusCode(StatusCodes.Status500InternalServerError, responseObj)); } catch (Exception ex) { return(Ok(new EmaintenanceMessage(ex.Message))); } }
public override void GetTabs() { string strTopContent = "<TABLE WIDTH=100%><TR><TD CLASS=TOPHEADING WIDTH=60><IMG SRC='" + CurrentUser.VirtualImgPath() + "Icons/Opportunity.gif' BORDER=0 ALIGN=MIDDLE></td><td CLASS=VIEWBOXCAPTION><SPAN CLASS=TOPCAPTION>机会</SPAN></td></tr></table>"; AddTopContent(strTopContent); GetTabs("SalesManagement", "Opportunity"); }
public static IQueryable <GroupParticipant> WithLimitTenant(this IQueryable <GroupParticipant> queryBase, CurrentUser user) { var tenantId = user.GetTenantId <int>(); var queryFilter = queryBase; return(queryFilter); }
async void CreateDocx() { int r = 0; DateTime start = dateStartReport.SelectedDate.Value; DateTime end = dateEndReport.SelectedDate.Value; var arr = new List <Order> [6]; List <Order> orders = new List <Order>(); IAdmin admin = new CurrentUser(); orders = await admin.GetOrdersByStatus(3, start, end); arr[3] = orders; orders = await admin.GetOrdersByStatus(1, start, end); arr[1] = orders; orders = await admin.GetOrdersByStatus(2, start, end); arr[2] = orders; orders = await admin.GetOrdersByStatus(4, start, end); arr[4] = orders; orders = await admin.GetOrdersByStatus(5, start, end); arr[5] = orders; #region Create .Docx File // неведомая хрень object oMissing = Missing.Value; object oEndOfDoc = "\\endofdoc"; Word.Application app; Word.Document docx; Word.Range wrdRng; // открытие приложния try { app = new Word.Application { Visible = false, // отображение хода заполнения }; //object fileName = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Отчёт о заявках от " + DateTime.Now.ToLongDateString(); docx = app.Documents.Add(); } catch (Exception ex) { logText.Foreground = Brushes.Red; logText.Text = "Ошибка генерации! " + ex.Message; //исправить вывод и сделать номально увеличение текста //docx.Close(Word.WdSaveOptions.wdDoNotSaveChanges, Word.WdOriginalFormat.wdOriginalDocumentFormat, false); // app.Quit(); return; } //изменение ориентации листа docx.PageSetup.Orientation = Word.WdOrientation.wdOrientLandscape; docx.PageSetup.TopMargin = 15; docx.PageSetup.BottomMargin = 15; docx.PageSetup.RightMargin = 25; docx.PageSetup.LeftMargin = 25; // начинаем создавать док Word.Paragraph para1; para1 = docx.Content.Paragraphs.Add(ref oMissing); para1.Range.Font.Name = "Times New Roman"; para1.Range.Font.Size = 16; para1.Range.Text = "Отчёт о заявках от " + DateTime.Now.ToShortDateString(); para1.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; para1.Range.Font.Bold = 1; para1.Range.InsertParagraphAfter(); para1.CloseUp(); //Insert a paragraph at the end of the document. Word.Paragraph para2; object oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para2 = docx.Content.Paragraphs.Add(ref oRng); for (int i = 0; i < 6; i++) { //каждый раз после вставки нового предложения заново применяем форматирование para2.Range.Font.Bold = 0; para2.Range.Font.Name = "Times New Roman"; para2.Range.Font.Size = 14; para2.Format.SpaceAfter = 0; para2.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; if (i == 0) { para2.Range.Text = "Выбранный диапазон с " + start.Date.ToShortDateString() + " по " + end.Date.ToShortDateString() + "."; } if (i == 1) { para2.Range.Text = "Заявки ожидающие принятия специалистом - " + arr[1].Count + "."; } if (i == 2) { para2.Range.Text = "Заявки в процессе выполнения - " + arr[2].Count + "."; } if (i == 3) { para2.Range.Text = "Выполнено заявок - " + arr[3].Count + "."; } if (i == 4) { para2.Range.Text = "Заявки, требующие ремонта или закупки - " + arr[4].Count + "."; } if (i == 5) { para2.Range.Text = "Отменено заявок пользователями - " + arr[5].Count + "."; } para2.Range.InsertParagraphAfter(); } #region Таблица выполненных заявок if (arr[3].Count == 0) { para2.Range.InsertParagraphAfter(); para2.Range.Text = "Выполненные заявки - Отсутствуют."; para2.Range.InsertParagraphBefore(); para2.CloseUp(); } else { para2.Range.InsertParagraphAfter(); para2.Range.Text = "Таблица 1 - Выполненные заявки."; para2.CloseUp(); Word.Table oTable; wrdRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = docx.Tables.Add(wrdRng, arr[3].Count + 1, 6, ref oMissing, ref oMissing); oTable.Range.Font.Size = 12; //границы таблицы oTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Columns[1].Width = 20; oTable.Columns[2].Width = 80; oTable.Columns[3].Width = 100; oTable.Columns[4].Width = 100; oTable.Columns[6].Width = 95; oTable.AllowAutoFit = true; //выравнивание по ширине??? oTable.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitWindow); // вот это точно выравнивание по ширине окна ворда for (r = 1; r <= arr[3].Count + 1; r++) { if (r == 1) { oTable.Cell(r, 1).FitText = true; //расширение при добавлении текста oTable.Cell(r, 1).Range.Text = "№"; oTable.Cell(r, 2).Range.Text = "Дата отправки"; oTable.Cell(r, 3).Range.Text = "Заявитель"; oTable.Cell(r, 4).Range.Text = "Исполнитель"; oTable.Cell(r, 5).Range.Text = "Проблема"; oTable.Cell(r, 6).Range.Text = "Дата подтверждения"; for (int tmp = 1; tmp <= 6; tmp++) { oTable.Cell(r, tmp).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; } continue; } oTable.Rows[r - 1].Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; oTable.Cell(r, 1).Range.Text = arr[3][r - 2].Id.ToString(); oTable.Cell(r, 2).Range.Text = arr[3][r - 2].Date.ToString(); oTable.Cell(r, 3).Range.Text = arr[3][r - 2].UserName.ToString(); oTable.Cell(r, 4).Range.Text = arr[3][r - 2].AdminName.ToString(); oTable.Cell(r, 5).Range.Text = arr[3][r - 2].Problem.ToString(); oTable.Cell(r, 6).Range.Text = arr[3][r - 2].CompletionDate.ToString(); } oTable.Rows[1].Range.Font.Bold = 1; oTable.Rows[1].Alignment = Word.WdRowAlignment.wdAlignRowCenter; } #endregion #region Таблица ожидающих заявок //параграф (заголовок) if (arr[2].Count == 0) { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Заявки, в процессе выпоолнения и ожидания подтверждения - Отсутствуют."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; para.Range.InsertParagraphAfter(); } else { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Таблица 2 - Заявки, в процессе выполнения и ожидания подтверждения."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; //сама таблица Word.Table oTable; wrdRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = docx.Tables.Add(wrdRng, arr[2].Count + 1, 6, ref oMissing, ref oMissing); oTable.Range.Font.Size = 12; //границы таблицы oTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Columns[1].Width = 20; oTable.Columns[2].Width = 80; oTable.Columns[3].Width = 100; oTable.Columns[4].Width = 100; oTable.AllowAutoFit = true; //выравнивание по ширине??? oTable.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitWindow); // вот это точно выравнивание по ширине окна ворда for (r = 1; r <= arr[2].Count + 1; r++) { if (r == 1) { oTable.Cell(r, 1).FitText = true; //расширение при добавлении текста oTable.Cell(r, 1).Range.Text = "№"; oTable.Cell(r, 2).Range.Text = "Дата отправки"; oTable.Cell(r, 3).Range.Text = "Заявитель"; oTable.Cell(r, 4).Range.Text = "Исполнитель"; oTable.Cell(r, 5).Range.Text = "Проблема"; oTable.Cell(r, 6).Range.Text = "Описание"; for (int tmp = 1; tmp <= 6; tmp++) { oTable.Cell(r, tmp).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; } continue; } oTable.Rows[r - 1].Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; oTable.Cell(r, 1).Range.Text = arr[2][r - 2].Id.ToString(); oTable.Cell(r, 2).Range.Text = arr[2][r - 2].Date.ToString(); oTable.Cell(r, 3).Range.Text = arr[2][r - 2].UserName.ToString(); oTable.Cell(r, 4).Range.Text = arr[2][r - 2].AdminName.ToString(); oTable.Cell(r, 5).Range.Text = arr[2][r - 2].Problem.ToString(); oTable.Cell(r, 6).Range.Text = arr[2][r - 2].Description.ToString(); } oTable.Rows[1].Range.Font.Bold = 1; oTable.Rows[1].Alignment = Word.WdRowAlignment.wdAlignRowCenter; } #endregion #region Таблица заявок в процесе подтверждения специалистом //параграф (заголовок) if (arr[1].Count == 0) { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Заявки, в процессе подтверждения специалистом - Отсутствуют."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; para.Range.InsertParagraphAfter(); } else { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Таблица 3 - Заявки, в процессе принятия специалистом."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; //сама таблица Word.Table oTable; wrdRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = docx.Tables.Add(wrdRng, arr[1].Count + 1, 5, ref oMissing, ref oMissing); oTable.Range.Font.Size = 12; //границы таблицы oTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Columns[1].Width = 20; oTable.Columns[2].Width = 80; oTable.Columns[3].Width = 100; oTable.Columns[4].Width = 100; oTable.Columns[5].Width = 300; oTable.AllowAutoFit = true; //выравнивание по ширине??? oTable.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitWindow); // вот это точно выравнивание по ширине окна ворда for (r = 1; r <= arr[1].Count + 1; r++) { if (r == 1) { oTable.Cell(r, 1).FitText = true; //расширение при добавлении текста oTable.Cell(r, 1).Range.Text = "№"; oTable.Cell(r, 2).Range.Text = "Дата отправки"; oTable.Cell(r, 3).Range.Text = "Заявитель"; oTable.Cell(r, 4).Range.Text = "Проблема"; oTable.Cell(r, 5).Range.Text = "Описание"; for (int tmp = 1; tmp <= 5; tmp++) { oTable.Cell(r, tmp).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; } continue; } oTable.Rows[r - 1].Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; oTable.Cell(r, 1).Range.Text = arr[1][r - 2].Id.ToString(); oTable.Cell(r, 2).Range.Text = arr[1][r - 2].Date.ToString(); oTable.Cell(r, 3).Range.Text = arr[1][r - 2].UserName.ToString(); oTable.Cell(r, 4).Range.Text = arr[1][r - 2].Problem.ToString(); oTable.Cell(r, 5).Range.Text = arr[1][r - 2].Description.ToString(); } oTable.Rows[1].Range.Font.Bold = 1; oTable.Rows[1].Alignment = Word.WdRowAlignment.wdAlignRowCenter; } #endregion #region Таблица заявок требующие ремонт или закупку //параграф (заголовок) if (arr[1].Count == 0) { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Заявки, требующие ремонт или закупку - Отсутствуют."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; para.Range.InsertParagraphAfter(); } else { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Таблица 4 - Заявки, требующие ремонт или закупку."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; //сама таблица Word.Table oTable; wrdRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = docx.Tables.Add(wrdRng, arr[4].Count + 1, 7, ref oMissing, ref oMissing); oTable.Range.Font.Size = 12; //границы таблицы oTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Columns[1].Width = 20; oTable.Columns[2].Width = 80; oTable.Columns[3].Width = 100; oTable.Columns[6].Width = 100; oTable.AllowAutoFit = true; //выравнивание по ширине??? oTable.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitWindow); // вот это точно выравнивание по ширине окна ворда for (r = 1; r <= arr[4].Count + 1; r++) { if (r == 1) { oTable.Cell(r, 1).FitText = true; //расширение при добавлении текста oTable.Cell(r, 1).Range.Text = "№"; oTable.Cell(r, 2).Range.Text = "Дата отправки"; oTable.Cell(r, 3).Range.Text = "Заявитель"; oTable.Cell(r, 4).Range.Text = "Проблема"; oTable.Cell(r, 5).Range.Text = "Описание"; oTable.Cell(r, 6).Range.Text = "Исполнитель"; oTable.Cell(r, 7).Range.Text = "Комментарий"; for (int tmp = 1; tmp <= 7; tmp++) { oTable.Cell(r, tmp).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; } continue; } oTable.Rows[r - 1].Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; oTable.Cell(r, 1).Range.Text = arr[4][r - 2].Id.ToString(); oTable.Cell(r, 2).Range.Text = arr[4][r - 2].Date.ToString(); oTable.Cell(r, 3).Range.Text = arr[4][r - 2].UserName.ToString(); oTable.Cell(r, 4).Range.Text = arr[4][r - 2].Problem.ToString(); oTable.Cell(r, 5).Range.Text = arr[4][r - 2].Description.ToString(); oTable.Cell(r, 6).Range.Text = arr[4][r - 2].AdminName.ToString(); oTable.Cell(r, 7).Range.Text = arr[4][r - 2].AdminComment.ToString(); } oTable.Rows[1].Range.Font.Bold = 1; oTable.Rows[1].Alignment = Word.WdRowAlignment.wdAlignRowCenter; } #endregion #region Таблица заявок отменённые пользователем //параграф (заголовок) if (arr[1].Count == 0) { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Заявки, отменённые пользователем - Отсутствуют."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; para.Range.InsertParagraphAfter(); } else { Word.Paragraph para; oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para = docx.Content.Paragraphs.Add(ref oRng); para.Range.InsertParagraphBefore(); para.Range.InsertParagraphBefore(); para.Range.Text = "Таблица 4 - Заявки отменённые пользователем."; para.Range.Font.Bold = 0; para.Range.Font.Name = "Times New Roman"; para.Range.Font.Size = 14; para.Format.SpaceAfter = 0; para.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; //сама таблица Word.Table oTable; wrdRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = docx.Tables.Add(wrdRng, arr[5].Count + 1, 5, ref oMissing, ref oMissing); oTable.Range.Font.Size = 12; //границы таблицы oTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Columns[1].Width = 20; oTable.Columns[2].Width = 80; oTable.Columns[3].Width = 100; oTable.AllowAutoFit = true; //выравнивание по ширине??? oTable.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitWindow); // вот это точно выравнивание по ширине окна ворда for (r = 1; r <= arr[5].Count + 1; r++) { if (r == 1) { oTable.Cell(r, 1).FitText = true; //расширение при добавлении текста oTable.Cell(r, 1).Range.Text = "№"; oTable.Cell(r, 2).Range.Text = "Дата отправки"; oTable.Cell(r, 3).Range.Text = "Заявитель"; oTable.Cell(r, 4).Range.Text = "Проблема"; oTable.Cell(r, 5).Range.Text = "Описание"; for (int tmp = 1; tmp <= 5; tmp++) { oTable.Cell(r, tmp).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; } continue; } oTable.Rows[r - 1].Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; oTable.Cell(r, 1).Range.Text = arr[5][r - 2].Id.ToString(); oTable.Cell(r, 2).Range.Text = arr[5][r - 2].Date.ToString(); oTable.Cell(r, 3).Range.Text = arr[5][r - 2].UserName.ToString(); oTable.Cell(r, 4).Range.Text = arr[5][r - 2].Problem.ToString(); oTable.Cell(r, 5).Range.Text = arr[5][r - 2].Description.ToString(); } oTable.Rows[1].Range.Font.Bold = 1; oTable.Rows[1].Alignment = Word.WdRowAlignment.wdAlignRowCenter; } #endregion //Close this form. try { docx.Close(); logText.Foreground = Brushes.Green; logText.Text = "Документ успешно сохранён!"; } catch { docx.Close(Word.WdSaveOptions.wdDoNotSaveChanges, Word.WdOriginalFormat.wdOriginalDocumentFormat, false); logText.Foreground = Brushes.Gray; logText.Text = "Отмена сохранения документа!"; } app.Quit(); }
public PendenciaTipoServiceBase(IPendenciaTipoRepository rep, ICache cache, CurrentUser user) : base(cache) { this._rep = rep; this._user = user; }
public async Task <ResponseObject <bool> > AuditAsync(RequestPut <TWMSalesMainAduit> requestObject) { CurrentUser userInfo = TokenManager.GetCurentUserbyToken(Request.Headers); return(await _service.AuditAsync(requestObject, userInfo)); }
//private RelayCommand doubleCommand; //public RelayCommand DoubleCommand //{ // get // { // return doubleCommand; // } //} private async Task GetAllOrdres(object a) { IUser user = new CurrentUser(); Order order = new Order(); var status = await user.CreateOrder(order); }
public void Cleanup() { //Nos aseguramos que admin quede deslogeado despues de cada test. CurrentUser.deleteCurrentUser("*****@*****.**"); }
private void Pass() { CurrentUser.Pass(); }
//注册&登录 public JsonResult RegisterLogin(string mobile, string code) { //获取推荐人 long referrerId = 0; var cookieReferrer = Request.Cookies[Config.Cookie_ReferrerId]; if (cookieReferrer != null) { referrerId = cookieReferrer.Value.To <long>(); } else {//兼容 header中传相关参数的处理 var headerReferrer = Request.Headers[Config.Cookie_ReferrerId]; referrerId = headerReferrer.To <long>(); } if (Common.IsMobile(mobile)) { if (serviceSMS.VerifyCode(mobile, code)) { var modelUser = serviceUser.GetModelByMobile(mobile); if (modelUser == null)//新用户 { modelUser = new User { Mobile = mobile, NickName = Common.Hide(mobile, 3, 4), Icon = Config.Icon_DefaultUrl, Type = Enums.UserType.Member, IsAction = true, AddTime = DateTime.Now }; //创建帐号 modelUser.UserId = serviceUser.Add(modelUser); //绑定推荐人 if (referrerId > 0) { serviceUser.UpdateReferrerId(modelUser.UserId, referrerId, out string mes); } } //创建登录信息 var currentUser = new CurrentUser { UserId = modelUser.UserId, Type = (int)modelUser.Type }; serviceAccount.CreateLoginToken(currentUser); result.code = -1; if (Common.IsWeChatBrowser() && modelUser.WeChatMPOpenId.IsNullOrEmpty()) { result.data = Config.Login_WeChat; } else { result.code = 1; if (Request.Cookies.AllKeys.Contains(Config.Cookie_RedirectUrl)) { result.data = Request.Cookies[Config.Cookie_RedirectUrl].Value; } else if (Request.Headers.AllKeys.Contains(Config.Cookie_RedirectUrl)) { //兼容 header中传相关参数的处理 result.data = Request.Headers[Config.Cookie_RedirectUrl]; } else { result.data = "/"; } } } else { result.mes = "短信验证码错误"; } } else { result.mes = "手机号格式错误"; } return(Json(result)); }
/// <summary> /// Retrieve the data and assign to Grid /// </summary> /// <param name="option"></param> /// <returns></returns> public HttpResponseMessage Post(DataGridoption option) { CurrentUser user = ApiUser; dynamic ds = null; try { if (option != null) { switch (option.Screen) { case "WorkStudy": ds = GetWorkStudies(option); break; case "AssignMaterial": ds = GetAssignMaterial(option); break; case "UACPartList": ds = GetUACPartList(option); break; case "RegisteredUser": ds = GetRegisteredUser(option); break; case "ProcessingMaterial": ds = GetProcessingMaterial(option); break; case "TestingMaterial": ds = GetTestingMaterial(option); break; case "Tension": ds = GetTensionReports(option); break; case "Compression": ds = GetCompressionReports(option); break; case "OpticalMount": ds = GetOpticalMountReports(option); break; case "Results": ds = GetResults(option); break; default: break; } } return(Serializer.ReturnContent(ds, this.Configuration.Services.GetContentNegotiator(), this.Configuration.Formatters, this.Request)); } catch (Exception ex) { _logger.Error(ex.Message); return(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } }
public IHttpActionResult GetBasketCount() { CurrentUser loginModel = GetCurrentUser(); return(Ok(GetBasketItemCount(loginModel.UserId))); }
public GroupParticipantApplicationServiceBase(IGroupParticipantService service, IUnitOfWork uow, ICache cache, CurrentUser user) : base(service, uow, cache) { base.SetTagNameCache("GroupParticipant"); this._validatorAnnotations = new ValidatorAnnotations <GroupParticipantDto>(); this._service = service; this._user = user; }
protected override async Task OnInitializedAsync() { await base.OnInitializedAsync(); _currentUser = await UserService.GetCurrentUserAsync(); }
public CurrentUserController(CurrentUser user, ILoggerFactory logger) { this._user = user; this._logger = logger.CreateLogger <CurrentUserController>(); this._logger.LogInformation("AccountController init success"); }
public NewsController(NewsContext context, CurrentUser loggedOnEmployee) { this.context = context; this.loggedOnEmployee = loggedOnEmployee; }
public IHttpActionResult PostBasket(BookIdModel bookIdModel) { CurrentUser loginModel = GetCurrentUser(); return(Ok(PostBookToBasket(bookIdModel, loginModel.UserId))); }
public static IQueryable <Estoque> WithLimitSubscriber(this IQueryable <Estoque> queryBase, CurrentUser user) { var subscriberId = user.GetSubjectId <int>(); var queryFilter = queryBase; return(queryFilter); }
public UsuarioApplicationServiceBase(IUsuarioService service, IUnitOfWork uow, ICache cache, CurrentUser user) : base(service, uow, cache) { base.SetTagNameCache("Usuario"); this._validatorAnnotations = new ValidatorAnnotations <UsuarioDto>(); this._service = service; this._user = user; }
public IHttpActionResult GetBasket() { CurrentUser loginModel = GetCurrentUser(); return(Ok(GetBooksFromBasket(loginModel.UserId))); }
public ActionResult Index(LMSLogin model) { ///<summary> ///Perform Login checks ///</summary> LMSLogin dbUser = new LMSLogin(); if (ModelState.IsValid) { // Checks the Current user login and password matches and check the Permission level bool userExists = unitofwork.LMSLoginRepository.CheckIfUserExists(model.UserName); if (userExists) { dbUser = unitofwork.LMSLoginRepository.CheckPassword(model); if (dbUser != null) { CurrentUser currentUser = new CurrentUser { UserId = dbUser.UserId, UserName = dbUser.UserName, FullName = dbUser.FirstName + " " + dbUser.LastName, PermissionLevel = dbUser.PermissionLevel, IsSecurityApplied = dbUser.IsSecurityApplied, }; this.HttpContext.Session["CurrentUser"] = currentUser; // add a record of User logging In. LMSAudit lmsAudit = new LMSAudit(); lmsAudit.TransactionDate = DateTime.Now; lmsAudit.UserName = currentUser.UserName; lmsAudit.FullName = currentUser.FullName; lmsAudit.Section = "Login"; lmsAudit.Action = "Logging In"; lmsAudit.Description = String.Format(" User Name : {0}, Name: {1} Logged In. Permission = {2}", currentUser.UserName, currentUser.FullName, currentUser.PermissionLevel); unitofwork.LMSAuditRepository.Insert(lmsAudit); unitofwork.Save(); //saves the user login name in cookies - for Remember Me option - for 15 days if (model.IsRememberMe) { HttpCookie cookie = new HttpCookie("LMSLogin"); cookie.Values.Add("UserName", currentUser.UserName); //cookie.Values.Add("Password", model.Password); cookie.Expires = DateTime.Now.AddDays(15); Response.Cookies.Add(cookie); } else { Response.Cookies["LMSLogin"].Expires = DateTime.Now.AddDays(-1); //HttpCookie cookie = new HttpCookie("LMSLogin"); //cookie.Values.Add("UserName", currentUser.UserName); //cookie.Expires = DateTime.Now.AddDays(15); //Response.Cookies.Add(cookie); } return(RedirectToAction("EmployeeList", "Employee")); } else { dbUser = new LMSLogin { UserName = model.UserName, Message = "Wrong Password." }; } } else { dbUser.Message = "User does not exists."; } } return(View(dbUser)); }
private void cmbreports_SelectedIndexChanged(object sender, EventArgs e) { if (cmbreports.SelectedIndex == 1) { try { DataTable dtReport = new DataTable(); NameValueCollection PARA = new NameValueCollection(); PARA.Add("@i_CompID", CurrentCompany.CompId.ToString()); PARA.Add("@i_UserId", CurrentUser.UserID.ToString()); dtReport = objList.ListOfRecord("rpt_CustomerReceipt", PARA, "CustomerPayment - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerPaymentRegister.rpt")) { //ObjDataTable.TableName = "PaymentRegister"; //ObjDataTable.WriteXmlSchema(@"D:\PaymentRegister.xsd"); DataView DVReport; DVReport = dtReport.DefaultView; DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerPaymentRegister.rpt"); CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Customer Payment Register", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Customer Payment Register - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("Please enter the Valid ReportPath or Docpath..."); } } else { MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Customer Payment - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMessage, "Exception"); } } else if (cmbreports.SelectedIndex == 2) { try { DataTable dtReport = new DataTable(); NameValueCollection PARA1 = new NameValueCollection(); PARA1.Add("@i_ReceiptID", dgvCustomerPayment.CurrentRow.Cells["ReceiptID"].Value.ToString()); dtReport = objList.ListOfRecord("rpt_Customer_Payment_Receipt", PARA1, "CustomerPayment - Report"); if (objList.Exception == null) { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerPendingPaymentReceipt.rpt")) { //dtReport.TableName = "PaymentReceipt"; //dtReport.WriteXmlSchema(@"D:\PaymentReceipt.xsd"); CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerPendingPaymentReceipt.rpt"); CurrentUser.AddReportParameters(rptDoc, dtReport, "Payment Receipt", true, true, true, true, false, true, true, false, false, false, true); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Payment Receipt - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("Please enter the Valid ReportPath or Docpath..."); } } else { MessageBox.Show(objList.Exception.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Customer Payment - Register Report", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMessage, "Exception"); } } cmbreports.SelectedIndex = 0; }
public ViewResult ViewJobList() { return(View("JobsList", PostDbManager.FetchPostsLinkedWithUserID(CurrentUser.Storage().UserDb.UserId))); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (CurrentUser.RightIsAdmin || CurrentUser.HasFactoryAdminRole()) { if (CurrentUser.RightCanDelete || CurrentUser.RightIsCurrentFactoryAdmin) { buttonDelete.Visible = true; } else { buttonDelete.Visible = false; } DataSet ds = new DataSet(); #region 工厂数据绑定 ds.ReadXml(Server.MapPath("..") + "\\ERPReportFactory.xml"); dropDownListFactory.DataSource = ds; dropDownListFactory.DataTextField = "Name"; dropDownListFactory.DataValueField = "Value"; dropDownListFactory.DataBind(); if (dropDownListFactory.Items.Count == 0) { dropDownListFactory.Items.Add(new ListItem("暂无工厂", "0")); } else if (!CurrentUser.RightIsAdmin) { for (int i = dropDownListFactory.Items.Count - 1; i >= 0; i--) { int tmpID = Convert.ToInt32(dropDownListFactory.Items[i].Value); if (!CurrentUser.FactoryIDList.Contains(tmpID) || (CurrentUser.FactoryIDList.Contains(tmpID) && CurrentUser.UseTypeList[CurrentUser.FactoryIDList.IndexOf(tmpID)] == 0)) { dropDownListFactory.Items.Remove(dropDownListFactory.Items[i]); } } } dropDownListFactory.SelectedIndex = 0; #endregion if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { labelTitle.Text = "修改查询报表"; int ID = Convert.ToInt32(Request.QueryString["ID"]); dropDownListFactory.Enabled = false; buttonCopy.Visible = true; InfoSysEntityTableAdapters.SQLReportTableAdapter sqlAdapter = new InfoSysEntityTableAdapters.SQLReportTableAdapter(); InfoSysEntity.SQLReportDataTable curTable = sqlAdapter.SelectByID(ID); foreach (InfoSysEntity.SQLReportRow curRow in curTable.Rows) { textBoxReportName.Text = curRow.SQLReportName; textBoxSQLCommand.Text = curRow.SQLReportSqlCommand; textBoxSQLSQLWhere.Text = (curRow.SQLReportSqlWhere.GetType() == typeof(DBNull)) ? "" : curRow.SQLReportSqlWhere; textBoxSQLOrder.Text = (curRow.SQLReportSqlOrder.GetType() == typeof(DBNull)) ? "" : curRow.SQLReportSqlOrder; textBoxSpecialField.Text = (curRow.SQLReportSpecialField.GetType() == typeof(DBNull)) ? "" : curRow.SQLReportSpecialField; textBoxShowURL.Text = (curRow.SQLReportShowURL.GetType() == typeof(DBNull)) ? "" : curRow.SQLReportShowURL; radioButtonListReportStatus.SelectedValue = curRow.SQLReportStatus.ToString(); dropDownListReportCate.SelectedValue = curRow.SQLReportCate.ToString(); radioButtonListFucCode.SelectedValue = curRow.SQLReportFuncCode.ToString(); textBoxComment.Text = curRow.SQLReportComment; textBoxCalculateField.Text = curRow.SQLReportCalculateField; dropDownListFactory.SelectedValue = curRow.SQLReportFactory.ToString(); textBoxSortIndex.Text = curRow.SQLReportSortIndex.ToString(); checkBoxIsLimited.Checked = curRow.SQLReportIsLimited == 1 ? true : false; string strBelongsTo = curRow.SQLReportBelongsTo.ToString(); foreach (string str in strBelongsTo.Split(',')) { for (int i = 0; i < checkBoxListReportCate.Items.Count; i++) { ListItem item = checkBoxListReportCate.Items[i]; if (item.Value.Equals(str)) { item.Selected = true; } } } break; } } else { buttonCopy.Visible = false; } departmentDatabinding(); } else { FounderTecInfoSys.Common.PageGeneralAction.GoBackShowWarmingWindow("您没有权限查看此页面,开通权限请与管理员联系"); Response.End(); } } }
public int SyncFollowersToDatabase(CurrentUser currentUser, long UserId) { return SyncToDatabase(SyncToDatabaseOp.GetFollowers, currentUser, UserId); }
public TipoEmailServiceBase(TipoEmailRepository rep, ValidationContract validation, CurrentUser user, IUnitOfWork uow) : base(rep, uow, validation) { this._rep = rep; this._user = user; }
public int SyncToDatabase(SyncToDatabaseOp Op, CurrentUser currentUser, long UserId) { logger.Debug("SyncFollowersToDatabase(Op: {0}, CurrentUser: {1}, UserId: {2})", (object) Op, (object) currentUser.Id, (object) UserId); FriendsClient friends = new FriendsClient(currentUser.Id); WebClientResult<FriendsList> FriendsList; if (Op == SyncToDatabaseOp.GetFollowers) FriendsList = friends.FollowerIds(UserId.ToString(), null, null); else FriendsList = friends.FriendIds(UserId.ToString(), null, null); using (var db = new ToketeeData().Context) { // TODO Handle deletes // Get the current known followers list from the DB // TODO find a way to create an IQueryable when specific columns are returned IQueryable<TwitterFriends> qFriendsInDb; if (Op == SyncToDatabaseOp.GetFollowers) { qFriendsInDb = from f in db.TwitterFriends where f.FriendId == UserId select f; } else { qFriendsInDb = from f in db.TwitterFriends where f.OwnerId == UserId select f; } logger.Trace("Known friends in DB for {0} / Count: {1}", UserId.ToString(), qFriendsInDb.Count().ToString()); var qtest = qFriendsInDb.Where(x => x.FriendId == 13348).Count(); // Determine which followers are not in the friend tracking table //ownerid IEnumerable<long> NewFollowers; IEnumerable<TwitterFriends> DeletedFollowers; if (Op == SyncToDatabaseOp.GetFollowers) { // Followers are identified by the OwnerId having a FriendId of the method's UserId NewFollowers = from f in FriendsList.Object where !(from a in qFriendsInDb select a.OwnerId).Contains(f) select f; var tempFriendsList = FriendsList.Object.ToList(); DeletedFollowers = from f in qFriendsInDb where !tempFriendsList.Contains(f.OwnerId) select f; //DeletedFollowers = from f in qFriendsInDb // where !(from a in FriendsList.Object // select a).Contains(f.OwnerId) // select f; } else { // Friends are identified by the FriendId having the OwnerId of the method's UserId NewFollowers = from f in FriendsList.Object where !(from a in qFriendsInDb select a.FriendId).Contains(f) select f; var tempFriendsList = FriendsList.Object.ToList(); DeletedFollowers = from f in qFriendsInDb where !tempFriendsList.Contains(f.FriendId) select f; //DeletedFollowers = from f in qFriendsInDb // where !(from a in FriendsList.Object // select a).Contains(f.FriendId) // select f; } logger.Trace("New followers: {0} / Unfollows: {1}", NewFollowers.Count(), DeletedFollowers.Count()); var NewFollowersList = new List<long>(); foreach (long Id in NewFollowers) { var tFriends = new TwitterFriends() { OwnerId = (Op == SyncToDatabaseOp.GetFollowers) ? Id : UserId, FriendId = (Op == SyncToDatabaseOp.GetFollowers) ? UserId : Id }; db.TwitterFriends.Add(tFriends); NewFollowersList.Add(Id); } var userOps = new UserOps(currentUser.Id); Users users = userOps.Lookup(NewFollowersList); string s = string.Join(",", FriendsList.Object.ToArray()); var qExistingUsers = db.TwitterUser.SqlQuery("select * from TwitterUser where Id in (" + s + ");"); // for each User in Users, find the corresponding TwitterUser to update // Filter out the users that do exist so we can insert the new ones var qDontExist = from u in users where !(from a in qExistingUsers select a.Id.ToString()).Contains(u.Id) select u; logger.Trace("Users to be inserted: {0}", qDontExist.Count().ToString()); foreach (TwitterAPI.User u in qDontExist) { if (qExistingUsers.Where(x => x.Id.ToString() == u.Id).Count() > 0) logger.Error("User already exists, but shouldn't! {0}", u.Id); } TwitterUser tUser; foreach (TwitterAPI.User u in qDontExist.Distinct()) { tUser = new TwitterUser(); UserOps.UserObjToTwitterUser(u, tUser); db.TwitterUser.Add(tUser); logger.Trace("Inserted TwitterUser: {0}", tUser.Id); } foreach (TwitterUser tu in qExistingUsers) { try { var q2 = (from u in users where u.Id == tu.Id.ToString() select u).SingleOrDefault(); if (q2 != null) UserOps.UserObjToTwitterUser(q2, tu); logger.Trace("Updated TwitterUser: {0}", tu.Id); } catch (InvalidOperationException e) { string sError = String.Format("UserObjToTwitterUser unable to match existing user TwitterUser {0} to friends list user", tu.Id); logger.ErrorException(sError, e); } } // Process unfollows int iFriendshipsDeleted = 0; foreach (TwitterFriends tf in DeletedFollowers) { logger.Trace("Deleting friendship: Owner {0} Friend {1}", tf.OwnerId, tf.FriendId); db.TwitterFriends.Remove(tf); iFriendshipsDeleted++; } if (iFriendshipsDeleted > 0) logger.Debug("Friendships deleted: {0}", iFriendshipsDeleted); return db.SaveChanges(); } }
public LubyTasksHandler(LubyTasksDbContext _lubyTasksDb, CurrentUser _currentUser) { LubyTasksContext = _lubyTasksDb; CurrentUser = _currentUser; }
/// <summary> /// NeedDataSource event handler of the generic grid /// </summary> /// <param name="source"></param> /// <param name="e"></param> private void GenericGrid_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { try { this.MasterTableView.FilterExpression = this.IndFilterExpression; if (!_UseAutomaticEntityBinding && _VirtualDataSource == null) { return; } //Clear the columns in the master table this.MasterTableView.Columns.Clear(); //Add the edit column AddEditColumn(); //Add the delete column (checkbox column) AddDeleteColumn(); DataSet sourceDS = new DataSet(); if (_UseAutomaticEntityBinding) { //Instantiate the referenced object IGenericEntity viewEntity = EntityFactory.GetEntityInstance(_EntityType, SessionManager.GetSessionValueNoRedirect((IndBasePage)this.Page, SessionStrings.CONNECTION_MANAGER)); ((GenericUserControl)this.Parent.Parent).SetViewEntityProperties(viewEntity); //Get all entities in this catalogue sourceDS = viewEntity.GetAll(true); //Creates a new GenericEntity object with the correct instance that will be used to add the logical column object connectionManager = SessionManager.GetSessionValueNoRedirect((IndBasePage)this.Page, SessionStrings.CONNECTION_MANAGER); //Add the logical column EntityFactory.GetEntityInstance(this.EntityType, connectionManager).CreateLogicalKeyColumn(sourceDS.Tables[0]); } else { if (!(_VirtualDataSource is DataSet) && !(_VirtualDataSource is DataTable)) { throw new IndException(ApplicationMessages.MessageWithParameters(ApplicationMessages.EXCEPTION_VIRTUAL_DATASOURCE_OF_TYPE_NOT_SUPPORTED, _VirtualDataSource.GetType().ToString())); } if (_VirtualDataSource is DataSet) { sourceDS = (DataSet)_VirtualDataSource; } if (_VirtualDataSource is DataTable) { sourceDS.Tables.Add((DataTable)_VirtualDataSource); } } //Add the data columns (with data from the db) to the grid AddDataColumns(sourceDS); if (_UseAutomaticEntityBinding) { CurrentUser currentUser = SessionManager.GetSessionValueRedirect((IndBasePage)this.Page, SessionStrings.CURRENT_USER) as CurrentUser; if (currentUser.HasEditPermission(ApplicationConstants.MODULE_HOURLY_RATE) && _EntityType == typeof(HourlyRate)) { AddColumnHeaderControl("Value", " <input type=\"image\" id=\"btnMassAttr\" class=\"IndImageButton\" title=\"Mass Attribution\" src=\"Images/mass_attribution_up.gif\" onclick=\"if (ShowPopUpWithoutPostBack('UserControls/Catalogs/HourlyRate/HRMassAttribution.aspx',520,560, '" + ResolveUrl("~/Default.aspx?SessionExpired=1") + "')){ __doPostBack('" + this.Page.ClientID + "',null);}return false;\""); } //Hide the columns that must not be shown (like Id) HideColumns(); } //Bind the grid to the dataset this.DataSource = sourceDS; SetDateColumnFormatString(); } catch (IndException ex) { ControlHierarchyManager.ReportError(ex); return; } catch (Exception ex) { ControlHierarchyManager.ReportError(new IndException(ex)); return; } }
async void CreateDocxEvent() { DateTime start = dateStartReportEvent.SelectedDate.Value; DateTime end = dateEndReportEvent.SelectedDate.Value; var events = new List <Event>(); IAdmin admin = new CurrentUser(); events = await admin.GetEventsForStatistic(start, end); if (events.Count == 0) { logTextEvent.Foreground = Brushes.Red; logTextEvent.Text = "За выбранный промежуток времени мероприятий НЕТ!"; return; } if (!cancelEvent.IsChecked.Value) //удаляем отменённые мероприятия если отменили { for (int i = 0; i < events.Count; ++i) { if (events[i].IsCanceled) { events.Remove(events[i]); --i; } } } #region Create .Docx File for event // неведомая хрень object oMissing = Missing.Value; object oEndOfDoc = "\\endofdoc"; Word.Application app; Word.Document docx; Word.Range wrdRng; // открытие приложния try { app = new Word.Application { Visible = false, // отображение хода заполнения }; docx = app.Documents.Add(); } catch (Exception ex) { logTextEvent.Foreground = Brushes.Red; logTextEvent.Text = "Ошибка генерации! \n" + ex.Message; return; } //изменение ориентации листа docx.PageSetup.Orientation = Word.WdOrientation.wdOrientLandscape; docx.PageSetup.TopMargin = 15; docx.PageSetup.BottomMargin = 15; docx.PageSetup.RightMargin = 25; docx.PageSetup.LeftMargin = 25; // начинаем создавать док Word.Paragraph para1; para1 = docx.Content.Paragraphs.Add(ref oMissing); para1.Range.Font.Name = "Times New Roman"; para1.Range.Font.Size = 16; para1.Range.Text = "Отчёт о мероприятиях от " + DateTime.Now.ToShortDateString(); para1.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; para1.Range.Font.Bold = 1; para1.Range.InsertParagraphAfter(); para1.Range.Font.Name = "Times New Roman"; para1.Range.Font.Size = 16; para1.Range.Font.Bold = 0; if ((bool)cancelEvent.IsChecked) { para1.Range.Text = "Выбранный диапазон с " + start.Date.ToShortDateString() + " по " + end.Date.ToShortDateString() + ". (С учётом отменённых заявок)"; } else { para1.Range.Text = "Выбранный диапазон с " + start.Date.ToShortDateString() + " по " + end.Date.ToShortDateString() + "."; } para1.Range.InsertParagraphAfter(); para1.CloseUp(); //Insert a paragraph at the end of the document. Word.Paragraph para2; object oRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; para2 = docx.Content.Paragraphs.Add(ref oRng); para2.Range.Font.Bold = 0; para2.Range.Font.Name = "Times New Roman"; para2.Range.Font.Size = 14; para2.Format.SpaceAfter = 0; para2.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft; para2.Range.InsertParagraphAfter(); para2.Range.Text = "Таблица Мероприятий."; Word.Table oTable; wrdRng = docx.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = docx.Tables.Add(wrdRng, events.Count, 6, ref oMissing, ref oMissing); oTable.Range.Font.Size = 12; oTable.Range.Font.Bold = 0; //границы таблицы oTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Columns[1].Width = 20; oTable.Columns[2].Width = 60; oTable.Columns[3].Width = 80; oTable.Columns[5].Width = 150; // пробуем ограничить длинну oTable.Columns[6].Width = 60; oTable.AllowAutoFit = true; //выравнивание по ширине??? oTable.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitWindow); // вот это точно выравнивание по ширине окна ворда int r = 0; foreach (var eve in events) { ++r; if (r == 1) { oTable.Cell(r, 1).FitText = true; //расширение при добавлении текста oTable.Cell(r, 1).Range.Text = "№"; oTable.Cell(r, 2).Range.Text = "Дата мероприятия"; oTable.Cell(r, 3).Range.Text = "Заявитель"; oTable.Cell(r, 4).Range.Text = "Название"; oTable.Cell(r, 5).Range.Text = "Описание"; oTable.Cell(r, 6).Range.Text = "Дата заявки"; for (int tmp = 1; tmp <= 6; tmp++) { oTable.Cell(r, tmp).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter; } oTable.Rows[r].Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; continue; } oTable.Rows[r].Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter; oTable.Cell(r, 1).Range.Text = eve.Id.ToString(); oTable.Cell(r, 2).Range.Text = eve.DateStart.ToShortDateString() + "\n c " + eve.DateStart.TimeOfDay.ToString() + " по " + eve.DateEnd.TimeOfDay.ToString(); oTable.Cell(r, 3).Range.Text = eve.UserName.ToString(); oTable.Cell(r, 4).Range.Text = eve.NameEvent.ToString(); oTable.Cell(r, 5).Range.Text = eve.Description.ToString(); oTable.Cell(r, 6).Range.Text = eve.Date.ToString(); if (eve.IsCanceled) { oTable.Cell(r, 6).Range.Text += "Отменено"; } } oTable.Rows[1].Range.Font.Bold = 1; oTable.Rows[1].Alignment = Word.WdRowAlignment.wdAlignRowCenter; //Close this form. try { docx.Close(); logTextEvent.Foreground = Brushes.Green; logTextEvent.Text = "Документ успешно сохранён!"; } catch { docx.Close(Word.WdSaveOptions.wdDoNotSaveChanges, Word.WdOriginalFormat.wdOriginalDocumentFormat, false); logTextEvent.Foreground = Brushes.Gray; logTextEvent.Text = "Отмена сохранения документа!"; } app.Quit(); }
public ActionResult List(int filter, int?nav_page, int?rows, int?sort_field, int?sort_direction) { if (nav_page < 0) { nav_page = 0; } var rvm = CreateViewModel <RoleListViewModel>(); var building_ids = GetUserBuildings(_buildingRepository, _userRepository); IEnumerable <Role> role_list = _roleRepository.FindAll( x => x.IsDeleted == false && x.RoleTypeId >= CurrentUser.Get().RoleTypeId&& x.RoleBuildings.Any(rb => !rb.IsDeleted && building_ids.Contains(rb.BuildingId))).OrderBy(r => r.Name.ToLower()); if (filter == 0) { role_list = role_list.Where(x => !x.Active); } if (filter == 1) { role_list = role_list.Where(x => x.Active); } if (!CurrentUser.Get().IsBuildingAdmin&& !CurrentUser.Get().IsSuperAdmin) { role_list = role_list.Where( x => x.Id == CurrentUser.Get().RoleId || (x.User != null && CurrentUser.Get().CompanyId == x.User.CompanyId)); } IEnumerable <RoleItem> role_item_list = new List <RoleItem>(); Mapper.Map(role_list, role_item_list); if (sort_field.HasValue && sort_direction.HasValue) { switch (sort_field) { case 0: if (sort_direction.Value == 0) { role_item_list = role_item_list.OrderBy(x => x.Name.ToUpper()).ToList(); } else { role_item_list = role_item_list.OrderByDescending(x => x.Name.ToUpper()).ToList(); } break; case 1: if (sort_direction.Value == 0) { role_item_list = role_item_list.OrderBy(x => x.RoleTypeId.ToString()).ToList(); } else { role_item_list = role_item_list.OrderByDescending(x => x.RoleTypeId.ToString()).ToList(); } break; case 2: if (sort_direction.Value == 0) { role_item_list = role_item_list.OrderBy(x => x.Description.ToUpper()).ToList(); } else { role_item_list = role_item_list.OrderByDescending(x => x.Description.ToUpper()).ToList(); } break; case 3: if (sort_direction.Value == 0) { role_item_list = role_item_list.OrderBy(x => x.BuildingsNames.ToUpper()).ToList(); } else { role_item_list = role_item_list.OrderByDescending(x => x.BuildingsNames.ToUpper()).ToList(); } break; default: role_item_list = role_item_list.OrderBy(x => x.Name).OrderBy(x => x.Name).ToList(); break; } } else { role_item_list = role_item_list.OrderBy(x => x.Name).ToList(); } rvm.Paginator = SetupPaginator(ref role_item_list, nav_page, rows); rvm.Paginator.DivToRefresh = "RolesSearchResult"; rvm.Paginator.Prefix = "Roles"; rvm.Roles = role_item_list; return(PartialView(rvm)); }
public StockControlController(IStockItemService stockItemService, Now now, CurrentUser currentUser) { this.stockItemService = stockItemService; this.now = now; this.currentUser = currentUser; }