public IEnumerable<HMS_LUContext> GetAll() { List<HMS_LUContext> HMSs = new List<HMS_LUContext>(); using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Array.ForEach(db.Login_User.OrderBy(m => m.UID).ToArray(), m => HMSs.Add(new HMS_LUContext { UID = m.UID, U_Login = m.U_Login, U_Passwd = m.U_Passwd, U_FirstName = m.U_FirstName, U_LastName = m.U_LastName, U_Gender = m.U_Gender, U_Phone = m.U_Phone, U_Email = m.U_Email, U_Address = m.U_Address, U_NiceName = m.U_NiceName, U_BirthDay = m.U_BirthDay.Value.ToString("yyyy/MM/dd") })); } return HMSs.AsEnumerable(); }
public HMS_LUContext Remove(string UID) { HMS_LUContext message; using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Login_User m = db.Login_User.Where(c => c.UID == UID).FirstOrDefault(); if (m == null) { return null; } else { message = new HMS_LUContext { UID = m.UID, U_BirthDay = m.U_BirthDay.Value.ToString("yyyy/MM/dd"), U_Login = m.U_Login, U_Passwd = m.U_Passwd }; db.Login_User.Remove(m); db.SaveChanges(); } } return message; }
public HMS_LUContext Add(HMS_LUContext msg) { SqlConnection Conn = new SqlConnection(); Conn.ConnectionString = WebConfigurationManager.ConnectionStrings["HMSConnectionString"].ConnectionString; SqlCommand cmdtop1 = new SqlCommand("select TOP 1 UID from Login_User ORDER BY UID DESC", Conn); string newUID = null; Conn.Open(); object obj = cmdtop1.ExecuteScalar(); Conn.Close(); if (obj != null) { Conn.Open(); var dateNo = DateTime.Now.ToString("yy"); var monthNo = DateTime.Now.ToString("MM"); string dr = cmdtop1.ExecuteScalar().ToString(); int drpluse = Convert.ToInt32(dr.Substring(5, 7)); drpluse++; string UNO = drpluse.ToString(); string showGF = UNO.PadLeft(7, '0'); newUID = "H" + dateNo + monthNo+ showGF.ToString(); Conn.Close(); } else { newUID = "H13070000001"; } Conn.Close(); Login_User message = new Login_User { UID = newUID, U_Login = msg.U_Login, U_Passwd = msg.U_Passwd, U_FirstName = msg.U_FirstName, U_LastName = msg.U_LastName, U_Gender = msg.U_Gender, U_Phone = msg.U_Phone, U_Email = msg.U_Email, U_Address = msg.U_Address, U_NiceName = msg.U_NiceName, U_BirthDay = Convert.ToDateTime(msg.U_BirthDay) }; //doesn't have GP using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { db.Login_User.Add(message); db.SaveChanges(); msg = new HMS_LUContext { UID = message.UID, U_Login = message.U_Login, U_Passwd = message.U_Passwd,U_FirstName = message.U_FirstName,U_LastName=message.U_LastName,U_Gender=message.U_Gender,U_Phone=message.U_Phone,U_Email = message.U_Email,U_Address = message.U_Address,U_NiceName=message.U_NiceName, U_BirthDay = message.U_BirthDay.Value.ToString("yyyy/MM/dd") }; } return msg; }
public bool Update(HMS_LUContext msg) { bool blResult = false; using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Login_User m = db.Login_User.Where(c => c.UID == msg.UID).FirstOrDefault(); if (m == null) { return blResult; } else { m.U_Login = msg.U_Login; m.U_Passwd = msg.U_Passwd; m.U_FirstName = msg.U_FirstName; m.U_LastName = msg.U_LastName; //m.U_Gender = msg.U_Gender; //m.U_Phone = msg.U_Phone; //m.U_BirthDay = Convert.ToDateTime(msg.U_BirthDay); db.SaveChanges(); blResult = true; } } return true; }
public bool Update(HMS_ManageHealth msg) { bool blResult = false; using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Manage_Health m = db.Manage_Health.Where(c => c.UID == msg.UID).Where(c => c.MHID == msg.MHID).FirstOrDefault(); if (m == null) { return blResult; } else { m.H_Alert1 = msg.H_Alert1; m.H_Alert2 = msg.H_Alert2; m.H_Alert3 = msg.H_Alert3; db.SaveChanges(); blResult = true; } } return true; }
public HMS_ManageHealth Remove(string UID, string MHID) { HMS_ManageHealth message; using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Manage_Health m = db.Manage_Health.Where(c => c.UID == UID).Where(c => c.MHID == MHID).FirstOrDefault(); if (m == null) { return null; } else { message = new HMS_ManageHealth { UID = m.UID,MHID = m.MHID }; db.Manage_Health.Remove(m); db.SaveChanges(); } } return message; }
public IEnumerable<HMS_ManageHealth> GetMH() { List<HMS_ManageHealth> MH = new List<HMS_ManageHealth>(); using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Array.ForEach(db.Manage_Health.OrderBy(m => m.UID).ToArray(), m => MH.Add(new HMS_ManageHealth { MHID = m.MHID, UID = m.UID, HID = m.HID, H_Alert1 = m.H_Alert1, H_Alert2 = m.H_Alert2, H_Alert3 = m.H_Alert3 })); } return MH.AsEnumerable(); }
public HMS_ManageHealth Add(HMS_ManageHealth msg) { SqlConnection Conn = new SqlConnection(); Conn.ConnectionString = WebConfigurationManager.ConnectionStrings["HMSConnectionString"].ConnectionString; SqlCommand cmdtop1 = new SqlCommand("select TOP 1 MHID from Manage_Health ORDER BY MHID DESC", Conn); string newMHID = null; Conn.Open(); object obj = cmdtop1.ExecuteScalar(); Conn.Close(); if (obj != null) { Conn.Open(); var dateNo = DateTime.Now.ToString("yy"); var monthNo = DateTime.Now.ToString("MM"); string dr = cmdtop1.ExecuteScalar().ToString(); int drpluse = Convert.ToInt32(dr.Substring(5, 7)); drpluse++; string UNO = drpluse.ToString(); string showGF = UNO.PadLeft(7, '0'); newMHID = "MH" + dateNo + monthNo + showGF.ToString(); Conn.Close(); } else { newMHID = "MH13070000001"; } Conn.Close(); Manage_Health message = new Manage_Health { MHID = newMHID, UID = msg.UID, HID = msg.HID, H_Alert1 = msg.H_Alert1, H_Alert2 = msg.H_Alert2, H_Alert3 = msg.H_Alert3 }; //doesn't have GP using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { db.Manage_Health.Add(message); db.SaveChanges(); msg = new HMS_ManageHealth { MHID = newMHID, UID = message.UID, HID = message.HID, H_Alert1 = message.H_Alert1, H_Alert2 = message.H_Alert2, H_Alert3 = message.H_Alert3 }; } return msg; }
public IEnumerable<HMS_Health_Item> GetHI() { List<HMS_Health_Item> HI = new List<HMS_Health_Item>(); using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Array.ForEach(db.Health_Item.OrderBy(m => m.HIID).ToArray(), m => HI.Add(new HMS_Health_Item { HIID = m.HIID, H_Name = m.H_Name, H_Comment = m.H_Comment })); } return HI.AsEnumerable(); }
public IEnumerable<HMS_Group> GetGP() { List<HMS_Group> GP = new List<HMS_Group>(); using (HealthManageSystemEntities db = new HealthManageSystemEntities()) { Array.ForEach(db.Group.OrderBy(m => m.GID).ToArray(), m => GP.Add(new HMS_Group { GID = m.GID, UID = m.UID ,G_Name = m.G_Name,G_Open=m.G_Open})); } return GP.AsEnumerable(); }