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);
}
}
