/// <summary> /// 获取考勤记录。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnGetARResult_Click(object sender, EventArgs e) { V_Work_Schedule v_W_S = new V_Work_Schedule(); v_W_S.WORK_AND_REST_DATE = YearAndMonthStr; /* * if (!v_W_S.ifExistsWS()) { * return; * } */ ARResult aRResult = new ARResult(YearAndMonthStr); string randomStr = RandomStr.GetRandomString(40, true, true, true, false, ""); if (aRResult.updateARResult(randomStr) == 0) { this.dgv.DataSource = MESSAGES.getMSG(randomStr); DGVHelper.AutoSizeForDGV(dgv); ShowResult.show(lblResult, "异常!", false); timerRestoreTheLblResult.Enabled = true; return; } ShowResult.show(lblResult, "完成!", true); //显示结果 AttendanceR aR = new AttendanceR(); this.dgv.DataSource = aR.getARByYearAndMonth(aRResult.Year_And_Month_str); DGVHelper.AutoSizeForDGV(dgv); }
public MessageSentClass(MESSAGES message) : base(message) { fromUser = null; foreach (var item in e.MESSAGE_RECIPIENTS.Where(m => m.MESSAGE_ID == message.MESSAGE_ID)) { toUser.Add(new UserPublicInfoClass(item.USERS)); } }
public MessageClass(MESSAGES message) { id = message.MESSAGE_ID; fromUser = new UserPublicInfoClass(message.FROM_USER_ID); title = message.MESSAGE_SUBJECT; status = message.MESSAGE_TYPE; body = HtmlToText.HtmlToPlainText(message.MESSAGE_CONTENT); date = message.MESSAGE_DATE; group = message.GROUP_ID == null ? null : new GroupClass(message.GROUP_ID); subject = message.SUBJECT_ID == null ? null : new SubjectClass(message.SUBJECT_ID); attachments = getAttachments(); }
public ActionResult AddNewMessage(MESSAGES m) { int id = int.Parse(Session["id"].ToString()); m.ACTIVE = true; //? ++calisiyor m.FROMID = id; bool a = m.ACTIVE; //test için db.MESSAGES.Add(m); db.SaveChanges(); return(View()); }
public HttpResponseMessage Add(int school_id, int user_id, int subject_id, string title, string body, DateTime homework_date) { try { using (Entities entities = new Entities()) { MESSAGES _message = new MESSAGES() { MESSAGE_ID = entities.MESSAGES.Max(n => n.MESSAGE_ID) + 1, FROM_USER_ID = user_id, MESSAGE_SUBJECT = title, MESSAGE_CONTENT = body, MESSAGE_DATE = homework_date, CREATION_DATE = DateTime.Now, MESSAGE_TYPE = 2, MESSAGE_STATUS = 2, SUBJECT_ID = subject_id, SCHOOL_ID = school_id }; entities.MESSAGES.Add(_message); foreach (var StSu in entities.STUDENT_SUBJECTS.Where(ss => ss.SUBJECT_ID == subject_id)) { MESSAGE_RECIPIENTS _mr = new MESSAGE_RECIPIENTS() { MESSAGE_RECIPIENT_ID = entities.MESSAGE_RECIPIENTS.Max(mr => mr.MESSAGE_RECIPIENT_ID) + 1, MESSAGE_ID = _message.MESSAGE_ID, USER_ID = StSu.STUDENTS.USER_ID }; entities.MESSAGE_RECIPIENTS.Add(_mr); entities.SaveChanges(); } MessageClass messageResult = new MessageClass(entities.MESSAGES.FirstOrDefault(n => n.MESSAGE_ID == _message.MESSAGE_ID)); return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 200, status = "Sending...", results = new List <MessageClass>() { messageResult } })); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 400, status = ex.Message })); } }
public HttpResponseMessage Add(int school_id, int user_id, [FromBody] addMessage message) { try { using (Entities entities = new Entities()) { MESSAGES _message = new MESSAGES() { MESSAGE_ID = entities.MESSAGES.Max(n => n.MESSAGE_ID) + 1, FROM_USER_ID = user_id, MESSAGE_SUBJECT = message.title, MESSAGE_CONTENT = message.body, MESSAGE_DATE = DateTime.Now, CREATION_DATE = DateTime.Now, MESSAGE_TYPE = 1, MESSAGE_STATUS = 2, SCHOOL_ID = school_id }; entities.MESSAGES.Add(_message); foreach (var user in message.toUsers) { MESSAGE_RECIPIENTS _mr = new MESSAGE_RECIPIENTS() { MESSAGE_RECIPIENT_ID = entities.MESSAGE_RECIPIENTS.Max(mr => mr.MESSAGE_RECIPIENT_ID) + 1, MESSAGE_ID = _message.MESSAGE_ID, USER_ID = user }; entities.MESSAGE_RECIPIENTS.Add(_mr); entities.SaveChanges(); } MessageClass messageResult = new MessageClass(entities.MESSAGES.FirstOrDefault(n => n.MESSAGE_ID == _message.MESSAGE_ID)); return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 200, status = "Sending...", results = new List <MessageClass>() { messageResult } })); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.OK, new Result() { statusCode = 400, status = ex.Message })); } }
public void Execute(object parameter) { try { MESSAGES messages = new MESSAGES(); Random value = new Random(); OracleCommand get_trainer = new OracleCommand("GET_TRAINER_FOR_CHAT", (OracleConnection)WindowOfViews.database.Database.Connection); get_trainer.CommandType = CommandType.StoredProcedure; var pResult = new OracleParameter("pResult", OracleDbType.RefCursor, ParameterDirection.Output); get_trainer.Parameters.Add(pResult); get_trainer.Parameters.Add("LOGIN1", WindowOfViews.ChatUser.comboBox.Text); get_trainer.ExecuteNonQuery(); var res = (OracleRefCursor)pResult.Value; OracleDataReader reader = res.GetDataReader(); DataTable dt = new DataTable(); dt.Load(reader); OracleCommand get_messages = new OracleCommand("GET_INFO_MESSAGES", (OracleConnection)WindowOfViews.database.Database.Connection); get_messages.CommandType = CommandType.StoredProcedure; var pResult1 = new OracleParameter("pResult", OracleDbType.RefCursor, ParameterDirection.Output); get_messages.Parameters.Add(pResult1); get_messages.ExecuteNonQuery(); var res1 = (OracleRefCursor)pResult1.Value; OracleDataReader reader1 = res1.GetDataReader(); DataTable dt1 = new DataTable(); dt1.Load(reader1); OracleCommand command1 = new OracleCommand("INSERT_MESSAGE", (OracleConnection)WindowOfViews.database.Database.Connection); command1.CommandType = CommandType.StoredProcedure; command1.Parameters.Add("MESSAGES", WindowOfViews.ChatUser.messageText.Text); command1.Parameters.Add("ID_MESSAGE", (dt1.Rows.Count + 1)); command1.Parameters.Add("WHO_SENDER", WorkUserWindowViewModel.client.ID_CLIENT); command1.Parameters.Add("WHO_RECIPIENT", (decimal)dt.Rows[0][2]); command1.Parameters.Add("GROUPMESSAGE", null); command1.Parameters.Add("DATETIME", DateTime.Now); command1.ExecuteNonQuery(); //WindowOfViews.database.SaveChanges(); ChatUserViewModel.lol.ChoiseClient = WindowOfViews.ChatUser.comboBox.Text; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public async Task<IHttpActionResult> Add() { if (!Request.Content.IsMimeMultipartContent()) throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType); var provider = new MultipartMemoryStreamProvider(); var message_id = Request.Headers.GetValues("message_id").First(); int messageId = int.Parse(message_id); var attach_no = Request.Headers.GetValues("attach_no").First(); short attachNo = short.Parse(attach_no); await Request.Content.ReadAsMultipartAsync(provider); using (Entities e = new Entities()) { MESSAGES _message = e.MESSAGES.FirstOrDefault(m => m.MESSAGE_ID == messageId ); _message.ATTACH_NO = attachNo; e.SaveChanges(); } foreach (var file in provider.Contents) { var filename = file.Headers.ContentDisposition.FileName.Trim('\"'); var buffer = await file.ReadAsByteArrayAsync(); //Do whatever you want with filename and its binary data. Add(messageId, new AttachmentClass() { name = filename, attach = buffer }); } return Ok(); }
/** * Methods Notifies user with text box * @param message * @param title * @param button * @param image * @return MessageBoxResult */ public MessageBoxResult Notify(MESSAGES message, TITLES title, MessageBoxButton button, MessageBoxImage image) => MessageBox.Show(MESSAGES_DICTIONARY[message], TITLES_DICTIONARY[title], button, image);
public ActionResult wyslij(MessageListView messageListView) { if (string.IsNullOrWhiteSpace(messageListView.newMessageContent)) // blokada przy wysylaniu pustej wiadomosci { return(RedirectToAction("Index", new { userID = userTo })); } ProjektEntities db = new ProjektEntities(); var mod = new MessageListView { ListMessage = new List <MessageView>(), ListUsersMessage = new List <MessageView>() }; var message = from m in db.MESSAGES where (m.Message_From == User.Identity.Name && m.Message_To == userTo) || (m.Message_From == userTo && m.Message_To == User.Identity.Name) orderby m.Message_ID select new { m.Message_From, m.Message_To, m.Content, m.Message_ID, m.Date }; foreach (var item in message) { mod.ListMessage.Add(new MessageView { fromUser = item.Message_From, toUser = item.Message_To, content = item.Content, messageID = item.Message_ID, date = item.Date }); } var listUser = db.MESSAGES.Where(m => m.Message_From == User.Identity.Name) .GroupBy(p => p.Message_To, (a, b) => b.OrderByDescending(e => e.Message_ID)).Select(s => s.FirstOrDefault()); foreach (var item in listUser) { mod.ListUsersMessage.Add(new MessageView { toUser = item.Message_To, date = item.Date }); } var listUser1 = db.MESSAGES.Where(m => m.Message_To == User.Identity.Name && m.Message_From != User.Identity.Name) .GroupBy(p => p.Message_From, (a, b) => b.OrderByDescending(e => e.Message_ID)).Select(s => s.FirstOrDefault()); foreach (var item in listUser1) { mod.ListUsersMessage.Add(new MessageView { toUser = item.Message_From, date = item.Date }); } for (int i = 0; i < mod.ListUsersMessage.Count; i++) { for (int j = i + 1; j < mod.ListUsersMessage.Count; j++) { System.Diagnostics.Debug.WriteLine("i " + mod.ListUsersMessage[i].toUser + " j " + mod.ListUsersMessage[j].toUser); if (mod.ListUsersMessage[i].toUser == mod.ListUsersMessage[j].toUser) { mod.ListUsersMessage.Remove(mod.ListUsersMessage[j]); } } } if (userTo == null) // mozliwosc napisania do samego siebie { userTo = User.Identity.Name; } MESSAGES newMessage = new MESSAGES(); newMessage.Message_From = User.Identity.Name; newMessage.Message_To = userTo; newMessage.Content = messageListView.newMessageContent; newMessage.Date = DateTime.Now; db.MESSAGES.Add(newMessage); db.SaveChanges(); return(RedirectToAction("Index", new { userID = userTo })); // przekazanie userTo do funkcji Index }