public string SelectLastLoginOnUserId(string intUserId) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { string LastLoginDate = ""; tblLogDetail objtblLogDetail = (from mast in db.tblLogDetails where mast.User_Id == intUserId select mast).FirstOrDefault(); if (objtblLogDetail != null) { LastLoginDate = Convert.ToString((from LD in db.tblLogDetails where LD.User_Id == intUserId select LD.Login_DateTime).Max()); } objtblLogDetail = null; return(LastLoginDate); } }
public Int64 UpdateLogDetails(Int64 LogId, bool LoginStatus) { Int64 value = 0; Int32 intCompIdno = 1; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblLogDetail objtblLogDetail = (from mast in db.tblLogDetails where mast.Id == LogId select mast).FirstOrDefault(); if (objtblLogDetail != null) { objtblLogDetail.Logout_DateTime = System.DateTime.Now; objtblLogDetail.Login_Status = LoginStatus; db.SaveChanges(); value = LogId; } } return(value); }
public Int64 InsertLogDetails(string UserId, string LoginEmail, string IPAddress, bool LoginStatus) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { Int64 value; Int32 intCompIdno = 1; tblLogDetail ObjtblLogDetail = new tblLogDetail(); ObjtblLogDetail.User_Id = UserId; ObjtblLogDetail.User_LoginEmail = LoginEmail; ObjtblLogDetail.IPAddress = IPAddress; ObjtblLogDetail.Login_DateTime = System.DateTime.Now; //ObjtblLogDetail.Logout_Date = System.DateTime.Now; ObjtblLogDetail.Login_Status = LoginStatus; db.AddTotblLogDetails(ObjtblLogDetail); db.SaveChanges(); value = ObjtblLogDetail.Id; return(value); } }