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