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