/// <summary>
/// Kiem tra model backing changed,
/// CSDL Sẽ tạo tự động nếu chưa có (Chưa hay lắm)
/// </summary>
/// <returns></returns>
public bool isValidModel()
{
try
{
COSOS.Find(Guid.Empty);
DAYYS.Find(Guid.Empty);
TANGS.Find(Guid.Empty);
VITRIS.Find(Guid.Empty);
PHONGS.Find(Guid.Empty);
THIETBIS.Find(Guid.Empty);
CTTHIETBIS.Find(Guid.Empty);
HINHANHS.Find(Guid.Empty);
QUANTRIVIENS.Find(Guid.Empty);
NHANVIENPTS.Find(Guid.Empty);
LOGHETHONGS.Find(Guid.Empty);
LOGSUCOPHONGS.Find(Guid.Empty);
LOGTHIETBIS.Find(Guid.Empty);
LOAITHIETBIS.Find(Guid.Empty);
SETTINGS.Find(Guid.Empty);
TINHTRANGS.Find(Guid.Empty);
PERMISSIONS.Find(Guid.Empty);
SUCOPHONGS.Find(Guid.Empty);
GROUPS.Find(Guid.Empty);
PHIEUMUONPHONGS.Find(Guid.Empty);
return(true);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
return(false);
}
}
public void UpdateList(string groupId, string groupName, string users)
{
using (var db = SugarContext.GetInstance())
{
var g = db.Queryable <GROUPS>().Where(x => x.GROUP_ID == groupId).ToList().FirstOrDefault();
if (g == null)
{
g = new GROUPS()
{
ID = Guid.NewGuid().ToString("N").ToUpper(),
DATETIME_CREATED = DateTime.Now,
USER_CREATED = "SYS",
STATE = "A",
GROUP_ID = groupId,
GROUP_NAME = groupName,
USERS = users
};
db.Insertable(g).ExecuteCommand();
}
else
{
var us = g.USERS.Split(';').Distinct().ToList();
if (!us.Contains(users))
{
us.Add(users);
}
g.GROUP_NAME = groupName;
g.USERS = string.Join(';', us);
db.Updateable(g).ExecuteCommand();
}
}
}
public GroupClass(GROUPS group)
{
if (group == null)
{
return;
}
id = group.GROUP_ID;
name = group.NAME;
}
public object GetChatList(string username)
{
try
{
using (var db = SugarContext.GetInstance())
{
var rs = db.Queryable <GROUPS>().Where(x => x.STATE == "A").ToList();
var list = new List <GROUPS>();
var group = rs.Where(c => c.GROUP_NAME != "friend").ToList();
foreach (var ds in group)
{
var user = ds.USERS.Split(';');
if (user.Contains(username))
{
var m = new GROUPS
{
USERS = username,
GROUP_ID = ds.GROUP_ID,
GROUP_NAME = ds.GROUP_NAME
};
list.Add(m);
}
}
var friend = rs.Where(x => x.GROUP_NAME == "friend").ToList();
foreach (var ds in friend)
{
var user = ds.USERS.Split(';');
if (user.Contains(username))
{
var friends = ds.GROUP_ID.Split(';').ToList();
var friend_id = friends.Where(c => c != username).FirstOrDefault();
var friend_info = db.Queryable <SYS_USER>().Where(e => e.USER_NAME == friend_id).ToList().FirstOrDefault();
if (friend_info != null)
{
var m = new GROUPS
{
USERS = username,
GROUP_ID = string.Join(';', friends.OrderBy(c => c.Length).OrderBy(c => c[0])),
GROUP_NAME = friend_info?.DISPLAY_NAME,
ID = friend_info?.IMG
};
list.Add(m);
}
}
}
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult> Edit([Bind(Include = "GROUP_CODE,FACULTY_CODE,GROUP_NUMBER")] GROUPS gROUPS)
{
if (ModelState.IsValid)
{
db.Entry(gROUPS).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.FACULTY_CODE = new SelectList(db.FACULTY, "FACULTY_CODE", "FACULTY_NAME", gROUPS.FACULTY_CODE);
return(View(gROUPS));
}
public GroupClass(int?groupId)
{
if (groupId == null)
{
return;
}
Entities e = new Entities();
GROUPS group = e.GROUPS.FirstOrDefault(g => g.GROUP_ID == groupId);
id = group.GROUP_ID;
name = group.NAME;
}
/// <summary>
/// Kiem tra model backing changed,
/// CSDL Sẽ tạo tự động nếu chưa có (Chưa hay lắm)
/// </summary>
/// <returns></returns>
public bool isValidModel()
{
try
{
COSOS.Find(Guid.Empty);
DAYYS.Find(Guid.Empty);
TANGS.Find(Guid.Empty);
VITRIS.Find(Guid.Empty);
PHONGS.Find(Guid.Empty);
LOAIPHONGS.Find(Guid.Empty);
QUANTRIVIENS.Find(Guid.Empty);
LOGHETHONGS.Find(Guid.Empty);
SETTINGS.Find(Guid.Empty);
TINHTRANGS.Find(Guid.Empty);
PERMISSIONS.Find(Guid.Empty);
GROUPS.Find(Guid.Empty);
CTTAISANS.Find(Guid.Empty);
TAISANS.Find(Guid.Empty);
LOAITAISANS.Find(Guid.Empty);
DONVIS.Find(Guid.Empty);
LOAIDONVIS.Find(Guid.Empty);
DONVITINHS.Find(Guid.Empty);
LOGTANGGIAMTAISANS.Find(Guid.Empty);
return(true);
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
return(false);
}
}
public static void determineProgramKeywords(ref MxfProgram mxfProgram, string[] programCategories)
{
// determine primary group of program
GROUPS group = GROUPS.UNKNOWN;
if (!string.IsNullOrEmpty(mxfProgram.IsMovie))
{
group = GROUPS.MOVIES;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsPaidProgramming))
{
group = GROUPS.PAIDPROGRAMMING;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsSports))
{
group = GROUPS.SPORTS;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsKids))
{
group = GROUPS.KIDS;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsEducational))
{
group = GROUPS.EDUCATIONAL;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsNews))
{
group = GROUPS.NEWS;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsSpecial))
{
group = GROUPS.SPECIAL;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsReality))
{
group = GROUPS.REALITY;
}
else if (!string.IsNullOrEmpty(mxfProgram.IsSeries))
{
group = GROUPS.SERIES;
}
// build the keywords/categories
if (group != GROUPS.UNKNOWN)
{
mxfProgram.Keywords = string.Format("k{0}", (int)group + 1);
// add premiere categories as necessary
if (!string.IsNullOrEmpty(mxfProgram.IsSeasonPremiere) || !string.IsNullOrEmpty(mxfProgram.IsSeriesPremiere))
{
mxfProgram.Keywords += string.Format(",k{0}", (int)GROUPS.PREMIERES + 1);
if (!string.IsNullOrEmpty(mxfProgram.IsSeasonPremiere))
{
mxfProgram.Keywords += "," + mxf.With[0].KeywordGroups[(int)GROUPS.PREMIERES].getKeywordId("Season Premiere");
}
if (!string.IsNullOrEmpty(mxfProgram.IsSeriesPremiere))
{
mxfProgram.Keywords += "," + mxf.With[0].KeywordGroups[(int)GROUPS.PREMIERES].getKeywordId("Series Premiere");
}
}
else if (!string.IsNullOrEmpty(mxfProgram.IsPremiere) && string.IsNullOrEmpty(mxfProgram.IsGeneric))
{
if (group == GROUPS.MOVIES)
{
mxfProgram.Keywords += "," + mxf.With[0].KeywordGroups[(int)group].getKeywordId("Premiere");
}
else if (!string.IsNullOrEmpty(mxfProgram.IsMiniseries))
{
mxfProgram.Keywords += string.Format(",k{0}", (int)GROUPS.PREMIERES + 1);
mxfProgram.Keywords += "," + mxf.With[0].KeywordGroups[(int)GROUPS.PREMIERES].getKeywordId("Miniseries Premiere");
}
else if (!string.IsNullOrEmpty(mxfProgram.IsSeries))
{
mxfProgram.Keywords += string.Format(",k{0}", (int)GROUPS.PREMIERES + 1);
mxfProgram.Keywords += "," + mxf.With[0].KeywordGroups[(int)GROUPS.PREMIERES].getKeywordId("Series/Season Premiere");
}
}
// now add the real categories
if (programCategories != null)
{
foreach (string category in programCategories)
{
switch (category.ToLower())
{
case "feature film":
case "short film":
case "tv movie":
case "miniseries":
case "series":
case "special":
case "sports event":
case "sports non-event":
case "paid programming":
case "theatre event":
case "show":
case "episode":
case "sports":
case "movie":
break;
default:
string key = mxf.With[0].KeywordGroups[(int)group].getKeywordId(CultureInfo.InvariantCulture.TextInfo.ToTitleCase(category.ToLowerInvariant()));
List <string> keys = mxfProgram.Keywords.Split(',').ToList();
if (!keys.Contains(key))
{
mxfProgram.Keywords += "," + key;
}
break;
}
}
}
if (mxfProgram.Keywords.Length < 5)
{
string key = mxf.With[0].KeywordGroups[(int)group].getKeywordId("Uncategorized");
mxfProgram.Keywords += "," + key;
}
}
}
public void TransmitClientEvent(EVENT_IDS eventId, int value, GROUPS group, SIMCONNECT_EVENT_FLAG flags)
{
_simConnect.TransmitClientEvent(SimConnect.SIMCONNECT_OBJECT_ID_USER, eventId, (uint)value, group, flags);
}
private static void determineProgramKeywords(ref MxfProgram prg, sdProgram sd)
{
// determine primary group of program
GROUPS group = GROUPS.UNKNOWN;
if (!string.IsNullOrEmpty(prg.IsMovie))
{
group = GROUPS.MOVIES;
}
else if (!string.IsNullOrEmpty(prg.IsPaidProgramming))
{
group = GROUPS.PAIDPROGRAMMING;
}
else if (!string.IsNullOrEmpty(prg.IsSports))
{
group = GROUPS.SPORTS;
}
else if (!string.IsNullOrEmpty(prg.IsKids))
{
group = GROUPS.KIDS;
}
else if (!string.IsNullOrEmpty(prg.IsEducational))
{
group = GROUPS.EDUCATIONAL;
}
else if (!string.IsNullOrEmpty(prg.IsNews))
{
group = GROUPS.NEWS;
}
else if (!string.IsNullOrEmpty(prg.IsSpecial))
{
group = GROUPS.SPECIAL;
}
else if (!string.IsNullOrEmpty(prg.IsReality))
{
group = GROUPS.REALITY;
}
else if (!string.IsNullOrEmpty(prg.IsSeries))
{
group = GROUPS.SERIES;
}
// build the keywords/categories
if (group != GROUPS.UNKNOWN)
{
prg.Keywords = string.Format("k{0}", (int)group + 1);
// add premiere categories as necessary
if (!string.IsNullOrEmpty(prg.IsSeasonPremiere) || !string.IsNullOrEmpty(prg.IsSeriesPremiere))
{
prg.Keywords += string.Format(",k{0}", (int)GROUPS.PREMIERES + 1);
if (!string.IsNullOrEmpty(prg.IsSeasonPremiere))
{
prg.Keywords += "," + sdMxf.With[0].KeywordGroups[(int)GROUPS.PREMIERES].getKeywordId("Season Premiere");
}
if (!string.IsNullOrEmpty(prg.IsSeriesPremiere))
{
prg.Keywords += "," + sdMxf.With[0].KeywordGroups[(int)GROUPS.PREMIERES].getKeywordId("Series Premiere");
}
}
else if (!string.IsNullOrEmpty(prg.IsPremiere))
{
if (group == GROUPS.MOVIES)
{
prg.Keywords += "," + sdMxf.With[0].KeywordGroups[(int)group].getKeywordId("Premiere");
}
else if (Helper.tableContains(sd.Genres, "miniseries") == "true")
{
prg.Keywords += string.Format(",k{0}", (int)GROUPS.PREMIERES + 1);
prg.Keywords += "," + sdMxf.With[0].KeywordGroups[(int)GROUPS.PREMIERES].getKeywordId("Miniseries Premiere");
}
}
// now add the real categories
if (sd.Genres != null)
{
foreach (string genre in sd.Genres)
{
string key = sdMxf.With[0].KeywordGroups[(int)group].getKeywordId(genre);
List <string> keys = prg.Keywords.Split(',').ToList();
if (!keys.Contains(key))
{
prg.Keywords += "," + key;
}
}
}
if (prg.Keywords.Length < 5)
{
string key = sdMxf.With[0].KeywordGroups[(int)group].getKeywordId("Uncategorized");
prg.Keywords += "," + key;
}
}
}
public object GetRecentChatedFriend(string username)
{
try
{
using (var db = SugarContext.GetInstance())
{
//获取全部最近聊天记录
var records = db.Queryable <NEWEST_CHAT_RECORD>().Where(c => c.GROUP_ID.Contains(username)).ToList();
var dic = new Dictionary <string, string>();
foreach (var ds in records)
{
var users = ds.GROUP_ID.Split(';');
var friend_id = users.First(x => x != username);
dic[friend_id] = ds.NEWEST_CHAR_RECORD.Replace("\r\n", "").Replace("\n", "").Substring(0, ds.NEWEST_CHAR_RECORD.Length > 20 ? 20 : ds.NEWEST_CHAR_RECORD.Length);
}
var rs = db.Queryable <GROUPS>().Where(x => x.STATE == "A").ToList();
var list = new List <GROUPS>();
var group = rs.Where(c => c.GROUP_NAME != "friend").ToList();
foreach (var ds in group)
{
var user = ds.USERS.Split(';');
if (user.Contains(username))
{
var m = new GROUPS
{
USERS = username,
GROUP_ID = ds.GROUP_ID,
GROUP_NAME = ds.GROUP_NAME
};
list.Add(m);
}
}
var friend = rs.Where(x => x.GROUP_NAME == "friend").ToList();
foreach (var ds in friend)
{
var user = ds.USERS.Split(';');
if (user.Contains(username))
{
var friends = ds.GROUP_ID.Split(';').ToList();
var friend_id = friends.Where(c => c != username).FirstOrDefault();
var friend_info = db.Queryable <SYS_USER>().Where(e => e.USER_NAME == friend_id).ToList().FirstOrDefault();
if (friend_info != null)
{
var m = new GROUPS
{
USERS = username,
GROUP_ID = string.Join(';', friends.OrderBy(c => c.Length).OrderBy(c => c[0])),
GROUP_NAME = friend_info?.DISPLAY_NAME,
ID = friend_info?.IMG,
USER_CREATED = dic.ContainsKey(friend_id) ? dic[friend_id] : ""//NEWEST_CHAT_RECORD
};
list.Add(m);
}
}
}
return(list.Where(c => !string.IsNullOrEmpty(c.USER_CREATED)).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
