private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.Report7.Report7_Main(); report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue("TenderId", CurrentTender.TenderingId); if (CurrentTender.TenderingNumber != null) { report.SetParameterValue("TenderingNumParam", CurrentTender.TenderingNumber.ToString()); } else { report.SetParameterValue("TenderingNumParam", "ندارد"); } report.SetParameterValue("TenderTitleParam", CurrentTender.TenderingTitle); report.SetParameterValue("OpenDateParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).Substring(4)); report.SetParameterValue("EstimateParam", CurrentReq.Estimatation); report.SetParameterValue("Price", CurrentTender.GuarantyPrice); crystalReportsViewer1.ViewerCore.ReportSource = report; }
public TimeEntryResponse Map(TimeEntry entry) { if (entry == null) { return(null); } return(new TimeEntryResponse() { Date = DateConverter.Convert(entry.Date), Hours = entry.Hours, Id = entry.Id, Notes = entry.Notes, Rotation = entry.Rotation, PreceptorId = entry.TeacherId, PreceptorDisplayName = entry.Teacher.DisplayName, StudentId = entry.StudentId, StudentDisplayName = entry.Student.DisplayName, }); }
protected internal virtual void applyQueryParams(MetricsQuery query, UriInfo uriInfo) { MultivaluedMap <string, string> queryParameters = uriInfo.QueryParameters; DateConverter dateConverter = new DateConverter(); dateConverter.ObjectMapper = objectMapper; if (queryParameters.getFirst("startDate") != null) { DateTime startDate = dateConverter.convertQueryParameterToType(queryParameters.getFirst("startDate")); query.startDate(startDate); } if (queryParameters.getFirst("endDate") != null) { DateTime endDate = dateConverter.convertQueryParameterToType(queryParameters.getFirst("endDate")); query.endDate(endDate); } }
public IEnumerable <Event> GetEvents(string start, string end) { DateTime _start = DateConverter.ToDateTime(start); DateTime _end = DateConverter.ToDateTime(end); var result = new List <Event>(); try { result = _context.Events .Where(s => (s.StartDate >= _start & s.EndDate <= _end)) .Include(a => a.Subscribers) .Include(u => u.Creator) .ToList(); } catch (Exception) { return(null); } return(result); }
public static int SetBranchOfStudentInactive(int studentId) { try { int update = 0; BranchesStudents branchesStudent = BranchStudentDataManager.GetActiveBranchesOfStudent(studentId, Student.Includes.Branch); string releaseHebrewDate = DateConverter.GetHebrewDate(DateTime.UtcNow); foreach (BranchStudent branchStudent in branchesStudent) { update = BranchStudentDataManager.SetStudentInactiveInBranch(studentId, branchStudent.Branch.Id, releaseHebrewDate); BranchManager.ReduceNumberOfStudents(branchStudent.Branch.Id); } return(update); } catch (Exception ex) { _logger.Debug("Failed to set the student to inactive in his branches."); throw; } }
private void datPrijave_Leave(object sender, EventArgs e) { try { DateConverter dc = new DateConverter(); if (this.datPrijave.Text.Equals("")) { this.datPrijave.Text = DateTime.Now.ToString("dd.MM.yy."); } else { this.datPrijave.Text = dc.ConvertDDMMYY(datPrijave.Text); } } catch (Exception e1) { new LogWriter(e1); } }
public override bool HandleMessage(PairSocket me, PairSocket remote, Envelope envelop) { var queueName = envelop.ReadNext <string>(); var lostType = envelop.ReadNext <byte>(); var queueData = new MessageData(); queueData.Queue = queueName; queueData.IsLost = lostType != (byte)PubSubQueueLostType.None; if (queueData.IsLost) { var dateTime = envelop.ReadNext <long>(); queueData.SendDate = DateConverter.ConvertFromUnixTimestamp(dateTime); } me.OnMessage?.Invoke(envelop.GetMessage(), remote, queueData); return(true); }
private void SLAdat_Leave(object sender, EventArgs e) { try { DateConverter dc = new DateConverter(); if (this.prio.Text.Equals("6")) { this.SLAdat.Text = dc.CalculatePrio(this.prio.Text, dc.ConvertDDMMYY(this.SLAdat.Text), dc.ConvertTimeHHMM(this.SLAvri.Text)).ToString("dd.MM.yy."); } else { this.SLAdat.Text = dc.CalculatePrio(this.prio.Text, this.datPrijave.Text, this.vriPrijave.Text).ToString("dd.MM.yy."); } } catch (Exception e1) { new LogWriter(e1); } }
static void Main(string[] args) { if (args.Length != 2) { throw new ArgumentException("Invalid number or arguments. Expected two."); } IDateConverter dateConverter = new DateConverter(); try { Console.WriteLine(dateConverter.GetDateRange(args[0], args[1])); } catch (FormatException) { Console.WriteLine("Date time format not supported"); //throw } Console.ReadLine(); }
public UserResponse Map(User user) { if (user == null) { return(null); } var tokenExp = user.TokenExpiration.HasValue ? DateConverter.Convert(user.TokenExpiration.Value) : string.Empty; return(new UserResponse() { AccountType = user.Account.ToString(), DisplayName = user.DisplayName, Email = user.Email, Id = user.Id.ToString(), Token = user.Token, TokenExpirationDate = tokenExp, }); }
public IEnumerable <EventSubscriber> GetSubscriptions(string start, string end, string subscriberId) { DateTime _start = DateConverter.ToDateTime(start); DateTime _end = DateConverter.ToDateTime(end); var result = new List <EventSubscriber>(); try { result = _context.EventSubscribers .Where(s => ((s.Start >= _start) && (s.End <= _end) && (s.SubscriberId == subscriberId))) .Include(a => a.Event) .Include(u => u.Event.Creator) .Include(u => u.Subscriber) .ToList(); } catch (Exception) { return(null); } return(result); }
public ActionResult <UserInformation> GetUserInformation(string email, string password) { var user = Context.Users.FirstOrDefault(c => c.Email == email && c.Password == password); if (user == null) { return(null); } UserInformation userInfo = new UserInformation { IsFirstLogin = user.LastLogin == user.CreatedOn }; user.LastLogin = DateConverter.CurrentEasternDateTime(); Context.SaveChanges(); userInfo.Id = user.Id; var customer = Context.Customers.First(c => c.Id == user.IdCustomer); userInfo.FullName = $"{customer.FirstName} {customer.LastName}"; return(userInfo); }
public string GetConsumer(string email) { var consumer = service.Where(o => o.Email.Equals(email)).SingleOrDefault(); if (consumer != null) { var con = consumerService.Where(o => o.Email.Equals(email)).SingleOrDefault(); string userToken = System.Guid.NewGuid().ToString(); Consumer selectedConsumer = consumerService.Get(con.Id); selectedConsumer.Token = userToken; consumerService.Save(); var list = service.Where(o => o.Email.Equals(email)).AsEnumerable(); var query = from seletedConsumer in list select new { seletedConsumer.Address, seletedConsumer.Age, BirthDate = DateConverter.GetJsonDate(seletedConsumer.BirthDate), DateRegistered = DateConverter.GetJsonDate(seletedConsumer.DateRegistered), seletedConsumer.Email, seletedConsumer.Gender, seletedConsumer.Name, seletedConsumer.Phone, seletedConsumer.Picture, seletedConsumer.Token, seletedConsumer.DeviceId, seletedConsumer.City, seletedConsumer.Country }; var oSerializer = new JavaScriptSerializer(); string sJson = oSerializer.Serialize(query); sJson = @"{""Data"":" + sJson + @",""success"":true}"; return(sJson); } return(null); }
public static Prepayment SelectById(string prepaymentId) { var connection = DatabaseConnection.Connection; using (var command = connection.CreateCommand()) { const string sql = "select * from T_Prepayment where Prepayment_Id = @id"; command.CommandText = sql; command.Parameters.AddWithValue("@id", prepaymentId); Logger.LogQuery($"execute sql = {sql}\r\n id = {prepaymentId}"); Prepayment prepayment = null; using (var reader = command.ExecuteReader()) { if (reader.Read()) { prepayment = new Prepayment(prepaymentId); //date if (connection.State == ConnectionState.Closed) { connection.Open(); } var date = reader["Prepayment_Warranty_Date"].ToString(); try { prepayment.WarrantyDate = DateConverter.StringToPersianDate(date); } catch (Exception e) { Logger.LogException(e); } } else { throw new ItemNotFoundException("prepayment", "id", prepaymentId); } } connection.Close(); return(prepayment); } }
/// <summary> /// Checks a RegistrationRequest /// </summary> /// <param name="request">RegistrationRequest to check</param> /// <returns>Indicates if it was successful</returns> private static bool CheckRegistrationRequest(RegistrationRequest request) { string email = request.Email; string nickname = request.Nickname; string password = request.PasswordHash; DateTime date = request.Birthday; if (string.IsNullOrWhiteSpace(email)) { return(false); } if (string.IsNullOrWhiteSpace(nickname)) { return(false); } if (string.IsNullOrWhiteSpace(password)) { return(false); } if (!email.Contains('@') || !email.Contains('.')) { return(false); } if (nickname.Length > 16 || nickname.Length < 4) { return(false); } if (password.Length != 64) { return(false); } if (DateConverter.GetAgeFromDate(date) < 12) { return(false); } return(true); }
public void InitDataView(ChatEntryDTO ItemModel) { if (Convert.ToInt16(ItemModel.UnreadMessageCount) == 0) { txtNotification.Visibility = ViewStates.Invisible; } else { txtNotification.Visibility = ViewStates.Visible; } txtNotification.Text = $"{ItemModel.UnreadMessageCount}"; txtName.Text = ItemModel.OtherUserName; var dateValue = DateConverter.GetDateTimeFromUnixTimeStamp(ItemModel.LastUpdateDate); txtTime.Text = dateValue.ToString("hh:mm"); txtDate.Text = dateValue.ToString("yyyy-MM-dd"); txtDescription.Text = ItemModel.LastMessage; if (string.IsNullOrEmpty(ItemModel.OtherUserPic)) { ImageService.Instance.LoadCompiledResource("female_placeholder") .Retry(3, 200) .IntoAsync(imgProfile); } else { ImageService.Instance.LoadUrl(ServerURL.BaseURL + ItemModel.OtherUserPic) .DownSample(width: 150) .Retry(3, 200) .ErrorPlaceholder("female_placeholder") .Into(imgProfile); } chkStatus.SetImageResource(ItemModel.OtherUserOnlineStatus ? Resource.Drawable.ic_circle_white_green : Resource.Drawable.ic_circle_green); if (ItemModel.IsBlocked || !ItemModel.OtherUserActivate) { chkStatus.SetImageResource(Resource.Drawable.ic_circle_green); } }
public ActionResult Create(Model_WorkshopPlanCreate model) { if (ModelState.IsValid) { Tbl_WorkshopPlan _WorkshopPlan = new Tbl_WorkshopPlan { WP_Guid = Guid.NewGuid(), WP_SWID = db.Tbl_SubWorkshop.Where(x => x.SW_Guid.ToString() == model.SubWorkshop).SingleOrDefault().SW_ID, WP_Description = model.Description, WP_Cost = model.Cost, WP_Location = model.Location, WP_Capacity = model.Capacity, WP_Date = DateConverter.ToGeorgianDateTime(model.Date), WP_IsActive = model.Activeness, WP_CreationDate = DateTime.Now, WP_ModifiedDate = DateTime.Now }; db.Tbl_WorkshopPlan.Add(_WorkshopPlan); if (Convert.ToBoolean(db.SaveChanges() > 0)) { TempData["TosterState"] = "success"; TempData["TosterType"] = TosterType.Maseage; TempData["TosterMassage"] = "کارگاه جدید با موفقیت ثبت شد"; return(RedirectToAction("Index")); } else { TempData["TosterState"] = "error"; TempData["TosterType"] = TosterType.Maseage; TempData["TosterMassage"] = "کارگاه جدید با موفقیت ثبت نشد"; return(View()); } } return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); }
public static ObservableCollection <ContractDataGridItem> SelectAll() { var connection = DatabaseConnection.Connection; var list = Contract.GetObservableCollection(); using (var command = connection.CreateCommand()) { const string sql = "select * from T_Contract_Info"; command.CommandText = sql; Logger.Log($"execute sql = {sql}"); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var contract = new Contract { Id = reader["Contract_Id"].ToString(), ProjectName = reader["Contract_Project_Name"].ToString(), ContractorName = reader["Contract_Contractor_Name"].ToString(), Number = reader["Contract_Number"].ToString(), Amount = reader["Contract_Amount"].ToString(), PrepaymentId = reader["Contract_Prepayment_Id"].ToString() }; //date var date = reader["Contract_Date"].ToString(); try { contract.Date = DateConverter.StringToPersianDate(date); } catch (Exception e) { Logger.LogException(e); } list.Add(new ContractDataGridItem(contract)); } connection.Close(); return(list); } } }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.Report2.Report2_Main(); try { report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue(0, Current.ContractorRequestId); report.SetParameterValue(1, DateConverter.ConvertDate((DateTime)(((Current.RequestDate).Value).Date)).Substring(4)); if (Current.HasCEOAccepted == true) { report.SetParameterValue(2, "موافقت"); } else { report.SetParameterValue(2, "مخالفت"); } if (Current.CeoNote != null) { report.SetParameterValue("NoteParam", Current.CeoNote); } else { report.SetParameterValue("NoteParam", " "); } if (Current.Estimatation != null) { report.SetParameterValue("EstimateParam", Current.Estimatation); } else { report.SetParameterValue("EstimateParam", "0"); } crystalReportsViewer1.ViewerCore.ReportSource = report; } catch { return; } }
protected internal virtual void applyQueryParams(MetricsQuery query, MultivaluedMap <string, string> queryParameters) { DateConverter dateConverter = new DateConverter(); dateConverter.ObjectMapper = objectMapper; if (queryParameters.getFirst(QUERY_PARAM_START_DATE) != null) { DateTime startDate = dateConverter.convertQueryParameterToType(queryParameters.getFirst(QUERY_PARAM_START_DATE)); query.startDate(startDate); } if (queryParameters.getFirst(QUERY_PARAM_END_DATE) != null) { DateTime endDate = dateConverter.convertQueryParameterToType(queryParameters.getFirst(QUERY_PARAM_END_DATE)); query.endDate(endDate); } IntegerConverter intConverter = new IntegerConverter(); intConverter.ObjectMapper = objectMapper; if (queryParameters.getFirst(QUERY_PARAM_FIRST_RESULT) != null) { int firstResult = intConverter.convertQueryParameterToType(queryParameters.getFirst(QUERY_PARAM_FIRST_RESULT)).Value; query.offset(firstResult); } if (queryParameters.getFirst(QUERY_PARAM_MAX_RESULTS) != null) { int maxResults = intConverter.convertQueryParameterToType(queryParameters.getFirst(QUERY_PARAM_MAX_RESULTS)).Value; query.limit(maxResults); } if (queryParameters.getFirst(QUERY_PARAM_AGG_BY_REPORTER) != null) { query.aggregateByReporter(); } }
// Details: Equipments #region Details public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } int ID = id ?? 0; var equipment = equipmentService.GetById(ID); if (equipment == null) { return(HttpNotFound()); } var equipmentModel = new EquipmentModel(); equipmentModel.Id = equipment.Id; equipmentModel.SerialNumber = equipment.SerialNumber; equipmentModel.Name = equipment.Name; equipmentModel.NextControlDate = DateConverter.DatetTimeToString(equipment.NextControlDate); equipmentModel.Image = equipment.Image; return(View(equipmentModel)); }
internal List <CustomerAppointmentInformation> GetUnconfirmedAppointments(PhoneNumberService phoneNumberService) { var appointments = ( from appointment in Context.Appointments join customer in Context.Customers on appointment.IdCustomer equals customer.Id join timeSlot in Context.TimeSlots on appointment.IdTimeSlot equals timeSlot.Id where customer.IsActive && appointment.IsActive && !appointment.IsConfirmed && timeSlot.StartDateTime.Date == DateConverter.CurrentEasternDateTime().Date.AddDays(1) select new CustomerAppointmentInformation() { Customer = customer, TimeSlot = timeSlot, Appointment = appointment }).AsNoTracking().ToList(); foreach (var appointment in appointments) { appointment.PhoneNumbers = phoneNumberService .GetPhoneNumbersForCustomer(appointment.Customer.Id); } return(appointments.OrderBy(c => c.TimeSlot.StartDateTime).ToList()); }
public int CancelAppointments(List <int> appointmentsToCancel) { int tooLateToCancel = 0; foreach (var appointmentId in appointmentsToCancel) { var appointment = Context.Appointments.Where(c => c.Id == appointmentId).First(); var timeSlot = Context.TimeSlots.Where(c => c.Id == appointment.IdTimeSlot).First(); DateTime now = DateConverter.CurrentEasternDateTime(); if (timeSlot.StartDateTime > now.AddHours(24)) { timeSlot.IsPublic = false; appointment.IsActive = false; Context.SaveChanges(); } else { tooLateToCancel++; } } return(tooLateToCancel); }
public string GetPromotionsByRetailerId(int id) { var cats = categoryService.Where(o => o.UserId == id && o.IsDeleted == false); List <int> catids = new List <int>(); foreach (var c in cats) { catids.Add(c.Id); } var list = service.Where(o => o.Products.All(m => m.Userid == id && m.IsDeleted == false && catids.Contains(m.ProductCategoryId))); // list = service.Where(p => p.Products.All(x => catids.Contains(x.ProductCategoryId))); var query = from pro in list select new { pro.Id, pro.Description, End = DateConverter.GetJsonDate(pro.End), pro.Price, Start = DateConverter.GetJsonDate(pro.Start), pro.Products.First().Picture, pro.Products.First().Name, pro.Products.First().ProductCategoryId, pro.Products.First().LikesCounter, productId = pro.Products.First().Id, pro.DiscountPercentage }; var oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string sJson = oSerializer.Serialize(query); sJson = @"{""Data"":" + sJson + @",""success"":true}"; return(sJson); }
public string GetPromotionsByRetailerIdAndPCategory(int id, int pCat) { var list = service.Where(o => o.Products.All(m => m.Userid == id && m.ProductCategoryId == pCat && m.IsDeleted == false)); var query = from pro in list select new { pro.Id, pro.Description, End = DateConverter.GetJsonDate(pro.End), pro.Price, Start = DateConverter.GetJsonDate(pro.Start), pro.Products.First().Picture, pro.Products.First().ProductCategoryId, pro.Products.First().LikesCounter, productId = pro.Products.First().Id }; var oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string sJson = oSerializer.Serialize(query); sJson = @"{""Data"":" + sJson + @",""success"":true}"; return(sJson); }
public void ConvertTestDate() { var testDate1 = "17.06.96/13:48:10"; var testDate2 = "17.06.14"; var testDate3 = "17.06.2017"; var testDate4 = "6/15/96"; var testDate5 = "1/30/1996"; var testDate6 = "96-4-26"; var testDate7 = "1996-10-23"; var testDate1Result = DateConverter.Convert(testDate1); Assert.Equal(new DateTime(1996, 6, 17).Date, testDate1Result.Date); var testDate2Result = DateConverter.Convert(testDate2); Assert.Equal(new DateTime(2014, 6, 17).Date, testDate2Result.Date); var testDate3Result = DateConverter.Convert(testDate3); Assert.Equal(new DateTime(2017, 6, 17).Date, testDate3Result.Date); var testDate4Result = DateConverter.Convert(testDate4); Assert.Equal(new DateTime(1996, 6, 15).Date, testDate4Result.Date); var testDate5Result = DateConverter.Convert(testDate5); Assert.Equal(new DateTime(1996, 1, 30).Date, testDate5Result.Date); var testDate6Result = DateConverter.Convert(testDate6); Assert.Equal(new DateTime(1996, 4, 26).Date, testDate6Result.Date); var testDate7Result = DateConverter.Convert(testDate7); Assert.Equal(new DateTime(1996, 10, 23).Date, testDate7Result.Date); }
internal object GetDashboard(string id = "") { var today = DateConverter.GetLocalZoneDate(DateTime.UtcNow); var lastWeek = today.AddDays(-7); var lastMonth = today.AddMonths(-1); int todayUpload = 0; int lastWeekUpload = 0; int lastMonthUpload = 0; int totalUpload = 0; if (string.IsNullOrEmpty(id)) { todayUpload = context.ImageIndexes.Where(a => a.CreatedDate.Value.Day == today.Day && a.CreatedDate.Value.Month == today.Month && a.CreatedDate.Value.Year == today.Year).Count(); lastWeekUpload = context.ImageIndexes.Count(a => a.CreatedDate <= today && a.CreatedDate >= lastWeek); lastMonthUpload = context.ImageIndexes.Count(a => a.CreatedDate <= today && a.CreatedDate >= lastMonth); totalUpload = context.ImageIndexes.Count(); } else { var user = context.AspNetUsers.FirstOrDefault(a => a.Id == id); if (user != null) { string username = user.UserName; todayUpload = context.ImageIndexes.Where(a => a.CreatedBy == username && a.CreatedDate.Value.Day == today.Day && a.CreatedDate.Value.Month == today.Month && a.CreatedDate.Value.Year == today.Year).Count(); lastWeekUpload = context.ImageIndexes.Count(a => a.CreatedBy == username && a.CreatedDate <= today && a.CreatedDate >= lastWeek); lastMonthUpload = context.ImageIndexes.Count(a => a.CreatedBy == username && a.CreatedDate <= today && a.CreatedDate >= lastMonth); totalUpload = context.ImageIndexes.Count(a => a.CreatedBy == username); } else { throw new Exception("User not found"); } } return(new { Today = todayUpload, LastWeek = lastWeekUpload, LastMonth = lastMonthUpload, Total = totalUpload }); }
public static ObservableCollection <Payment> SelectByPrepaymentId(string prepaymentId) { var connection = DatabaseConnection.Connection; using (var command = connection.CreateCommand()) { command.CommandText = "select * from T_Payment where Payment_Prepayment_Id = @id"; command.Parameters.AddWithValue("@id", prepaymentId); Logger.LogQuery($"{command.CommandText}\r\nid = {prepaymentId}"); using (var reader = command.ExecuteReader()) { var list = new ObservableCollection <Payment>(); while (reader.Read()) { var id = reader["Payment_Id"].ToString(); var preId = reader["Payment_Prepayment_Id"].ToString(); var item = new Payment(id, preId) { Amount = reader["Payment_Amount"].ToString(), IsExistInDatabase = true }; //date var date = reader["Payment_Date"].ToString(); try { item.Date = DateConverter.StringToPersianDate(date); } catch (Exception e) { Logger.LogException(e); } list.Add(item); } connection.Close(); return(list); } } }
/// <summary> /// Получение регистров по фильтру /// </summary> /// <param name="filter"></param> /// <param name="orderBy"></param> /// <param name="includeProperties"></param> /// <returns></returns> public IEnumerable <object> GetAll( Expression <Func <Register, bool> > filter = null, Func <IQueryable <Register>, IOrderedQueryable <Register> > orderBy = null, string includeProperties = "") { var registers = _siriusContext.Registers .Include(i => i.Invoice) .Include(i => i.Item) .Where(filter) .Select(r => new { r.Id, r.Item.Name, Dimension = r.Item.Dimension.Name, r.Amount, r.Cost, Sum = ((double)r.Cost * r.Amount), Date = DateConverter.ConvertToStandardString(r.Invoice.Date), r.InvoiceId }); return(registers); }
public bool SendChangePasswordEmail(IConfiguration config, string userEmail, bool isNewAccount) { var user = Context.Users.FirstOrDefault(c => c.Email == userEmail); if (user != null) { ActionToken actionToken = new ActionToken { IsActive = true, Action = "ForgotPassword", CreatedOn = DateConverter.CurrentEasternDateTime(), ExpirationDate = DateConverter.CurrentEasternDateTime().AddDays(1), IdUser = user.Id, Token = Guid.NewGuid().ToString() }; Context.ActionTokens.Add(actionToken); Context.SaveChanges(); EmailSender.SendEmailToChangePassword(userEmail, actionToken.Token, config, isNewAccount); return(true); } return(false); }
private static DataTable LoadKeHoachCongViecForCurBoPhanExport(DataTable dtCongViec, DataRow curItem, DataTable dtReturnCongViec, int idDotDanhGia, DateTime ngaybatdau, int i, out int returnIndex) { int returnIndexTemp = i; int songay = DateTime.DaysInMonth(ngaybatdau.Year, ngaybatdau.Month); DateTime _NgayBatDau, _NgayKetThuc; int level = Convert.ToInt32(curItem["Level"]); level += 1; int ID = Convert.ToInt32(curItem["IDCongViec"]); DataRow[] dtChild = GetCongViecByParentID(dtCongViec, ID); foreach (DataRow row in dtChild) { DataRow rowItem = dtReturnCongViec.NewRow(); rowItem["ID"] = row["ID"].ToString(); rowItem["IDPhongBan"] = GetPhongBan(row["IDPhongBan"]); rowItem["IDParent"] = row["IDParent"].ToString(); rowItem["Level"] = level.ToString(); rowItem["IDCongViec"] = row["IDCongViec"].ToString(); if (ConvertUtility.ToString(row["TuanLamViec"]) != "") { rowItem["Tuan"] = row["TuanLamViec"].ToString(); } else { rowItem["Tuan"] = "Đang cập nhật"; } DataTable dtTen = GetNguoiThamGiaCongViec(idDotDanhGia, ConvertUtility.ToInt32(row["IDCongViec"])); if (dtTen != null && dtTen.Rows.Count > 0) { if (ConvertUtility.ToString(dtTen.Rows[0]["Ten"]) != "") { rowItem["NguoiThamGia"] = dtTen.Rows[0]["Ten"].ToString(); } else { rowItem["NguoiThamGia"] = "Đang cập nhật"; } } else { rowItem["NguoiThamGia"] = "Đang cập nhật"; } rowItem["STT"] = i; if (level == 1) { rowItem["TenCongViec"] = MiscUtility.StringIndent(level) + row["TenCongViec"].ToString(); } else if (level == 2) { rowItem["TenCongViec"] = MiscUtility.StringIndent(level) + row["TenCongViec"].ToString(); } else if (level == 3) { rowItem["TenCongViec"] = MiscUtility.StringIndent(level) + row["TenCongViec"].ToString(); } else if (level > 3) { rowItem["TenCongViec"] = MiscUtility.StringIndent(level) + row["TenCongViec"].ToString(); } _NgayBatDau = ConvertUtility.ToDateTime(row["NgayBatDau"]); _NgayKetThuc = ConvertUtility.ToDateTime(row["NgayKetThuc"]); for (int day = 1; day < songay + 1; day++) { string dateString = day + "/" + ngaybatdau.Month + "/" + ngaybatdau.Year; DateTime dateValue = DateTime.Parse(dateString, new CultureInfo("fr-FR")); int weekOfMonth = new DateConverter().GetWeekOfMonth(dateValue); int dayOfWeek = DateConverter.GetDayOfWeek(dateValue.DayOfWeek.ToString()); if (dayOfWeek <= 8) { string trangThaiCV = GetTrangThai(ConvertUtility.ToInt32(row["TrangThaiCV"])); string commentTT = GetCongViecCommentTT(ConvertUtility.ToInt32(row["IDCongViec"]), idDotDanhGia, dateValue); string commentTK = "";//GetCongViecCommentTK(ConvertUtility.ToInt32(row["IDCongViec"]), idDotDanhGia, dateValue); string TK = ""; if (dateValue >= _NgayBatDau && dateValue <= _NgayKetThuc) { if (dateValue.Year == _NgayKetThuc.Year && dateValue.Month == _NgayKetThuc.Month && dateValue.Day == _NgayKetThuc.Day) { TK = "HT"; } else { TK = "TK"; } if (ConvertUtility.ToInt32(row["TrangThaiCV"]) == 1) { trangThaiCV = "X"; } else { if (commentTT != "") { trangThaiCV = "PS"; } else { trangThaiCV = ""; } } } else if (dateValue > _NgayKetThuc) { TK = ""; trangThaiCV = ""; commentTT = ""; } else { if (commentTT != "") { TK = ""; trangThaiCV = "PS"; } else { TK = ""; trangThaiCV = ""; commentTT = ""; } } rowItem["T" + weekOfMonth + "_T" + dayOfWeek] = TK; rowItem["T" + weekOfMonth + "_T" + dayOfWeek + "_TK"] = commentTK; rowItem["T" + weekOfMonth + "_T" + dayOfWeek + "_Status"] = trangThaiCV; rowItem["T" + weekOfMonth + "_T" + dayOfWeek + "_TT"] = commentTT; //if (dayOfWeek >= 6) //{ // if (dayOfWeek == 6) // { if (commentTT != "") { rowItem["T" + weekOfMonth + "_KQ"] = commentTT; } // else // { // rowItem["T" + weekOfMonth + "_KQ"] = ""; // } // } // else // { // if (dayOfWeek == 7) // { // if (commentTT != "") // { // rowItem["T" + weekOfMonth + "_KQ"] = commentTT; // } // } // else // { // if (commentTT != "") // { // rowItem["T" + weekOfMonth + "_KQ"] = commentTT; // } // } // } //} //else //{ // rowItem["T" + weekOfMonth + "_KQ"] = ""; //} } } //rowItem["T1_KQ"] = ""; //rowItem["T2_KQ"] = ""; //rowItem["T3_KQ"] = ""; //rowItem["T4_KQ"] = ""; //rowItem["T5_KQ"] = ""; rowItem["KQT"] = GetCongViecCamKetHT(ConvertUtility.ToInt32(row["IDCongViec"]), idDotDanhGia); dtReturnCongViec.Rows.Add(rowItem); i++; LoadKeHoachCongViecForCurBoPhanExport(dtCongViec, rowItem, dtReturnCongViec, idDotDanhGia, ngaybatdau, i, out returnIndexTemp); } returnIndex = returnIndexTemp; return dtReturnCongViec; }
public static DataTable BuildRecursiveKeHoachCongViecBoPhanExport(DataTable dtCongViec, DataTable dtReturnCongViec, int idDotDanhGia, DateTime ngaybatdau, int i, out int returnIndex) { int songay = DateTime.DaysInMonth(ngaybatdau.Year, ngaybatdau.Month); int returnIndexTemp = i; DateTime _NgayBatDau, _NgayKetThuc; DataRow[] dtLevel0 = GetCongViecByParentID(dtCongViec, 0); foreach (DataRow row in dtLevel0) { DataRow rowItem = dtReturnCongViec.NewRow(); rowItem["ID"] = row["ID"].ToString(); rowItem["IDPhongBan"] = GetPhongBan(row["IDPhongBan"]); rowItem["IDParent"] = row["IDParent"].ToString(); rowItem["Level"] = "0"; rowItem["IDCongViec"] = row["IDCongViec"].ToString(); if (ConvertUtility.ToString(row["TuanLamViec"]) != "") { rowItem["Tuan"] = row["TuanLamViec"].ToString(); } else { rowItem["Tuan"] = "Đang cập nhật"; } DataTable dtTen = GetNguoiThamGiaCongViec(idDotDanhGia, ConvertUtility.ToInt32(row["IDCongViec"])); if (dtTen != null && dtTen.Rows.Count > 0) { if (ConvertUtility.ToString(dtTen.Rows[0]["Ten"]) != "") { rowItem["NguoiThamGia"] = dtTen.Rows[0]["Ten"].ToString(); } else { rowItem["NguoiThamGia"] = "Đang cập nhật"; } } else { rowItem["NguoiThamGia"] = "Đang cập nhật"; } rowItem["STT"] = returnIndexTemp; DataTable dtMaNhom = GetMaNhomCongViec(ConvertUtility.ToInt32(row["IDCongViec"])); string MaNhom = "[]"; if (dtMaNhom != null && dtMaNhom.Rows.Count > 0) { MaNhom = "[" + dtMaNhom.Rows[0]["Ma"].ToString() + "] "; } rowItem["TenCongViec"] = MaNhom + row["TenCongViec"].ToString(); _NgayBatDau = ConvertUtility.ToDateTime(row["NgayBatDau"]); _NgayKetThuc = ConvertUtility.ToDateTime(row["NgayKetThuc"]); for (int day = 1; day < songay + 1; day++) { string dateString = day + "/" + ngaybatdau.Month + "/" + ngaybatdau.Year; DateTime dateValue = DateTime.Parse(dateString, new CultureInfo("fr-FR")); int weekOfMonth = new DateConverter().GetWeekOfMonth(dateValue); int dayOfWeek = (int)dateValue.DayOfWeek; if (dayOfWeek == 0) continue; dayOfWeek = dayOfWeek + 1; if (dayOfWeek <= 8) { string trangThaiCV = GetTrangThai(ConvertUtility.ToInt32(row["TrangThaiCV"])); string commentTT = GetCongViecCommentTT(ConvertUtility.ToInt32(row["IDCongViec"]), idDotDanhGia, dateValue); string commentTK = "";// GetCongViecCommentTK(ConvertUtility.ToInt32(row["IDCongViec"]), idDotDanhGia, dateValue); string TK = ""; if (dateValue >= _NgayBatDau && dateValue <= _NgayKetThuc) { TK = "TK"; if (ConvertUtility.ToInt32(row["TrangThaiCV"]) == 1) { trangThaiCV = "X"; } else { if (commentTT != "") { trangThaiCV = "PS"; } else { TK = ""; trangThaiCV = ""; } } } else if (dateValue > _NgayKetThuc) { TK = ""; trangThaiCV = ""; commentTT = ""; } else { if (commentTT != "") { TK = "TK"; trangThaiCV = "PS"; } else { TK = ""; trangThaiCV = ""; commentTT = ""; } } rowItem["T" + weekOfMonth + "_T" + dayOfWeek] = TK; rowItem["T" + weekOfMonth + "_T" + dayOfWeek + "_TK"] = commentTK; rowItem["T" + weekOfMonth + "_T" + dayOfWeek + "_Status"] = trangThaiCV; rowItem["T" + weekOfMonth + "_T" + dayOfWeek + "_TT"] = commentTT; //if (dayOfWeek >= 6) //{ // if (dayOfWeek == 6) // { if (commentTT != "") { rowItem["T" + weekOfMonth + "_KQ"] = commentTT; } // else // { // rowItem["T" + weekOfMonth + "_KQ"] = ""; // } // } // else // { // if (dayOfWeek == 7) // { // if (commentTT != "") // { // rowItem["T" + weekOfMonth + "_KQ"] = commentTT; // } // } // else // { // if (commentTT != "") // { // rowItem["T" + weekOfMonth + "_KQ"] = commentTT; // } // } // } //} //else //{ // rowItem["T" + weekOfMonth + "_KQ"] = ""; //} } } rowItem["KQT"] = GetCongViecCamKetHT(ConvertUtility.ToInt32(row["IDCongViec"]), idDotDanhGia); dtReturnCongViec.Rows.Add(rowItem); returnIndexTemp++; LoadKeHoachCongViecForCurBoPhanExport(dtCongViec, rowItem, dtReturnCongViec, idDotDanhGia, ngaybatdau, returnIndexTemp, out returnIndexTemp); } returnIndex = returnIndexTemp; return dtReturnCongViec; }