public void EditSession(SC_LoginHistory sessionobj) { string query = "Update SC_LoginHistory set LogOutDate = @LogOutDate,OrganizationId=@OrganizationId where LoginId = @LoginId"; using (var db = DbHelper.GetDBConnection()) { db.Execute(query, sessionobj); } }
public void AddSession(SC_LoginHistory mS_Country) { string query = "Insert into SC_LoginHistory (LoginId, UserId, LoginDate, RoleId,OrganizationId,ActualOrganizationId,LogOutDate)" + " values (NEWID(), @UserId, @LoginDate, @RoleId, @OrganizationId,@ActualOrganizationId,@LogOutDate)"; using (var db = DbHelper.GetDBConnection()) { db.Execute(query, mS_Country); } }