protected void NextMonth() { CurrentDate = CurrentDate.AddMonths(1); GetDates(); StateHasChanged(); }
public void LoadCurrentDate(CurrentDate newCurrentDate) { currentDate = newCurrentDate; SetCurrentDateText(); SetCurrentTimeText(); }
public ActionResult SetDetail() { int id = Request.Form["SeriesId"].ParseInt(); TblPileSeries ob = uow.Modules.PileSeries.Get(id); ob.SeriesName = Request.Form["SeriesName"]; ob.SeriesOrder = Request.Form["SeriesOrder"].ParseInt(); try { if (Request.Files.Count > 0 && Request.Files["SeriesImage"] != null && Request.Files["SeriesImage"].ContentLength > 0) { string oldPath = ob.SeriesImage; HttpPostedFileBase uploadedFile = Request.Files["SeriesImage"]; string FilePath = string.Format("files/products/{0}{1}", CurrentDate.ParseString(DateFormat._yyyyMMddHHmmssfff), Path.GetExtension(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath("~/files"))) { Directory.CreateDirectory(Server.MapPath("~/files")); } if (!Directory.Exists(Server.MapPath("~/files/products"))) { Directory.CreateDirectory(Server.MapPath("~/files/products")); } uploadedFile.SaveAs(Server.MapPath("~/" + FilePath)); ob.SeriesImage = FilePath; if (!string.IsNullOrWhiteSpace(oldPath) && IOFile.Exists(Server.MapPath("~/" + oldPath))) { IOFile.Delete(Server.MapPath("~/" + oldPath)); } } else { throw new Exception("กรุณาระบุรูปซีรี่ย์ของสินค้า"); } //Validate model b4 save uow.Modules.PileSeries.Set(ob); uow.SaveChanges(); return(RedirectToAction("Index", new { area = "", controller = MVCController, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); } catch (Exception ex) { string msg = ex.GetMessage(true); return(ViewDetail(ob, msg, AlertMsgType.Danger)); } }
/// <summary> /// Draws calendar item according to dates /// </summary> private void DrawItems(Graphics graphics) { foreach (var row in listRows) { if (row.IsVisible) { foreach (var item in row.Items) { var isSelected = item == _selectedItem; var level = listRows.IndexOf(row); DateTime dStart = item.StartDate.Date; DateTime dEnd = item.EndDate.Date; // Looks for the left x coord according to date var x1 = ColumnCoord.Where(d => d.DateValue.Date == dStart).SingleOrDefault(); // Gets y coord according to row var yCoord = RowCoord.Where(d => d.RowIndex == level).SingleOrDefault(); // Looks for the right x coord according to date var x2 = ColumnCoord.Where(d => d.DateValue.Date == dEnd).SingleOrDefault(); int y = yCoord.FirstCoord + item.Layer * (ItemHeight + shadowItemRect); int width; Rectangle rect; // if Start Date and End Date in the week interval if (dStart >= CurrentDate && dEnd <= CurrentDate.AddDays(_dayCount - 1)) { width = x2.SecondCoord - x1.FirstCoord - 2 * smallWhiteRectWidth; if (item.Rectangle.Width == 0 && item.Rectangle.Height == 0) { rect = new Rectangle(x1.FirstCoord + smallWhiteRectWidth, y, width, ItemHeight); item.Rectangle = rect; } else { rect = item.Rectangle; } DrawItemRect(graphics, item.Subject, rect.X, rect.Y, rect.Width, rect.Height, true, true, item.BackColor, isSelected); } // if End Date is not in the week interval if (dStart >= CurrentDate && dEnd > CurrentDate.AddDays(_dayCount - 1) && x1 != null) { width = Width - x1.FirstCoord; if (item.Rectangle.Width == 0 && item.Rectangle.Height == 0) { rect = new Rectangle(x1.FirstCoord + smallWhiteRectWidth, y, width, ItemHeight); item.Rectangle = rect; } else { rect = item.Rectangle; } DrawItemRect(graphics, item.Subject, rect.X, rect.Y, rect.Width, rect.Height, true, false, item.BackColor, isSelected); } // if Start Date is not in the week interval if (dStart < CurrentDate && dEnd <= CurrentDate.AddDays(_dayCount - 1) && x2 != null) { width = x2.SecondCoord - LeftMargin - smallWhiteRectWidth; if (item.Rectangle.Width == 0 && item.Rectangle.Height == 0) { rect = new Rectangle(LeftMargin, y, width, ItemHeight); item.Rectangle = rect; } else { rect = item.Rectangle; } DrawItemRect(graphics, item.Subject, rect.X, rect.Y, rect.Width, rect.Height, false, true, item.BackColor, isSelected); } // if Start Date is not in the week interval if (dStart < CurrentDate && dEnd > CurrentDate.AddDays(_dayCount - 1)) { width = Width - LeftMargin; if (item.Rectangle.Width == 0 && item.Rectangle.Height == 0) { rect = new Rectangle(LeftMargin, y, width, ItemHeight); item.Rectangle = rect; } else { rect = item.Rectangle; } DrawItemRect(graphics, item.Subject, rect.X, rect.Y, rect.Width, rect.Height, false, true, item.BackColor, isSelected); } } } } }
protected void btnSignIn_Click(object sender, EventArgs e) { try { SQLProcs sqlobj = new SQLProcs(); DataSet dsChkAct = new DataSet(); DataSet dsChkPwd = new DataSet(); DataSet dsChkSt = new DataSet(); DataSet dsChkPwdDt = new DataSet(); Session["UserID"] = string.Empty; Session["SUPASSWORD"] = txtPlainPassword.Text; DataSet dsCompanyDetails = new DataSet(); if (txtUserID.Text == "admin" && txtPlainPassword.Text == "a#m$n~") { Session["UserID"] = txtUserID.Text; Session["SUPASSWORD"] = txtPlainPassword.Text; Response.Redirect("Admin.aspx"); //FormsAuthentication.RedirectFromLoginPage(txtUserID.Text, false); } else { // -- Start check balance DateTime LastDebitDate; DateTime CurrentDate; DataSet dsCheckFirstLogin = sqlobj.SQLExecuteDataset("SP_GetDebitDate"); if (dsCheckFirstLogin.Tables[0].Rows.Count > 0) { string sdate = dsCheckFirstLogin.Tables[0].Rows[0]["LastDebitDate"].ToString(); string ldd = ""; string cdd = ""; if (dsCheckFirstLogin.Tables[1].Rows.Count > 0) { LastDebitDate = Convert.ToDateTime(dsCheckFirstLogin.Tables[0].Rows[0]["LastDebitDate"].ToString()); CurrentDate = DateTime.Now; ldd = LastDebitDate.ToString("dd-MM-yyyy"); cdd = CurrentDate.ToString("dd-MM-yyyy"); } else { LastDebitDate = DateTime.Now.AddDays(-1); CurrentDate = DateTime.Now; ldd = LastDebitDate.ToString("dd-MM-yyyy"); cdd = CurrentDate.ToString("dd-MM-yyyy"); } if (ldd.Equals(cdd)) { dsCompanyDetails = sqlobj.SQLExecuteDataset("SP_GetCompanyDetails"); if (dsCompanyDetails.Tables[0].Rows.Count != 0) { string strproductname = dsCompanyDetails.Tables[0].Rows[0]["productname"].ToString(); if (strproductname != "") { dsChkAct = sqlobj.SQLExecuteDataset("proc_LoginCheck", new SqlParameter() { ParameterName = "@UserID", SqlDbType = SqlDbType.NVarChar, Value = txtUserID.Text }, new SqlParameter() { ParameterName = "@Password", SqlDbType = SqlDbType.NVarChar, Value = Session["SUPASSWORD"].ToString() }); if (dsChkAct != null && dsChkAct.Tables.Count > 0 && dsChkAct.Tables[0].Rows.Count > 0) { ////Check Status //dsChkSt = sqlobj.SQLExecuteDataset("SP_CheckStatus", // new SqlParameter() { ParameterName = "@UserID", SqlDbType = SqlDbType.NVarChar, Value = txtUserID.Text }, // new SqlParameter() { ParameterName = "@Password", SqlDbType = SqlDbType.NVarChar, Value = txtPlainPassword.Text }); if (dsChkAct.Tables[0].Rows.Count != 0) { dsChkPwd = sqlobj.SQLExecuteDataset("SP_CheckUIPwd", new SqlParameter() { ParameterName = "@UserID", SqlDbType = SqlDbType.NVarChar, Value = txtUserID.Text }, new SqlParameter() { ParameterName = "@Password", SqlDbType = SqlDbType.NVarChar, Value = Session["SUPASSWORD"].ToString() }); if (dsChkPwd.Tables[0].Rows.Count == 0) { //Session["UserID"] = txtUserID.Text.Trim(); Session["UserID"] = dsChkAct.Tables[0].Rows[0]["UserID"].ToString(); Session["Action"] = "LogIn"; InsertLoginAudit(); InsertUsageLog(); FormsAuthentication.RedirectFromLoginPage(txtUserID.Text, false); //Response.Redirect("ManageNTaskList.aspx?UserName="******"UserID"].ToString()); //Response.Redirect("Home.aspx"); return; } else { Session["UserID"] = txtUserID.Text; Session["Action"] = "Failed"; InsertLoginAudit(); ScriptManager.RegisterStartupScript(this, this.GetType(), "Function", "NavigateDir2();", true); return; } } else { Session["UserID"] = txtUserID.Text; Session["Action"] = "Failed"; InsertLoginAudit(); WebMsgBox.Show("Access Denied: User is Terminated/Blocked"); //msgbox.ShowError("Access Denied: User is Terminated/Blocked"); } } else { Session["UserID"] = txtUserID.Text; Session["Action"] = "Failed"; InsertLoginAudit(); WebMsgBox.Show("Access Denied: Invalid User ID / Password"); return; } } else { WebMsgBox.Show("OOPS! Something is broken! Contact the dealer from whom you bought the software license."); } } } else { //RadWindowManager1.RadConfirm("<b>FIRST SIGN-IN FOR THE DAY</b>.<br/><b>USAGE FEES WILL BE DEDUCTED NOW.</b><br/><b>CONFIRM?</b>", "confirmStatusCallbackFn", 400, 200, null, "Confirm"); ScriptManager.RegisterStartupScript(this, this.GetType(), "CallConfirmBox", "CallConfirmBox();", true); // ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "MyFun1", "confirmStatusCallbackFn();", true); // RadWindowManager1.onclien //RadWindow2.VisibleOnPageLoad = true; // RadWindow2.Visible = true; } //else //{ // //RadWindowManager1.RadConfirm("<b>FIRST SIGN-IN FOR THE DAY</b>.<br/><b>USAGE FEES WILL BE DEDUCTED NOW.</b><br/><b>CONFIRM?</b>", "confirmStatusCallbackFn", 400, 200, null, "Confirm"); // // ScriptManager.RegisterStartupScript(this, this.GetType(), "CallConfirmBox", "CallConfirmBox();", true); // // ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "MyFun1", "confirmStatusCallbackFn();", true); // Response.Redirect("PayDetails.aspx", false); //} } } // End check Balance } catch (Exception ex) { WebMsgBox.Show(ex.Message.ToString()); } }
private void SubtractSevenDays() { CurrentDate = CurrentDate.AddDays(-7); CurrentWeek = CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(CurrentDate, CalendarWeekRule.FirstDay, DayOfWeek.Monday); FillSchedule(); }
public Score UserContributionPoints(string userName, ContentType contentType, string subverse = null, bool isReceived = true, TimeSpan?timeSpan = null, DateTime?cutOffDate = null) { Func <IEnumerable <dynamic>, Score> processRecords = new Func <IEnumerable <dynamic>, Score>(records => { Score score = new Score(); if (records != null && records.Any()) { foreach (var record in records) { if (record.VoteStatus == 1) { score.UpCount = isReceived ? (int)record.VoteValue : (int)record.VoteCount; } else if (record.VoteStatus == -1) { score.DownCount = isReceived ? (int)record.VoteValue : (int)record.VoteCount; } } } return(score); }); var groupingClause = $"SELECT \"UserName\", \"IsReceived\", \"ContentType\", \"VoteStatus\", SUM(\"VoteCount\") AS \"VoteCount\", SUM(\"VoteValue\") AS \"VoteValue\" FROM ({"{0}"}) AS a GROUP BY a.\"UserName\", a.\"IsReceived\", a.\"ContentType\", a.\"VoteStatus\""; var archivedPointsClause = $"SELECT \"UserName\", \"IsReceived\", \"ContentType\", \"VoteStatus\", \"VoteCount\", \"VoteValue\" FROM {SqlFormatter.Table("UserContribution", "uc", null, "NOLOCK")} WHERE uc.\"UserName\" = @UserName AND uc.\"IsReceived\" = @IsReceived AND uc.\"ContentType\" = @ContentType UNION ALL "; var alias = ""; DateTime?dateRange = timeSpan.HasValue ? CurrentDate.Subtract(timeSpan.Value) : (DateTime?)null; Score s = new Score(); using (var db = new VoatDataContext()) { var contentTypes = contentType.GetEnumFlags(); foreach (var contentTypeToQuery in contentTypes) { var q = new DapperQuery(); switch (contentTypeToQuery) { case ContentType.Comment: //basic point calc query q.Select = $"SELECT @UserName AS \"UserName\", @IsReceived AS \"IsReceived\", @ContentType AS \"ContentType\", v.\"VoteStatus\" AS \"VoteStatus\", 1 AS \"VoteCount\", ABS(v.\"VoteValue\") AS \"VoteValue\" FROM {SqlFormatter.Table("CommentVoteTracker", "v", null, "NOLOCK")} "; q.Select += $"INNER JOIN {SqlFormatter.Table("Comment", "c", null, "NOLOCK")} ON c.\"ID\" = v.\"CommentID\" INNER JOIN {SqlFormatter.Table("Submission", "s", null, "NOLOCK")} ON s.\"ID\" = c.\"SubmissionID\""; //This controls whether we search for given or received votes alias = (isReceived ? "c" : "v"); q.Append(x => x.Where, $"{alias}.\"UserName\" = @UserName"); break; case ContentType.Submission: //basic point calc query q.Select = $"SELECT @UserName AS \"UserName\", @IsReceived AS \"IsReceived\", @ContentType AS \"ContentType\", v.\"VoteStatus\" AS \"VoteStatus\", 1 AS \"VoteCount\", ABS(v.\"VoteValue\") AS \"VoteValue\" FROM {SqlFormatter.Table("SubmissionVoteTracker", "v", null, "NOLOCK")} INNER JOIN {SqlFormatter.Table("Submission", "s", null, "NOLOCK")} ON s.\"ID\" = v.\"SubmissionID\""; //This controls whether we search for given or received votes alias = (isReceived ? "s" : "v"); q.Append(x => x.Where, $"{alias}.\"UserName\" = @UserName"); break; default: throw new NotImplementedException($"Type {contentType.ToString()} is not supported"); } //if subverse/daterange calc we do not use archived table if (!String.IsNullOrEmpty(subverse) || dateRange.HasValue) { if (!String.IsNullOrEmpty(subverse)) { q.Append(x => x.Where, "s.\"Subverse\" = @Subverse"); } if (dateRange.HasValue) { q.Append(x => x.Where, "v.\"CreationDate\" >= @DateRange"); } } else { q.Select = archivedPointsClause + q.Select; q.Append(x => x.Where, "s.\"ArchiveDate\" IS NULL"); } string statement = String.Format(groupingClause, q.ToString()); System.Diagnostics.Debug.WriteLine("Query Output"); System.Diagnostics.Debug.WriteLine(statement); var records = db.Connection.Query(statement, new { UserName = userName, IsReceived = isReceived, Subverse = subverse, ContentType = (int)contentType, DateRange = dateRange }); Score result = processRecords(records); s.Combine(result); } } return(s); }
public ActionResult SetDetail() { int accountId = Request.Form["account_id"].ParseInt(); SysAccount ob = uow.Account.Get(accountId); if (ob.AccountId <= 0) { ob.AccountPassword = Request.Form["account_password"]; ob.CreatedBy = CurrentUID; ob.CreatedDate = CurrentDateTime; } ob.AccountFirstName = Request.Form["account_firstname"]; ob.AccountLastName = Request.Form["account_lastname"]; ob.AccountUsername = "******" + CurrentDateTime.ToString("yyyyMMddHHmmss"); //Request.Form["account_username"]; ob.AccountEmail = Request.Form["account_email"]; ob.FlagStatus = Request.Form["flag_status"].ParseInt(); ob.FlagAdminCalc = Request.Form["flag_admin_cal"].ParseBoolean(); ob.UpdatedBy = CurrentUID; ob.UpdatedDate = CurrentDateTime; try { if (!ob.ValidateModel(out string errMsg)) { throw new Exception(errMsg); } if (Request.Files.Count > 0 && Request.Files["AccountAvatar"] != null && Request.Files["AccountAvatar"].ContentLength > 0) { HttpPostedFileBase uploadedFile = Request.Files["AccountAvatar"]; string FilePath = string.Format("files/avatar/{0}{1}", CurrentDate.ParseString(DateFormat._yyyyMMddHHmmssfff), Path.GetExtension(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath("~/files"))) { Directory.CreateDirectory(Server.MapPath("~/files")); } if (!Directory.Exists(Server.MapPath("~/files/avatar"))) { Directory.CreateDirectory(Server.MapPath("~/files/avatar")); } uploadedFile.SaveAs(Server.MapPath("~/" + FilePath)); ob.AccountAvatar = FilePath; } if ((ob.AccountId <= 0 && ob.AccountPassword != Request.Form["account_passwordre"]) || (ob.AccountId > 0 && !string.IsNullOrWhiteSpace(Request.Form["account_password"]) && Request.Form["account_password"] != Request.Form["account_passwordre"])) { throw new Exception("รหัสผ่านไม่ตรงกัน"); } if (!ob.FlagSystem) { SysAccountRole roleMapped = ob.AccountId > 0 ? ((from d in uow.db.SysAccountRole join r in uow.db.SysRole on d.RoleId equals r.RoleId where d.AccountId == ob.AccountId && r.SiteId == SITE_ID select d).FirstOrDefault() ?? new SysAccountRole() { SysAccount = ob }) : new SysAccountRole() { SysAccount = ob }; roleMapped.RoleId = Request.Form["role_id"].ParseInt(); if (roleMapped.Id <= 0) { uow.db.SysAccountRole.Add(roleMapped); } else { uow.db.Entry(roleMapped).State = System.Data.Entity.EntityState.Modified; } } if (ob.AccountId <= 0) { ob.AccountPassword = Crypto.HashPassword(ob.AccountPassword); } else if (ob.AccountId > 0 && !string.IsNullOrWhiteSpace(Request.Form["account_password"])) { ob.AccountPassword = Crypto.HashPassword(Request.Form["account_password"]); } uow.Account.Set(ob); if (ob.FlagAdminCalc && ob.AccountId > 0) { var delData = db.CalcAccountStaff.Where(x => x.AccountId == ob.AccountId); db.CalcAccountStaff.RemoveRange(delData); db.SaveChanges(); } uow.SaveChanges(); return(RedirectToAction("Index", new { area = "", controller = "Account", msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); } catch (DbEntityValidationException ex) { string msg = ""; foreach (var eve in ex.EntityValidationErrors) { msg += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { msg += string.Format("{{\n}}- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return(ViewDetail(ob, msg, AlertMsgType.Danger)); } catch (Exception ex) { string msg = ex.GetMessage(); return(ViewDetail(ob, msg, AlertMsgType.Danger)); } }
public void RenderMonthNavigator() { // Set the label to the month of the current date LabelCurrentMonth.Content = CurrentDate.ToString("MMMM yyyy"); }
public async Task <CommandResponse <Domain.Models.Vote> > SaveVote(Domain.Models.Vote vote) { DemandAuthentication(); var newDataModel = VoteDomainMaps.Map(vote); var domainModel = vote; //UPDATE if (newDataModel.ID > 0) { var existingDataModel = await GetVoteDataModel(newDataModel.ID); //Check some basics if (existingDataModel == null) { return(CommandResponse.FromStatus <Domain.Models.Vote>(null, Status.Error, "Vote can not be found")); } if (!existingDataModel.CreatedBy.IsEqual(User.Identity.Name) && !User.IsInAnyRole(new[] { UserRole.GlobalAdmin, UserRole.Admin })) { return(CommandResponse.FromStatus <Domain.Models.Vote>(null, Status.Error, "Vote can not be edited by current user")); } if (existingDataModel.StartDate <= CurrentDate) { return(CommandResponse.FromStatus <Domain.Models.Vote>(null, Status.Error, "Vote can not be edited once voting has begun")); } //TODO: Verify incoming model ids all belong to this vote var restrictionsAreBelongToUs = newDataModel.VoteRestrictions.Where(x => x.ID > 0).All(x => existingDataModel.VoteRestrictions.Any(e => e.ID == x.ID)); if (!restrictionsAreBelongToUs) { return(CommandResponse.FromStatus <Domain.Models.Vote>(null, Status.Error, "Message integrity violated (Restrictions)")); } var optionsAreBelongToUs = newDataModel.VoteOptions.Where(x => x.ID > 0).All(x => existingDataModel.VoteOptions.Any(e => e.ID == x.ID)); if (!optionsAreBelongToUs) { return(CommandResponse.FromStatus <Domain.Models.Vote>(null, Status.Error, "Message integrity violated (Options)")); } var outcomesAreBelongToUs = newDataModel.VoteOptions.Where(x => x.ID > 0).SelectMany(x => x.VoteOutcomes.Where(o => o.ID > 0)).All(x => existingDataModel.VoteOptions.SelectMany(y => y.VoteOutcomes).Any(e => e.ID == x.ID)); if (!outcomesAreBelongToUs) { return(CommandResponse.FromStatus <Domain.Models.Vote>(null, Status.Error, "Message integrity violated (Outcomes)")); } existingDataModel.LastEditDate = CurrentDate; existingDataModel.Title = newDataModel.Title; existingDataModel.Content = newDataModel.Content; existingDataModel.FormattedContent = newDataModel.FormattedContent; newDataModel.VoteOptions.ForEachIndex((option, index) => { //TODO: Ensure ID belongs to proper vote (aka fuzzy will exploit this) if (option.ID > 0) { //Update Existing var existingOption = existingDataModel.VoteOptions.FirstOrDefault(x => x.ID == option.ID); existingOption.Title = option.Title; existingOption.Content = option.Content; existingOption.FormattedContent = option.FormattedContent; existingOption.SortOrder = index; option.VoteOutcomes.ForEachIndex((outcome, oIndex) => { if (outcome.ID > 0) { var existingOutcome = existingDataModel.VoteOptions[index].VoteOutcomes.FirstOrDefault(x => x.ID == outcome.ID); existingOutcome.Type = outcome.Type; existingOutcome.Data = outcome.Data; } else { var newOutcome = new VoteOutcome(); newOutcome.Type = outcome.Type; newOutcome.Data = outcome.Data; existingOption.VoteOutcomes.Add(newOutcome); } }); //Remove deleted outcomes var deletedOutcomes = existingOption.VoteOutcomes.Where(c => !option.VoteOutcomes.Any(n => c.ID == n.ID)).ToList(); deletedOutcomes.ForEach(x => existingOption.VoteOutcomes.Remove(x)); } else { //Add new var newOption = new Data.Models.VoteOption(); newOption.Title = option.Title; newOption.Content = option.Content; newOption.FormattedContent = option.FormattedContent; newOption.SortOrder = index; existingDataModel.VoteOptions.Add(newOption); option.VoteOutcomes.ForEachIndex((outcome, oIndex) => { var newOutcome = new VoteOutcome(); newOutcome.Type = outcome.Type; newOutcome.Data = outcome.Data; newOption.VoteOutcomes.Add(newOutcome); }); } }); //Remove deleted options var deletedOptions = existingDataModel.VoteOptions.Where(c => !newDataModel.VoteOptions.Any(n => c.ID == n.ID)).ToList(); deletedOptions.ForEach(x => existingDataModel.VoteOptions.Remove(x)); //handle restrictions newDataModel.VoteRestrictions.ForEachIndex((restriction, index) => { if (restriction.ID > 0) { //Update Existing var existingRestriction = existingDataModel.VoteRestrictions.FirstOrDefault(x => x.ID == restriction.ID); existingRestriction.Type = restriction.Type; existingRestriction.Data = restriction.Data; } else { //Add new var newRestriction = new Data.Models.VoteRestriction(); newRestriction.Type = restriction.Type; newRestriction.Data = restriction.Data; existingDataModel.VoteRestrictions.Add(newRestriction); } }); //Remove deleted options var deletedRestrictions = existingDataModel.VoteRestrictions.Where(c => !newDataModel.VoteRestrictions.Any(n => c.ID == n.ID)).ToList(); deletedRestrictions.ForEach(x => existingDataModel.VoteRestrictions.Remove(x)); await _db.SaveChangesAsync(); return(CommandResponse.FromStatus <Domain.Models.Vote>(existingDataModel.Map(), Status.Success)); } //NEW else { newDataModel.CreatedBy = User.Identity.Name; newDataModel.CreationDate = CurrentDate; //TODO: Set start end dates according to logic newDataModel.StartDate = CurrentDate.AddDays(7); newDataModel.EndDate = CurrentDate.AddDays(14); _db.Vote.Add(newDataModel); await _db.SaveChangesAsync(); domainModel = VoteDomainMaps.Map(newDataModel); return(CommandResponse.FromStatus <Domain.Models.Vote>(newDataModel.Map(), Status.Success)); } }
public ActionResult SetProfile() { int accountId = Session["sid"].Convert2String().ParseInt(); SysAccount ob = uow.Account.Get(accountId); ob.AccountFirstName = Request.Form["account_firstname"]; ob.AccountLastName = Request.Form["account_lastname"]; ob.AccountEmail = Request.Form["account_email"]; ob.UpdatedBy = CurrentUID; ob.UpdatedDate = CurrentDateTime; try { if (!ob.ValidateModel(out string errMsg)) { throw new Exception(errMsg); } bool clearOld = false; string oldAvatar = ob.AccountAvatar; if (Request.Files.Count > 0 && Request.Files["AccountAvatar"] != null && Request.Files["AccountAvatar"].ContentLength > 0) { HttpPostedFileBase uploadedFile = Request.Files["AccountAvatar"]; string FilePath = string.Format("files/avatar/{0}{1}", CurrentDate.ParseString(DateFormat._yyyyMMddHHmmssfff), Path.GetExtension(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath("~/files"))) { Directory.CreateDirectory(Server.MapPath("~/files")); } if (!Directory.Exists(Server.MapPath("~/files/avatar"))) { Directory.CreateDirectory(Server.MapPath("~/files/avatar")); } uploadedFile.SaveAs(Server.MapPath("~/" + FilePath)); ob.AccountAvatar = FilePath; clearOld = true; } if ((ob.AccountId <= 0 && ob.AccountPassword != Request.Form["account_passwordre"]) || (ob.AccountId > 0 && !string.IsNullOrWhiteSpace(Request.Form["account_password"]) && Request.Form["account_password"] != Request.Form["account_passwordre"])) { throw new Exception("รหัสผ่านไม่ตรงกัน"); } if (ob.AccountId > 0 && !string.IsNullOrWhiteSpace(Request.Form["account_password"])) { ob.AccountPassword = Crypto.HashPassword(Request.Form["account_password"]); } uow.Account.Set(ob); uow.SaveChanges(); if (clearOld && !string.IsNullOrWhiteSpace(oldAvatar) && FileIO.Exists(Server.MapPath("~/" + oldAvatar))) { FileIO.Delete(Server.MapPath("~/" + oldAvatar)); } return(RedirectToAction("Index", new { area = "", controller = "Home", msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); } catch (DbEntityValidationException ex) { string msg = ""; foreach (var eve in ex.EntityValidationErrors) { msg += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { msg += string.Format("{{\n}}- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return(ViewProfile(ob, msg, AlertMsgType.Danger)); } catch (Exception ex) { string msg = ex.GetMessage(); return(ViewProfile(ob, msg, AlertMsgType.Danger)); } }
public ActionResult Export(int id) { try { TblCalLoad ob = db.TblCalLoad .Where(x => x.CalId == id) .FirstOrDefault(); if (ob == null) { throw new Exception("Data not found."); } SoilCalculatedModel md = new SoilCalculatedModel(uow) { inputC = ob.InputC, inputDegree = ob.InputDegree, ModelId = ob.ModelId, inputSafeload = ob.InputSafeLoad }; ReportDataSource rptData = new ReportDataSource("db", new List <SysParameter>()); ReportViewer rptViewer = new ReportViewer(); rptViewer.ProcessingMode = ProcessingMode.Local; rptViewer.LocalReport.ReportPath = Server.MapPath("~/reports/rptLoadCalculator.rdlc"); rptViewer.LocalReport.EnableExternalImages = true; string imagePath = new Uri(Server.MapPath("~/" + ob.PileModel().TblPileSeries.SeriesImage)).AbsoluteUri; rptViewer.LocalReport.SetParameters(new ReportParameter("imagePile", imagePath)); rptViewer.LocalReport.SetParameters(new ReportParameter("pileWidth", (md.ModelInfo.PileDia * 1000).ToString("#,##0"))); rptViewer.LocalReport.SetParameters(new ReportParameter("pileLength", md.ModelInfo.PileLength.ToString("#,##0"))); rptViewer.LocalReport.SetParameters(new ReportParameter("inputC", md.inputC.ToString())); rptViewer.LocalReport.SetParameters(new ReportParameter("inputDegree", md.inputDegree.ToString())); rptViewer.LocalReport.SetParameters(new ReportParameter("inputModel", md.ModelInfo.PileName)); rptViewer.LocalReport.SetParameters(new ReportParameter("dataSu", md.inputC.ToString())); rptViewer.LocalReport.SetParameters(new ReportParameter("dataDia", md.ClayDia.ToString("#,##0.000"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataAb", md.ClayAb.ToString("#,##0.00000"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataQb", md.Qu.ToString("#,##0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataShearH", md.ShearH.ToString())); rptViewer.LocalReport.SetParameters(new ReportParameter("dataShearArea", md.ShearArea.ToString("#,##0.000"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataShearResist", md.ShearResist.ToString("#,##0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataQComp", md.UltCompressForce.ToString("#,##0"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataSafeLoadComp", md.Qcomp.ToString("#,##0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataHCone", md.UpliftH.ToString("#,##0.000"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataWeightOfSoil", md.WeightOfSoil.ToString("#,##0"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataQUplift", md.UltUpliftForce.ToString("#,##0"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataSafeLoadUplift", md.Quplift.ToString("#,##0.00"))); rptViewer.LocalReport.DataSources.Clear(); rptViewer.LocalReport.DataSources.Add(rptData); Warning[] warnings; string[] streamids; string mimeType; string encoding; string filenameExtension; byte[] bytes = rptViewer.LocalReport.Render( "PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename= LoadCalc-" + CurrentDate.ToString("yyyy-MM-dd_HHmmss") + "." + filenameExtension); Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file Response.Flush(); // send it to the client to download Response.End(); return(View()); } catch (Exception ex) { return(RedirectToAction("Index", "KPT", new { msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
public void FixtureTearDown() { CurrentDate.Setup(() => DateTime.Now); }
private void ButtonBase2_OnClick(object sender, RoutedEventArgs e) { CurrentDate = CurrentDate.AddMonths(1); Draw(); }
void MapDateToProperties() { CurrentDay = CurrentDate.ToString("dd"); CurrentMonth = CurrentDate.ToString("MMMM"); CurrentYear = CurrentDate.ToString("yyyy"); }
private void Next_Executed(object sender, ExecutedRoutedEventArgs e) { // Render the calendar with the next month RenderCalendar(CurrentDate.AddMonths(1)); }
private void RefreshData() { CurrentMainValue = 0; CurrentMonthText = CurrentDate.ToString("MMMM"); DiagramList = new ObservableCollection <PercentageCategory>(); }
private void Previous_Executed(object sender, ExecutedRoutedEventArgs e) { // Render the calendar with the previous month RenderCalendar(CurrentDate.AddMonths(-1)); }
//[ValidateAntiForgeryToken] public async Task <ActionResult> Create(usuarios usuario, HttpPostedFileBase file) { if (ModelState.IsValid) { DateTime today = CurrentDate.getNow(); usuario.created_at = today; usuario.updated_at = today; usuario.activo = true; if (file != null) { byte[] bNonNull = new byte[file.ContentLength]; Image img = Image.FromStream(file.InputStream, true, true); ImageCodecInfo pngInfo = ImageCodecInfo.GetImageEncoders().Where(codecInfo => codecInfo.MimeType == "image/png").First(); using (Stream s = new MemoryStream()) { using (EncoderParameters encParams = new EncoderParameters(1)) { encParams.Param[0] = new EncoderParameter(Encoder.Compression, (long)EncoderValue.CompressionLZW); //quality should be in the range [0..100] img.Save(s, pngInfo, encParams); } s.Position = 0; s.Read(bNonNull, 0, (int)s.Length); } usuario.foto = Convert.ToBase64String(bNonNull); } usuario.deleted_at = null; db.usuarios.Add(usuario); int i = await db.SaveChangesAsync(); if (i > 0) { usuarios createdUser = db.usuarios.Where(u => u.codigo == usuario.codigo).FirstOrDefault(); usuario_permisos usrAccesses = new usuario_permisos(); usrAccesses.usuario_id = createdUser.id; usrAccesses.created_at = today; usrAccesses.updated_at = today; switch (createdUser.tipo) { case UserProfiles.Default: goto default; case UserProfiles.Nutricionista: usrAccesses.permiso_id = db.permisos.Where(p => p.codigo_interno == "nut_home").Select(p => p.id).FirstOrDefault(); break; case UserProfiles.Vendedor: usrAccesses.permiso_id = db.permisos.Where(p => p.codigo_interno == "sales_home").Select(p => p.id).FirstOrDefault(); break; case UserProfiles.Entrenador: usrAccesses.permiso_id = db.permisos.Where(p => p.codigo_interno == "training_home").Select(p => p.id).FirstOrDefault(); break; case UserProfiles.Cajero: goto default; case UserProfiles.Sistemas: usrAccesses.permiso_id = db.permisos.Where(p => p.codigo_interno == "sys_home").Select(p => p.id).FirstOrDefault(); break; case UserProfiles.Pesos_y_Medidas: usrAccesses.permiso_id = db.permisos.Where(p => p.codigo_interno == "pym_home").Select(p => p.id).FirstOrDefault(); break; case UserProfiles.Cardiología: goto default; case UserProfiles.Marketing: usrAccesses.permiso_id = db.permisos.Where(p => p.codigo_interno == "mkt_home").Select(p => p.id).FirstOrDefault(); break; default: break; } db.usuario_permisos.Add(usrAccesses); i = await db.SaveChangesAsync(); if (i > 0) { List <string> mails = new List <string>(); mails.Add(usuario.email); string url = Request.UrlReferrer.Scheme + "://" + Request.UrlReferrer.Authority; string body = "Estimado " + usuario.nombres + " " + usuario.apellidos + "\n \n" + "Se le ha creado un usuario para el sistema SGC de Personal Training, sus credenciales son las siguientes: \n \n" + "Usuario: " + usuario.email + "\n" + "Clave:" + usuario.password + "\n \n" + "Para ingresar al sistema, ingresar al siguiente enlace o copiarlo en su browser: " + url; mails.Add("*****@*****.**"); //solo para demo. Mail.Send( pTo: mails, pSubject: "Se le ha asignado un usuario en SGC", pBody: body); return(RedirectToAction("Index")); } } return(View(usuario)); } else { return(View(usuario)); } }
public void BuildGrid() { DateTime previousMonth = _currentMonth.AddMonths(-1); var daysInPreviousMonth = DateTime.DaysInMonth(previousMonth.Year, previousMonth.Month); var daysInMonth = DateTime.DaysInMonth(_currentMonth.Year, _currentMonth.Month); weekdayOfFirst = (int)_currentMonth.DayOfWeek; var lead = daysInPreviousMonth - (weekdayOfFirst - 1); // build last month's days for (int i = 1; i <= weekdayOfFirst; i++) { var viewDay = new DateTime(_currentMonth.Year, _currentMonth.Month, i); var dayView = new CalendarDayView(); dayView.Frame = new RectangleF((i - 1) * 46 - 1, 0, 47, 45); dayView.Date = viewDay; dayView.Text = lead.ToString(); AddSubview(dayView); _dayTiles.Add(dayView); lead++; } var position = weekdayOfFirst + 1; var line = 0; // current month for (int i = 1; i <= daysInMonth; i++) { var viewDay = new DateTime(_currentMonth.Year, _currentMonth.Month, i); var dayView = new CalendarDayView { Frame = new RectangleF((position - 1) * 46 - 1, line * 44, 47, 45), Today = (CurrentDate.Date == viewDay.Date), Text = i.ToString(), m_phase = _calendarMonthView.stageForDayDelegate == null ? 0 : _calendarMonthView.stageForDayDelegate((DateTime)viewDay), Active = true, Tag = i, Selected = (i == CurrentDate.AddDays(1).Day) }; dayView.Date = viewDay; updateDayView(dayView); if (dayView.Selected) { SelectedDayView = dayView; } AddSubview(dayView); _dayTiles.Add(dayView); position++; if (position > 7) { position = 1; line++; } } //next month if (position != 1) { int dayCounter = 1; for (int i = position; i < 8; i++) { var viewDay = new DateTime(_currentMonth.Year, _currentMonth.Month, i); var dayView = new CalendarDayView { Frame = new RectangleF((i - 1) * 46 - 1, line * 44, 47, 45), Text = dayCounter.ToString(), }; dayView.Date = viewDay; updateDayView(dayView); AddSubview(dayView); _dayTiles.Add(dayView); dayCounter++; } } Frame = new RectangleF(Frame.Location, new SizeF(Frame.Width, (line + 1) * 44)); Lines = (position == 1 ? line - 1 : line); if (SelectedDayView != null) { this.BringSubviewToFront(SelectedDayView); } }
protected override void OnMouseDown(MouseEventArgs e) { mouseClickPosition = new Point(e.X, e.Y); mouseClickScrollPosition = mouseClickPosition - new Size(AutoScrollPosition); if (!Focused) { Focus(); } var row = RowCoord.Where(d => (isNumberInRange(mouseClickScrollPosition.Y, d.FirstCoord, d.SecondCoord))).SingleOrDefault(); _selectedRow = row != null ? row.RowIndex : -1; var column = ColumnCoord.Where(d => (isNumberInRange(mouseClickScrollPosition.X, d.FirstCoord, d.SecondCoord))).SingleOrDefault(); if (column != null) { _selectedColumn = column.Column; _selectedCellDate = CurrentDate.AddDays(SelectedColumn); } if (listRows.Count > 0 && _selectedRow != -1) { var plannerRow = listRows.ElementAt(_selectedRow); _selectedItem = GetItemAt(mouseClickScrollPosition, plannerRow.Items); } switch (State) { case PlannerState.Idle: if (_selectedItem != null) { itemOnState = _selectedItem; itemOnStateChanged = false; durationStart = itemOnState.StartDate.Date.Subtract(column.DateValue.Date); durationEnd = itemOnState.EndDate.Date.Subtract(column.DateValue.Date); if (itemOnState.ResizeStartDateZone(mouseClickScrollPosition)) { SetState(PlannerState.ResizingItem); itemOnState.SetIsResizingStartDate(true); } else if (itemOnState.ResizeEndDateZone(mouseClickScrollPosition)) { SetState(PlannerState.ResizingItem); itemOnState.SetIsResizingEndDate(true); } else { rowNumer = _selectedRow; SetState(PlannerState.DraggingItem); } } break; case PlannerState.DraggingItem: break; case PlannerState.ResizingItem: break; case PlannerState.EditingItemText: break; } if (row != null && column != null && listRows.Count > 0) { var rowClicked = listRows.ElementAt(_selectedRow); planner.OnRowClick(new RowEventArgs(rowClicked)); Invalidate(); } if (mouseClickScrollPosition.X < LeftMargin) { try { var rowClicked = listRows.ElementAt(_selectedRow); if (e.Button == MouseButtons.Left) { rowClicked.IsExpanded = !rowClicked.IsExpanded; } planner.OnRowLeftColumnClick(new RowClickEventArgs(rowClicked, e.Button), listRows.IndexOf(rowClicked)); rowClicked.LeftMarginBackColor = rowClicked.LeftMarginOldBackColor; } catch (System.ArgumentOutOfRangeException) { Debug.WriteLine("It happened"); } } base.OnMouseDown(e); }
public void SetCurrentTime(string currentTime) { CurrentDate.Setup(() => DateTime.Parse(currentTime)); }
public ActionResult SetDetail(TblPayment obj) { TblPayment old = uow.Modules.Payment.Get(obj.PaymentId); //string PaymentId = this.Request.Form["PaymentId"]; if (obj.PaymentId < 1) { obj.PaymentNo = getId("P"); obj.CreatedDate = CurrentDate; obj.UpdatedDate = CurrentDate; obj.CreatedBy = CurrentUID; obj.UpdatedBy = CurrentUID; obj.StatusId = 1; } else { obj.UpdatedDate = CurrentDate; obj.UpdatedBy = CurrentUID; string StatusId = this.Request.Form["StatusId"]; string hdApprove = this.Request.Form["hdApprove"]; if (hdApprove == "3") { obj.StatusId = int.Parse(hdApprove); } else { obj.StatusId = int.Parse(StatusId); } } if (this.Request.Form["InvoiceId"].ToString() != "") { string invoiceid = this.Request.Form["InvoiceId"]; obj.InvoiceId = int.Parse(invoiceid); obj.InvoiceNo = this.Request.Form["InvoiceNo"]; } string CustomerName = this.Request.Form["CustomerName"]; obj.CustomerName = CustomerName; if (Request.Form["PaymentDate"].ToString().Count() > 0) { var dd = Request.Form["PaymentDate"].Split(' ')[0]; obj.StrPaymentDate = dd; } var AcctReceiveId = Request.Form["radio_bankaccount"]; if (AcctReceiveId != null) { obj.AcctReceiveId = int.Parse(AcctReceiveId); } obj.BankPayFrom = this.Request.Form["BankPayFrom"]; obj.BankPayFromBranch = this.Request.Form["BankPayFromBranch"]; bool clearOld = false; string oldPaySlipPath = old.PaySlipPath; obj.StrPaySlipPath = oldPaySlipPath; obj.PaySlipPath = oldPaySlipPath; if (Request.Files.Count > 0 && Request.Files["PaySlipPath"] != null && Request.Files["PaySlipPath"].ContentLength > 0) { HttpPostedFileBase uploadedFile = Request.Files["PaySlipPath"]; string FilePath = string.Format("files/payment/{0}{1}", "P" + CurrentDate.ParseString(DateFormat._yyyyMMddHHmmssfff), Path.GetExtension(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath("~/files"))) { Directory.CreateDirectory(Server.MapPath("~/files")); } if (!Directory.Exists(Server.MapPath("~/files/payment"))) { Directory.CreateDirectory(Server.MapPath("~/files/payment")); } uploadedFile.SaveAs(Server.MapPath("~/" + FilePath)); obj.PaySlipPath = FilePath; clearOld = true; } if (clearOld && !string.IsNullOrWhiteSpace(oldPaySlipPath) && IOFile.Exists(Server.MapPath("~/" + oldPaySlipPath))) { IOFile.Delete(Server.MapPath("~/" + oldPaySlipPath)); } try { int invoicestatus = uow.Modules.Invoice.GetStatus(obj.InvoiceId.HasValue?obj.InvoiceId.Value:0); if (obj.StatusId == 3) { if (invoicestatus == 3) { return(RedirectToAction("Detail", MVCController, new { id = obj.PaymentId, msg = "มีการชำระเงินไปแล้ว กรุณาเลือกใบแจ้งหนี้อื่น", msgType = AlertMsgType.Danger })); } } uow.Modules.Payment.SetPayment(obj); //uow.Modules.Payment.Set(obj); //uow.SaveChanges(); } catch (Exception ex) { string msg = ex.GetMessage(true); return(ViewDetail(obj, msg, AlertMsgType.Danger)); } return(RedirectToAction("Detail", MVCController, new { id = obj.PaymentId, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); // return RedirectToAction("Detail", MVCController, new { id = 1, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success }); }
static void Main(string[] args) { int opc = 0; string folderName = @"c:\Carpeta1"; string pathString = System.IO.Path.Combine(folderName, "SubFolder"); string pathString2 = @"c:\Subcarpeta1"; System.IO.Directory.CreateDirectory(pathString); string fileName = "SegParcial.txt"; Console.WriteLine("1. Leer documento"); Console.WriteLine("1. Escribir en documento"); Console.WriteLine("3. Salir"); opc = Console.Read(); switch (opc) { case 1: try { byte[] readBuffer = System.IO.File.ReadAllBytes(pathString); foreach (byte b in readBuffer) { Console.Write(b + " "); } Console.WriteLine(); } catch (System.IO.IOException e) { Console.WriteLine(e.Message); } break; case 2: using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:\Carpeta1\Subcarpeta1\SegParcial.txt")) { Console.WriteLine("Cuantos elementos va a agregar?: "); int x = Console.Read(); int[] nums = new int[x]; for (int i = 0; i < nums.Length; i++) { Console.WriteLine(i + ": "); string linea = Console.ReadLine(); nums[i] = int.Parse(linea); for (int k = 0; k < nums.Length; k++) { for (int f = 0; f < nums.Length - k; f++) { if (nums[f] > nums[f + 1]) { int aux; aux = nums[f]; nums[f] = nums[f + 1]; nums[f + 1] = aux; } } } DateTime CurrentDate; CurrentDate = Convert.ToDateTime(DateTime.Now.ToString("dd-MMM-yyyy")); using (StreamWriter writer = new StreamWriter(@"C:\Carpeta1\Subcarpeta1\SegParcial.txt", false)) { for (int j = 0; j < nums.Length; i++) { writer.WriteLine(nums[j].ToString()); writer.WriteLine(CurrentDate.ToString()); } } } } break; default: break; } System.Console.ReadKey(); }
public void CreateCalendarData() { CalendarItemData data; DateTime firstDay = CurrentDate.AddDays(1 - CurrentDate.Day); Events events; ItemList.Clear(); for (int i = 1; i <= DateTime.DaysInMonth(CurrentDate.Year, CurrentDate.Month); i++) { data = new CalendarItemData(i); ItemList.Add(data); } OnPropertyChanged("CurrentDate"); events = _calendarDataService.GetEvent(firstDay, firstDay.AddDays(DateTime.DaysInMonth(firstDay.Year, firstDay.Month))); if (events == null) { return; } foreach (Event e in events.Items) { if (e.Start.DateTime != null) { int index = ((DateTime)e.Start.DateTime).Day; data = ItemList.Find(x => x.Index == index); if (data != null) { data.EventList.Add(e); } } else { DateTime start = Convert.ToDateTime(e.Start.Date); DateTime end = Convert.ToDateTime(e.End.Date); int d_s = 1; int d_e = DateTime.DaysInMonth(CurrentDate.Year, CurrentDate.Month) + 1; if (start.Year == CurrentDate.Year && start.Month == CurrentDate.Month) { d_s = start.Day; } if (end.Year == CurrentDate.Year && end.Month == CurrentDate.Month) { d_e = end.Day; } for (int i = d_s; i < d_e; i++) { data = ItemList.Find(x => x.Index == i); if (data != null) { data.EventList.Add(e); } } } } }
public void DecreaseMonth() { CurrentDate = CurrentDate.AddMonths(-1); FirstDateOfWeek = new DateTime(CurrentDate.Year, CurrentDate.Month, 1); StartDate = FirstDateOfWeek.AddDays(-(int)FirstDateOfWeek.DayOfWeek + 1); }
public ActionResult SetDetail() { int id = Request.Form["CustomerId"].ParseInt(); TblCustomer ob = uow.Modules.Customer.Get(id); if (ob.CustomerId <= 0) { ob.CreatedBy = CurrentUID; ob.CreatedDate = CurrentDate; } if (Request.Form["PrefixId"].ParseInt() <= 0) { ob.PrefixId = null; ob.Prefix = null; } else { ob.PrefixId = Request.Form["PrefixId"].ParseInt(); ob.Prefix = uow.Modules.Enum.PrefixGet(ob.PrefixId.Value); } ob.CustomerName = Request.Form["CustomerName"]; ob.CustomerTaxId = Request.Form["CustomerTaxId"]; ob.GroupId = Request.Form["GroupId"].ParseInt(); ob.Group = uow.Modules.CustomerGroup.Get(ob.GroupId.Value); ob.CustomerPhone = Request.Form["CustomerPhone"]; ob.CustomerEmail = Request.Form["CustomerEmail"]; ob.CustomerType = 1; ob.UpdatedBy = CurrentUID; ob.UpdatedDate = CurrentDate; try { if (Request.Files.Count > 0 && Request.Files["CustomerAvatar"] != null && Request.Files["CustomerAvatar"].ContentLength > 0) { string oldPath = ob.CustomerAvatar; HttpPostedFileBase uploadedFile = Request.Files["CustomerAvatar"]; string FilePath = string.Format("files/customers/{0}{1}", CurrentDate.ParseString(DateFormat._yyyyMMddHHmmssfff), Path.GetExtension(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath("~/files"))) { Directory.CreateDirectory(Server.MapPath("~/files")); } if (!Directory.Exists(Server.MapPath("~/files/customers"))) { Directory.CreateDirectory(Server.MapPath("~/files/customers")); } uploadedFile.SaveAs(Server.MapPath("~/" + FilePath)); ob.CustomerAvatar = FilePath; if (!string.IsNullOrWhiteSpace(oldPath) && IOFile.Exists(Server.MapPath("~/" + oldPath))) { IOFile.Delete(Server.MapPath("~/" + oldPath)); } } //Validate model b4 save uow.Modules.Customer.Set(ob); uow.SaveChanges(); return(RedirectToAction("Index", new { area = "", controller = MVCController, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); } catch (Exception ex) { string msg = ex.GetMessage(true); return(ViewDetail(ob, msg, AlertMsgType.Danger)); } }
public ActionResult SetDetail() { List <TblEmployeeUserPermission> perList = new List <TblEmployeeUserPermission>(); int id = Request.Form["EmpId"].ParseInt(); TblEmployee ob = uow.Modules.Employee.Get(id); if (ob.EmpId <= 0) { ob.EmpCode = GetNewId(); ob.CreatedBy = CurrentUID; ob.CreatedDate = CurrentDate; } if (Request.Form["ddlPerQuotation"] != null && Request.Form["ddlPerQuotation"] != "" && ob.AccountId > 0) { foreach (string viewEmpId in Request.Form["ddlPerQuotation"].ToString().Split(',')) { perList.Add(new TblEmployeeUserPermission() { AccountId = (int)ob.AccountId.Value, FunId = 1, ViewAccountId = viewEmpId.ParseInt(), CreatedBy = CurrentUID, CreatedDate = CurrentDate }); } } if (Request.Form["ddlPerSaleOrder"] != null && Request.Form["ddlPerSaleOrder"] != "" && ob.AccountId > 0) { foreach (string viewEmpId in Request.Form["ddlPerSaleOrder"].ToString().Split(',')) { perList.Add(new TblEmployeeUserPermission() { AccountId = (int)ob.AccountId.Value, FunId = 2, ViewAccountId = viewEmpId.ParseInt(), CreatedBy = CurrentUID, CreatedDate = CurrentDate }); } } if (Request.Form["ddlPerInvoice"] != null && Request.Form["ddlPerInvoice"] != "" && ob.AccountId > 0) { foreach (string viewEmpId in Request.Form["ddlPerInvoice"].ToString().Split(',')) { perList.Add(new TblEmployeeUserPermission() { AccountId = (int)ob.AccountId.Value, FunId = 3, ViewAccountId = viewEmpId.ParseInt(), CreatedBy = CurrentUID, CreatedDate = CurrentDate }); } } if (Request.Form["ddlPerJobOrder"] != null && Request.Form["ddlPerJobOrder"] != "" && ob.AccountId > 0) { foreach (string viewEmpId in Request.Form["ddlPerJobOrder"].ToString().Split(',')) { perList.Add(new TblEmployeeUserPermission() { AccountId = (int)ob.AccountId.Value, FunId = 4, ViewAccountId = viewEmpId.ParseInt(), CreatedBy = CurrentUID, CreatedDate = CurrentDate }); } } if (Request.Form["AccountId"].ParseInt() <= 0) { ob.AccountId = null; ob.Account = null; } else { ob.AccountId = Request.Form["AccountId"].ParseInt(); ob.Account = uow.Modules.Account.Get(ob.AccountId.Value); } if (Request.Form["PrefixId"].ParseInt() <= 0) { ob.PrefixId = null; ob.Prefix = null; } else { ob.PrefixId = Request.Form["PrefixId"].ParseInt(); ob.Prefix = uow.Modules.Enum.PrefixGet(ob.PrefixId.Value); } ob.EmpNameTh = Request.Form["EmpNameTh"]; ob.EmpNameEn = Request.Form["EmpNameEn"]; if (Request.Form["DepartmentId"].ParseInt() <= 0) { ob.DepartmentId = null; ob.Department = null; ob.PositionId = null; ob.Position = null; } else { ob.DepartmentId = Request.Form["DepartmentId"].ParseInt(); ob.Department = uow.Modules.Department.Get(ob.DepartmentId.Value); if (Request.Form["PositionId"].ParseInt() <= 0) { ob.PositionId = null; ob.Position = null; } else { ob.PositionId = Request.Form["PositionId"].ParseInt(); ob.Position = uow.Modules.Position.Get(ob.PositionId.Value); } } ob.StatusId = Request.Form["StatusId"].ParseInt(); if (Request.Form["EmpTypeId"].ParseInt() <= 0) { ob.EmpTypeId = null; } else { ob.EmpTypeId = Request.Form["EmpTypeId"].ParseInt(); } if (Request.Form["LeadId"].ParseInt() <= 0) { ob.LeadId = null; } else { ob.LeadId = Request.Form["LeadId"].ParseInt(); } ob.EmpPid = Request.Form["EmpPid"]; ob.EmpAddress = Request.Form["EmpAddress"]; ob.EmpPostcode = Request.Form["EmpPostcode"]; ob.EmpMobile = Request.Form["EmpMobile"]; ob.EmpEmail = Request.Form["EmpEmail"]; ob.IsQuotationApprove = Request.Form["hddIsQuotationApprove"] == "on" ? 1 : 0; ob.IsJobOrderApprove = Request.Form["hddIsJobOrderApprove"] == "on" ? 1 : 0; ob.UpdatedBy = CurrentUID; ob.UpdatedDate = CurrentDate; try { //Validate model b4 save bool clearOld = false; string oldSignature = ob.EmpSignature; if (Request.Files.Count > 0 && Request.Files["EmpSignature"] != null && Request.Files["EmpSignature"].ContentLength > 0) { HttpPostedFileBase uploadedFile = Request.Files["EmpSignature"]; string FilePath = string.Format("files/signature/{0}{1}", CurrentDate.ParseString(DateFormat._yyyyMMddHHmmssfff), Path.GetExtension(uploadedFile.FileName)); if (!Directory.Exists(Server.MapPath("~/files"))) { Directory.CreateDirectory(Server.MapPath("~/files")); } if (!Directory.Exists(Server.MapPath("~/files/signature"))) { Directory.CreateDirectory(Server.MapPath("~/files/signature")); } uploadedFile.SaveAs(Server.MapPath("~/" + FilePath)); ob.EmpSignature = FilePath; clearOld = true; } if (clearOld && !string.IsNullOrWhiteSpace(oldSignature) && IOFile.Exists(Server.MapPath("~/" + oldSignature))) { IOFile.Delete(Server.MapPath("~/" + oldSignature)); } uow.Modules.Employee.Set(ob); uow.SaveChanges(); uow.Modules.EmployeeUserPermission.Set(perList.FindAll(o => o.FunId == 1)); uow.Modules.EmployeeUserPermission.Set(perList.FindAll(o => o.FunId == 2)); uow.Modules.EmployeeUserPermission.Set(perList.FindAll(o => o.FunId == 3)); uow.Modules.EmployeeUserPermission.Set(perList.FindAll(o => o.FunId == 4)); uow.SaveChanges(); return(RedirectToAction("Index", new { area = "", controller = MVCController, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); } catch (Exception ex) { string msg = ex.GetMessage(true); return(ViewDetail(ob, msg, AlertMsgType.Danger)); } }
public ActionResult Export(int id) { try { TblKptStation ob = db.TblKptStation .Where(x => x.StationId == id) .Include(x => x.TblKpt) .Include(x => x.TblKptStationAttachment) .Include(x => x.TblKptStationDetail) .FirstOrDefault(); if (ob == null) { throw new Exception("No KPT Data."); } DataTable dt = new DataTable("ds"); dt.Columns.Add(new DataColumn("ImgUri")); //foreach (TblKptStationAttachment it in ob.TblKptStationAttachment) //{ // DataRow dr = dt.NewRow(); // dr["ImgUri"] = new Uri(Server.MapPath("~/" + it.AttachPath)).AbsoluteUri; // dt.Rows.Add(dr); //} //DataSet ds = new DataSet(); //ds.Tables.Add(dt); ReportDataSource rptData = new ReportDataSource("ds", dt); ReportViewer rptViewer = new ReportViewer(); rptViewer.ProcessingMode = ProcessingMode.Local; rptViewer.LocalReport.ReportPath = Server.MapPath("~/reports/rptKPT.rdlc"); rptViewer.LocalReport.SetParameters(new ReportParameter("headProjectName", ob.TblKpt.ProjectName)); rptViewer.LocalReport.SetParameters(new ReportParameter("headCustomerName", ob.TblKpt.CustomerName)); rptViewer.LocalReport.SetParameters(new ReportParameter("headLocation", ob.TblKpt.KptLocation + (ob.TblKpt.SubDistrictId > 0 ? " " + ob.TblKpt.SubDistrict().SubDistrictNameTH + " " + ob.TblKpt.SubDistrict().District().DistrictNameTH + " " + ob.TblKpt.SubDistrict().District().State().StateNameTH : ""))); rptViewer.LocalReport.SetParameters(new ReportParameter("headStation", ob.StationName)); rptViewer.LocalReport.SetParameters(new ReportParameter("headDate", ob.TblKpt.KptDate.ToString("dd/MM/yyyy"))); rptViewer.LocalReport.SetParameters(new ReportParameter("headTestedBy", ob.StationTestBy)); int endKpt = 0; decimal sumAvgN = 0; decimal sumAvgQu = 0; for (int i = 1; i <= 7; i++) { if (ob.TblKptStationDetail .Where(x => x.StationDepth >= ((5 * (i - 1)) + 1) && x.StationDepth <= ((5 * (i - 1)) + 5)) .Sum(x => x.StationBlowCount) > 0 && (endKpt + 1 == i)) { int sumCount = 0; decimal sumQu = 0; for (int j = (5 * (i - 1)) + 1; j <= (5 * (i - 1)) + 5; j++) { var tmp = ob.TblKptStationDetail.Where(x => x.StationDepth == j).FirstOrDefault(); if (tmp == null) { throw new Exception("Failed to retrive data. [Id: " + ob.StationId + "-i:" + i + "-j:" + j + "]"); } int blowCount = tmp.StationBlowCount; int blowCountN = (int)(blowCount > 15 ? 15 + Math.Floor(0.5 * (blowCount - 15)) : blowCount); decimal qu = blowCountN <= 0 ? 0 : (decimal)1.92 * (blowCountN + (decimal)0.954); qu = Math.Floor(qu * 100) / 100; rptViewer.LocalReport.SetParameters(new ReportParameter("dataBlowCount_" + j, blowCount.ToString())); rptViewer.LocalReport.SetParameters(new ReportParameter("dataBearing_" + j, qu.ToString("0.00"))); sumCount += blowCount; sumQu += qu; } decimal avgN = Math.Floor(((decimal)sumCount / 5) * 100) / 100; decimal avgQu = Math.Floor((sumQu / 5) * 100) / 100; decimal cohesion = Math.Floor((avgQu / 2) * 100) / 100; rptViewer.LocalReport.SetParameters(new ReportParameter("dataAvgN_" + i, avgN.ToString("0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataAvgQu_" + i, avgQu.ToString("0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataCohesion_" + i, cohesion.ToString("0.00"))); sumAvgN += avgN; sumAvgQu += avgQu; endKpt = i; } } decimal lastN = (sumAvgN / (decimal)endKpt); decimal lastQu = (sumAvgQu / (decimal)endKpt); decimal lastCohesion = Math.Floor((lastQu / 2) * 100) / 100; rptViewer.LocalReport.SetParameters(new ReportParameter("avgN", lastN.ToString("0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("avgQu", lastQu.ToString("0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("avgCohesion", lastCohesion.ToString("0.00"))); rptViewer.LocalReport.SetParameters(new ReportParameter("dataEndKpt", endKpt.ToString())); rptViewer.LocalReport.SetParameters(new ReportParameter("PreparedBy", CurrentUser.AccountName)); rptViewer.LocalReport.DataSources.Clear(); rptViewer.LocalReport.DataSources.Add(rptData); Warning[] warnings; string[] streamids; string mimeType; string encoding; string filenameExtension; byte[] bytes = rptViewer.LocalReport.Render( "PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings); if (ob.TblKptStationAttachment.Count() > 0) { foreach (TblKptStationAttachment it in ob.TblKptStationAttachment) { DataRow dr = dt.NewRow(); dr["ImgUri"] = new Uri(Server.MapPath("~/" + it.AttachPath)).AbsoluteUri; dt.Rows.Add(dr); } ReportDataSource rptAttachData = new ReportDataSource("ds", dt); ReportViewer rptAttachViewer = new ReportViewer(); rptAttachViewer.ProcessingMode = ProcessingMode.Local; rptAttachViewer.LocalReport.ReportPath = Server.MapPath("~/reports/rptKPTAttachment.rdlc"); rptAttachViewer.LocalReport.EnableExternalImages = true; rptAttachViewer.LocalReport.DataSources.Clear(); rptAttachViewer.LocalReport.DataSources.Add(rptAttachData); Warning[] warningsAttach; string[] streamidsAttach; string mimeTypeAttach; string encodingAttach; string filenameExtensionAttach; byte[] bytesAttach = rptAttachViewer.LocalReport.Render( "PDF", null, out mimeTypeAttach, out encodingAttach, out filenameExtensionAttach, out streamidsAttach, out warningsAttach); List <byte[]> pdf = new List <byte[]>(); pdf.Add(bytes); pdf.Add(bytesAttach); byte[] mergedPdf = null; using (MemoryStream ms = new MemoryStream()) { using (Document document = new Document()) { using (PdfCopy copy = new PdfCopy(document, ms)) { document.Open(); for (int i = 0; i < pdf.Count; ++i) { PdfReader reader = new PdfReader(pdf[i]); // loop over the pages in that document int n = reader.NumberOfPages; for (int page = 0; page < n;) { copy.AddPage(copy.GetImportedPage(reader, ++page)); } } } } mergedPdf = ms.ToArray(); bytes = mergedPdf; } } Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename= KPT-" + CurrentDate.ToString("yyyy-MM-dd_HHmmss") + "." + filenameExtension); Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file Response.Flush(); // send it to the client to download Response.End(); return(View()); } catch (Exception ex) { return(RedirectToAction("Index", "KPT", new { msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
protected void PreviousMonth() { CurrentDate = CurrentDate.AddMonths(-1); GetDates(); StateHasChanged(); }